An Oracle Auto Generated Id Issue

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 16 Apr 2003 14:47:14 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703901283@lnewton.leeds.lfs.co.uk>

Hi Ramon,

glad you got it sorted out.

I'm unable to comment on the fact that Access and/or SQLServer databases work fine without haveing a value supplied for 'mandatory' columns. This implies that either the driver between VBA and the database is broken, or, the database has no way to inform the driver (and so the application) that certain columns are mandatory.

I've certainly always had to inform the driver system (BDE or whatever in Delphi/BCB) that some fields were indeed mandatory in the database, but not in the application. I presume that the system still works fine on these other databases with the setting turned on for Oracle ? If so, you shouldn't have a problem.

Please baer in mind that Access is a desktop database, rather than a proper client server database - and I'm not too sure about SQLServer - it claims to be Client Server but people keep finding things that don't work - I cannot comment personally as we only use it here for ourt help desk system, and that is not very good :o)

Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: ramon_at_caribsurf.com (ryan) [mailto:ramon_at_caribsurf.com] Posted At: Wednesday, April 16, 2003 1:40 PM Posted To: server
Conversation: An Oracle Auto Generated Id Issue Subject: Re: An Oracle Auto Generated Id Issue

Hi Norm and greetings to the others who responded

Let me say that yes, the component that I am using to manipulate the data from the Oracle database does allow me to specify that the primary key is not required and I had to use that property from the time I was getting the problem.

However as I did not have to do when connecting to a SQL Server or Access database I was wondering if there was some other feature somewhere that I was unaware of that would allow me to use the component in the same manner for all database backends.

Once again thanks to all that responded. I will continue to use this non-required feature of the component until I see a better solution.
I am hoping there is.

Ryan
fe Received on Wed Apr 16 2003 - 08:47:14 CDT