From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | "Frank L(dot) Parks" <fparks(at)ezbizpartner(dot)com>, Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Interface |
Date: | 2006-05-10 22:04:23 |
Message-ID: | 00d301c6747d$b23aa680$8e904618@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)ezbizpartner(dot)com>
To: "Postgresql" <pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-05-10 22:41:01 | Re: Interface |
Previous Message | Richard Huxton | 2006-05-10 20:00:02 | Re: understanding explain data |