Quiero comenzar con sqlite

[MarioG]

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

Code: Select all

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

And after, I do

Code: Select all

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

Very sorry

[nageswaragunupudi]

First, try this simple program.

Code: Select all

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

[MarioG]

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

[nageswaragunupudi]

With ADO,

Code: Select all

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/

[MarioG]

Thanks Mr. Rao