Tim

As a DBISAM user at least I will try to ask you if could be possible to define a property in ElevateDB that does not demand required fields in the compound indexes in PK. In my new projects started with ElevateDB they are all required but I have some applications built with DBISAM that have compound indexes with fields non required in primary key.

Thanks in advance

Jose


From memory, and because I asked for it as well, I think you will find the answer is no. Its part of the sql spec.

Roy Lambert

Roy Lambert wrote:

<<
From memory, and because I asked for it as well, I think you will find the answer is no. Its part of the sql spec.
>>

I understand the point and agree with following SQL specs but I am still in DBISAM and it is very hard to migrate data and source code in these situations. Of course Tim has his reasons to do or not do this (I don´t know how hard it is) but in my opinion it will help DBISAM users to convert the applications easily.

Note that I am just asking for a property to change the default behaviour of ElevateDB.

But, let´s wait Tim´s answer and his point of view.

Jose


>But, let´s wait Tim´s answer and his point of view.

If he builds it in now I (and I suspect a few others) will jump up and down and scream whilst holding our breaths until we turn blue

Roy

Eduardo,

<< As a DBISAM user at least I will try to ask you if could be possible to define a property in ElevateDB that does not demand required fields in the compound indexes in PK. In my new projects started with ElevateDB they are all required but I have some applications built with DBISAM that have compound indexes with fields non required in primary key.  >>

What you want is a unique key, not a primary key.  Unique keys allow for NULLs, but otherwise can be used just like primary keys with foreign-key relationships, etc.

Likewise, when you perform the migration of a DBISAM database, you can set the ConvertPrimaryToUnique parameter to True to automatically convert your primary indexes in DBISAM to unique keys in EDB.

Tim Young
Elevate Software
www.elevatesoft.com