From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
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:55:50 |
Message-ID: | 00e001c67484$e2d6c970$8e904618@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commandprompt(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Frank L. Parks" <fparks(at)ezbizpartner(dot)com>; "Postgresql"
<pgsql-general(at)postgresql(dot)org>
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(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/
>
>
>
> ---------------------------(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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-11 00:28:57 | Re: PG_CONFIG MISSING |
Previous Message | Joshua D. Drake | 2006-05-10 22:41:01 | Re: Interface |