SPT ?? Help Please

[nengie]

I have cursor in VFP (cr_item)
Then with VFP table I can do this

select itemno, itemdesc from itemmaster
where itemno not in (select itemno from cr_item)

But if itemmaster is table in MS SQL, how can I do it with SPT ? TIA

 

[Leland123]

Hi nengie,

I have written a VFP7 front-end client that connects to a postgres back-end database server. The code in the free example application could be slightly modified to work with MSSQL. The application can be downloaded from:

http://www.smvfp.com

It can be found under option 21 after you enter the site.

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox

 

[AChiado]

Hi nengie,

you can access your data in MS SQL Server trought ODBC.

Define an ODBC connection to your SQL database, then connect:

nConnHandle=sqlconnect("YOURCONNECTION&quot

cSql="select itemno, itemdesc from itemmaster
where itemno not in (select itemno from cr_item)"

sqlexec(nConnHandle, cSql, "MYCURSOR&quot
browse
Andrea C.P.
Italy

 

[nengie]

Thanks Leland, I will give it a try
Thanks Andrea