To refresh people's memory I have a simple Delphi interface (TEdit and
TNavigator) connected via ODBC to a Postgresql 8.0 table.
I've tried the earlier suggestions in various forms with no success.
I again was successful in updating the table with the table containing no
serial column. With the serial column included I get an error massage that
the serial column needs a value.
I don't understand why the serial column is generated when a row is created
manually through Postgresql Admin interface but it doesn't generate when a
row is added through the Delphi interface.
Could someone explain this difference?
Bob Pawley
----- Original Message -----
From: "Bob Pawley" <rjpawley@xxxxxxx>
To: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
Cc: "Frank L. Parks" <fparks@xxxxxxxxxxxxxxxx>; "Postgresql"
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, May 10, 2006 3:55 PM
Subject: Re: [GENERAL] Interface
Joshua
My first try was to include it with the SQL code on the Update component.
It hasn't worked yet. I want to try variations.
I am also trying a Query component which gave me the same error. I also
have another problem with this component giving me a cursor handle error
which I am attempting to solve. (Same SQL code)
Lots of challenges for a beginner to work through.
Bob
----- Original Message -----
From: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Frank L. Parks" <fparks@xxxxxxxxxxxxxxxx>; "Postgresql"
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, May 10, 2006 3:41 PM
Subject: Re: [GENERAL] Interface
Bob Pawley wrote:
Hi Frank
Here's the code entered as part of TUpdateSQL component.
insert into p_id.p_id
(process_name)
values
(:process_name)
Did my DEFAULT not work?
Joshua D. Drake
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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
