Page 3 of 3
Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 1:29 am
by MarioG
SORRY Mr Rao!
I found my error. I assigned my query to a var:
Code: Select all | Expand
cSelect:= "SELECT Count(ID) FROM " +::cTablaSys + " WHERE APPNAME='"+cAppName+"'"
And after, I do
Very sorry
Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 2:59 am
by nageswaragunupudi
First, try this simple program.
Code: Select all | Expand
oRs := FW_OpenRecordSet( oCn, "select * from TbConfig" )
XBROWSER oRs
oRs:Close()
Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 4:30 pm
by 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
Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 5:13 pm
by nageswaragunupudi
With ADO,
is the only way, unless you use FWH TRecSet class.
ADO from here
https://www.w3schools.com/asp/ado_intro.aspGood tutorial for SQL
https://www.w3schools.com/sql/
Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 7:03 pm
by MarioG
Thanks Mr. Rao