Empty data tables - Check

[CF_starter]

How can I check to see if a data table is empty so that I can set the ID value the first time?

thanks

[mxstu]

I assume "ID" is not some sort of auto incrementing record ID column?

It depends on your database. In an ms sql database, you could use "if not
exists ...". You could also count the number of records in the table and if it
is zero, execute some code.

--- ms sql database
if not exists (select someColumn from yourTable)
begin
do something here...
end

[Dan Bracuk]

select count(id) as thecount from mytable

I assume you have a plan for setting the id field the first time, and incrementing it.

[chuckbeckwith]

You probably need to know what the ID is for your programming.
Try looking up @@identity. It will tell you the ID AFTER the insert query.

[CF_starter]

Yes, I do have a plan for setting the record. I am going use MS-SQL 2000 as
the finished product. Right now I'm testing with MS-Access. I'm just trying to
figure out how to do it, I tried MAX but got no value back.

g

[mxstu]

If you are using Access and migrating to SQL Server, why not just use an
autonumber column and run SELECT @@IDENTITY after your inserts like
chuckbeckwith suggested? (Note - You will need to wrap both the INSERT and
SELECT @@IDENTITY queries in a CFTRANSACTION) Then when you migrate to SQL
Server the autonumber column will likely become an identity column and you can
use one of SQL Server's identity functions.