Question on querying/retrievning data from Database

aqua267 · Post by **aqua267** » Tue Jan 04, 2011 8:57 pm

I am trying to retrieve data from my database.

Let>str=Driver={SQL Server};Server=;Database=;Uid=;Pwd=str,dbH
//dbH returns 1 - Does this imply the connection was established?

Let>SQL=Select top 10 * from Table
DBExec>dbH,SQL,result,numRecs,numFields
MessageModal>numRecs
MessageModal>numFields

//When I print numRecs, numFields - the exact text gets printed, not the numbers.

Please help. Thanks.

aqua267 · Post by **aqua267** » Tue Jan 04, 2011 9:47 pm

Nevermind..I figured it out. I was using DbExec instead of DbQuery.