Search results

Hi, I am trying to run an ODBC query against a Progress 9.1D database and want to identify way to use index's or speed up my queries. Can I force the below query to use an index if there is one available. SELECT "debt1"."dt-clsearch", "debt1"."client-code", "debt1"."debt-code" FROM...

Re: MANGA Comics and Anime Community Thanks, any update on the questions asked.

Hi, I am running this through via a SQL command in Crystal reports connecting via ODBC, this is what I have so far, not sure whether the above will work within my select statement. SELECT DT."debt-code", DT."tx-date", DT."tx-time" cast(DT."tx-time" as time) FROM "PUB"."debt-trans" DT...

Hello, I have two fields in my database DT."tx-date" - Type Date DT."tx-time" - Type Varchar I want to convert these two fields into one so that I can find the maximum entry in my database for the current day, I have been looking at the cast function where I can convert the DT."tx-time"...