Interface

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?

Try using DEFAULT as the serial value.. e.g;

INSERT INTO foo VALUES (DEFAULT, 'Hello');

Where DEFAULT is the serial column.

Sincerely,

Joshua D. Drake

Bob

--

=== 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/

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:

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@ezbizpartner.com>
To: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, May 10, 2006 12:30 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@ezbizpartner.com>
To: "Postgresql" <pgsql-general@postgresql.org>
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/

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@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Frank L. Parks" <fparks@ezbizpartner.com>; "Postgresql"
<pgsql-general@postgresql.org>
Sent: Wednesday, May 10, 2006 3:41 PM
Subject: Re: [GENERAL] Interface