| From: | Luis Dolz <ldolz(at)arnet(dot)com(dot)ar> |
|---|---|
| To: | "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Insert with ODBC Driver |
| Date: | 1999-04-14 02:37:00 |
| Message-ID: | 01BE8606.9FDAE080@host020175.arnet.com.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all:
I have the following problem
I generate programs in visual Fox using ODBC drivers, I can make execute remote consults with SQLEXEC, but I can't insert records. The program is:
STORE SQLCONNECT('PostgreSQL') TO gnConnHandle
IF gnConnHandle <= 0
MESSAGEBOX('No se puede conectar', 16, 'Error SQL')
ELSE
CURSORSETPROP('UpdateType' , .T. , 'alumnos') ** alumnos is a cursor
SQLSETPROP(gnConnHandle, 'Transactions', 2) ** set manual transactions
SQLEXEC(gnConnHandle, "INSERT INTO datos VALUES (46, 'Dolz', 'Luis')") , 'alumnos')
SQLCOMMIT(gnConnHandle) ** Save changes
SQLDISCONNECT(gnConnHandle)
ENDIF
If anyone works with Postgres(6.3.2) in Linux and Visual Fox in Windows and make data insertion with SQLEXEC, please send me the answer.
Thanks.
Luis A. Dolz
Catamarca
Argentina
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Thompson | 1999-04-14 02:57:53 | Would this project be of interest to anyone? |
| Previous Message | Guo Ge | 1999-04-14 01:56:46 | about transaction |