Hi Frank
Here's the code entered as part of TUpdateSQL component.
insert into p_id.p_id
(process_name)
values
(:process_name)
I am connected via ODBC.
Thanks
Bob
----- Original Message -----
From: "Frank L. Parks" <fparks@xxxxxxxxxxxxxxxx>
To: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, May 10, 2006 12:30 PM
Subject: Re: [GENERAL] Interface
Bob,
Can you at least show what your insert statement looks like please?
Also, are you using ODBC or VitaVoom's direct driver for DBExpress?
Frank
Bob Pawley wrote:
The folks on the Delphi forum haven't been responsive to this
question. Perhaps the ones that visit the forum don't know the answer.
I have created a Delphi interface to a Postgresql table containing a
serial column.
When I try to insert a new value through the interface I get an error
message that the serial field requires a value.
When I remove the serial column the interface inserts a new value with
no problem. When I insert directly via sql the serial column updates
automatically.
What am I missing to make this work through Delphi?
Bob
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
