Board index » delphi » SQL Help Needed, Please

SQL Help Needed, Please

I'm trying to create a "row number" column in SQL. I need a unique
record ID. Is there a function or command or some "cool" trick that
will do this for me using the BDE and .DBF's?

I need to be able to do this in SQL rather than Delphi code.


Bill Artemik
Programmer / Analyst

"The number one CAUSE of computer problems
     is computer SOLUTIONS."


Re:SQL Help Needed, Please

No. If your database has some type of autonumber generation feature for
surrogate keys (and most do) the number generation is handled by the DBMS. I
know of no SQL dialect that supports this.


Other Threads