Author: Guillermo AriasGuillermo Arias
Date: Jan 27, 2007 16:23
Hi people, this is Guillermo, from Perú.
I would like you to give some suggestions about my problem
I'm Using DB Postgre + VFP. Initially i thought using a DBC database +
remote views, but mi app will not work that way, because i am using
Postgre Schemas, and that is like little DB inside one only DB.
That is why i thought creating self made remote view, i mean to say
Updateable cursors writing some code, they work fine, and consist on:
1- Load the cursor from DB with SQLEXEC(lc_conex,"SELECT * FROM
MITABLA","MICURSOR")
2- Some code with CURSORSETPROP in order that the cursor be updateable
and send data to my DB.
As you realize, my problem is in step 1. But i read that exists some
alternatives for do not bring all the records.
- A sentence SQLSETPROP with parameter of conection 0 can set by
default the way SQLEXEC communicates with the DB.
- Also i can use CURSORSETPROP with parameter nWorkArea=0 for
establish by default tha way cursors work and load records.
|