Re: how to define a pseudo auto value column in oracle?

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Thu, 10 Feb 2005 14:10:20 +0100
Message-ID: <cufpno$39j$1$830fa17d@news.demon.co.uk>

Robert Wehofer wrote:
>
> You don't understand the problem. The problem is, that sequences don't allow
> database independent programming (by means of ADO). Most of database types
> do have the datatype Autovalue. Oracle don't support this datatype.
>
> Robert
>
>

Robert,

far be it from me to tell you how to do your job, but database independance actually means using the lowest common features of all the databases you wish to run the product on.

I've been there with Uniface - which does manage to do database independance quite well, better than anything else I've seen - but it still isn't perfect.

Firebird doesn't have 'autovalues' either - it has generators which are very similar to Oracle's sequences. So you won't be able to use your code on Firebird databases either. This is a shame as *I'd* rather code for Oracle or Firebird anyday.

If you really have to have 'one code fits all' then why not do everything via stored procedures and that way you won't have to worry about database dependencies.

Cheers,
Norm. Received on Thu Feb 10 2005 - 07:10:20 CST