Re: Interface

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(at)shaw(dot)ca>
To: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
Cc: "Frank L. Parks" <fparks(at)ezbizpartner(dot)com>; "Postgresql"
<pgsql-general(at)postgresql(dot)org>
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(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
>