Recent content by job419

I need to get the maximum value for a field in a table. Using the following statement, it is taking about 25 minutes to return the maximum value. SELECT max(notes.key) FROM notes I'm using the Merant ODBC driver, and there are over 9.5 million records in the table. Is there...

I'm having the same issue, when trying to update from vb.net. Have you found a solution to this?

Someone gave me the answer to this on experts-exchange. Had to let the ODBC driver do the conversion. UPDATE co SET LOGIFLD = { fn CONVERT ( '1' , SQL_BIT ) }

Hopefully this is the correct forum. First off, I'm not very familiar with Progress. I usually use SQL Server, but I have a client requirement to connect to Progress from a vb.net application. So far I've been having good luck with it but ran into a snag. I'm having trouble updating a logical...