topic-39167

Board index FiveWin for Harbour/xHarbour Quiero comenzar con sqlite

Page: 1 2 3 (35 posts)

MarioG

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 01:29 AM

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

Code (fw): Select all Collapse

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

And after, I do

Code (fw): Select all Collapse

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

Very sorry

Resistencia - "Ciudad de las Esculturas"

Chaco - Argentina

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 02:59 AM

First, try this simple program.

Code (fw): Select all Collapse

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

Regards

G. N. Rao.

Hyderabad, India

MarioG

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 04:30 PM

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

Resistencia - "Ciudad de las Esculturas"

Chaco - Argentina

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 05:13 PM

With ADO,

Code (fw): Select all Collapse

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/

Regards

G. N. Rao.

Hyderabad, India

MarioG

Posts: 1380

Joined: Fri Oct 14, 2005 01:28 PM

Re: Quiero comenzar con sqlite
Posted: Thu Aug 27, 2020 07:03 PM

Thanks Mr. Rao

Resistencia - "Ciudad de las Esculturas"

Chaco - Argentina

Page: 1 2 3 (35 posts)

FiveTech Support Forums

Continue the discussion