> 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.