Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel - Mailing list pgsql-odbc

> Thanks a lot. Could you send copy here? So people could find solution
> in mail archive in the future.

Luf,

I posted a sample VFP 9 code which callas Postgres ODBC:

cConnString ="DRIVER={PostgreSQL Unicode};DATABASE=postgres;"+ ;
    "SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=aaaa;B9=0"
nconnh=SQLSTRINGCONNECT(cconnstring)
IF nconnh<=0
  LOCAL laerror[1]
  AERROR(laError)
  MESSAGEBOX( laerror[1,2])
  RETURN
  ENDIF

TEXT TO csql
CREATE temp table test ( test char(1));
insert into test values ('');
select 0 as foo, 1 as bar from test
ENDTEXT

oCadapter = CREATEOBJECT('cursoradapter')
oCadapter.DataSource= nconnh
oCadapter.DataSourceType ="ODBC"
oCadapter.SelectCmd = csql
oCadapter.CursorFill()
BROWSE


Andrus.