Re: examples VFP with Postgresql - Mailing list pgsql-odbc

2007/3/8, ionut ichim <ionutichim@hotmail.com>:
> Thanks for answer.
> I'm interest how can i work with pg +VFP ... connections,sored
> procedures,backup ,etc
>   Some links for simple examples, to test.

First at all I'm using sqlpassthrough:

a.Create connection:
_Conn=SQLCONNECT('<ODBC Conn>','<user>','<pwd>')

b.Run sql statement
lResult=SQLEXEC(_Conn,"SELECT field1, field2... FROM table","<cursor_name>")
IF lResult>0
   * all goes fine
ELSE
   MESSAGEBOX(MESSAGE())
ENDIF

c.Disconnect
lResult=SQLDISCONNECT(_Conn)

Stores procedures, functions is like any other sql statement using psql.
Backups -> RTFunnyM

Alejandro