Skip site navigation (1) Skip section navigation (2)

Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel
Date: 2005-12-20 09:31:10
Message-ID: do8j19$25bk$1@news.hub.org (view raw or flat)
Thread:
Lists: 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. 



In response to

pgsql-odbc by date

Next:From: zhaoxinDate: 2005-12-20 10:17:55
Subject: ODBC ErrorCode issue
Previous:From: =?iso-8859-1?q?Tomas_Sk=E4re?=Date: 2005-12-20 08:42:50
Subject: Re: patch for cleanup protocol

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group