From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | "Frank L(dot) Parks" <fparks(at)ezbizpartner(dot)com>, Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Interface |
Date: | 2006-05-10 22:41:01 |
Message-ID: | 44626BFD.3090405@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
>
> ---------------------------(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/
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2006-05-10 22:55:50 | Re: Interface |
Previous Message | Bob Pawley | 2006-05-10 22:04:23 | Re: Interface |