[GENERAL] updating records

2003-10-03 Thread Gene Vital
Hi all. I am using Visual FoxPro via ODBC to update records on a 7.3.4 PostgreSql server and it appears that it always uses delete/insert instead of updating the current record. Can this be changed to update the existing record instead? -- Eugene Vital Any technology indistinguishable from m

Re: [GENERAL] Parent Id

2003-10-09 Thread Gene Vital
s is a test") insert into wsoptions (stations_id, type, data) values( , "LOCATION", "10th floor outer, office 27") thanks Bruno Wolff III wrote: On Thu, Oct 09, 2003 at 15:55:27 -0400, Gene Vital <[EMAIL PROTECTED]> wrote: have an example :) Bruno

Re: [GENERAL] Pgsql on Windows

2003-10-13 Thread Gene Vital
Matthew T. O'Connor wrote: I don't see how ODBC fits in to this at all. There is no need for ODBC if postgresql is running via cygwin, running on a remote linux box, or even native on windows. I am new to PostgreSQL what other options are available to connect then ? -- Eugene Vital Any technolog

[GENERAL] ODBC

2003-10-15 Thread Gene Vital
PostgreSQL I am using Microsoft Visual FoxPro to connect VIA ODBC using both a DSN connection and a DSNLess Connection. The DSNLess connection is Wy... slower than the DSN connection and I am having a problem trying to figure out what ODBC settings affect performance this much. using DSN