FiveTech Software tech support forums

SORRY Mr Rao!
I found my error. I assigned my query to a var:

Code: Select all  Expand view

cSelect:= "SELECT Count(ID) FROM " +::cTablaSys + " WHERE APPNAME='"+cAppName+"'"

And after, I do

Code: Select all  Expand view

? "Consulta", ::oRSDB:Fields( 'ID' ):Value

Very sorry

First, try this simple program.

Code: Select all  Expand view

oRs := FW_OpenRecordSet( oCn, "select * from TbConfig" )
XBROWSER oRs
oRs:Close()
 

Thanks Mr. Rao
Two questions
1.- oRs:ID return 'the object not exist'
oRs:Fields( 'ID' ):Value is unique form?
2.- If I need Find/Seek; what can I do the seek?
Or tell me where read

Many thanks, again

With ADO,

Code: Select all  Expand view

oRs:Fields( 'ID' ):Value

is the only way, unless you use FWH TRecSet class.

ADO from here
https://www.w3schools.com/asp/ado_intro.asp

Good tutorial for SQL
https://www.w3schools.com/sql/

Thanks Mr. Rao