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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.