creating new table in DB (autoincrement field)

[kristos_b]

Hi all,

I am using Database Connectivity Tool vi to create new table in the database. I was able to set the first column as primary key 'not null' but there is one option I could not find in this vi. I want to set the first column as auto-number (auto-increment). I tried to modify the query by adding there 'AUTO_INCREMENT' string but it gives me errors. Finally I opened the table in access and modified it but that is not ideal at all. Is there any way of doing that using connectivity tool?

Thanks,

Krystian

[jcarmody]

[kristos_b]

Thanks!