Using DBISAM v4.23b2, I can create a column called "RecordID".
Unfortunately I cannot get at the data in this column because DBISAM
supplies its own internal record ID.  I don't have a problem with that,
but perhaps DBISAM should not allow columns called "RecordID" to be
created by the user.  "RecordID" is not such an unlikely column name for
someone to choose, and this measure would save such twits as me a bit of
time.


  Oliver

Oliver,

<< Using DBISAM v4.23b2, I can create a column called "RecordID".
Unfortunately I cannot get at the data in this column because DBISAM
supplies its own internal record ID.  I don't have a problem with that, but
perhaps DBISAM should not allow columns called "RecordID" to be created by
the user.  "RecordID" is not such an unlikely column name for someone to
choose, and this measure would save such twits as me a bit of  time. >>

How are you creating the table ?  I tried the following and it raises an
error as expected:

CREATE Table Test (RecordID Integer);

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> How are you creating the table ?  I tried the following and it raises an
> error as expected:
>
> CREATE Table Test (RecordID Integer);

I'm using the old SELECT ... INTO trick

Now that I try it in DBSYS I can see that it is automatically renamed to
RecordID_1.  I suppose this is similar to writing

 select ID, ID
   into T2
   from T1

in which case I guess the SQL standard mandates an automatic column
rename rather than an error.  So, I suppose DBISAM is not being
unreasonable.


  Oliver

Oliver,

<< I'm using the old SELECT ... INTO trick >>

Ahh.

<< Now that I try it in DBSYS I can see that it is automatically renamed to
RecordID_1.  I suppose this is similar to writing

 select ID, ID
   into T2
   from T1

in which case I guess the SQL standard mandates an automatic column rename
rather than an error.  So, I suppose DBISAM is not being unreasonable. >>

Correct, which means the SQL bug score is now:

Oliver:   200+
Elevate: 1



Seriously though, you've been a big help in finding and squashing some
significant bugs that have gotten past us.

--
Tim Young
Elevate Software
www.elevatesoft.com