From: | Geoffrey Clements <geoff(at)electron(dot)me(dot)uk> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problem inserting with remote views in vfp |
Date: | 2006-04-21 21:28:55 |
Message-ID: | 200604212228.55600.geoff@electron.me.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I'm in the process of converting a Visual FoxPro application from using local
tables to using a postgresql backend on a Debian box with psqlODBC on Windows
Xp.
I've set up the database server with the necessary tables containing test data
and using a remote view in VFP I can browse and update data. However when I
insert a row into the view and try to commit the change to the server I get
an error message saying that the null value for the primary key conflicts
with the non-null constraint, however the data that I am inserting is
non-null for the primary key.
Any help would be appreciated as I've run out of ideas on how to fix this.
--
Geoff Registered Linux user 196308
From | Date | Subject | |
---|---|---|---|
Next Message | Benjamin Krajmalnik | 2006-04-21 21:51:09 | Re: Problem inserting with remote views in vfp |
Previous Message | Dave Page | 2006-04-21 14:17:27 | Re: snapshot/switch version number |