Re: Interface
От | Bob Pawley |
---|---|
Тема | Re: Interface |
Дата | |
Msg-id | 027c01c67e89$c58d7800$8e904618@owner обсуждение исходный текст |
Ответ на | Re: Interface (Bob Pawley <rjpawley@shaw.ca>) |
Список | pgsql-general |
Thanks Tony I installed PostgresDAC and it cleared up the problem. Bob ----- Original Message ----- From: "Tony Caduto" <tony_caduto@amsoftwaredesign.com> To: "Jim C. Nasby" <jnasby@pervasive.com> Cc: "Bob Pawley" <rjpawley@shaw.ca>; "Postgresql" <pgsql-general@postgresql.org> Sent: Monday, May 22, 2006 1:54 PM Subject: Re: [GENERAL] 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 >>> >>> > This is a issue with the design time components and also occurs for > Interbase/Firebird Generator (same thing as a sequence) > > See this google link: > > http://groups.google.com/group/comp.lang.pascal.delphi.databases/browse_thread/thread/72e87907b66a6923/153daefcdf7a5d9a?lnk=st&q=delphi+interbase+grid+generator&rnum=1&hl=en#153daefcdf7a5d9a > > Another one: > > http://groups.google.com/group/borland.public.interbase/browse_thread/thread/dd2e2975f2119f2c/8ca7149bac382cc5?lnk=st&q=delphi+interbase+grid+generator&rnum=22&hl=en#8ca7149bac382cc5 > > I am assuming you are using the serial field as the PK, so you could also > set the PK property to not required as in the last link. > > This is related to ODBC though, you might really want to look at Zeos or > PostgresDAC which are native delphi tdataset and have this issue taken > care of internally. > I have never had this problem with either Zeos or PostgresDAC. > > Hope this helps, > > -- > Tony Caduto > AM Software Design > http://www.amsoftwaredesign.com > Home of PG Lightning Admin for Postgresql > Your best bet for Postgresql Administration > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
В списке pgsql-general по дате отправления: