Creating tables with Win32::ODBC

markkneen has asked for the wisdom of the Perl Monks concerning the following question:

Hi, Im trying to create a table using win32::ODBC
I can create the table fine and write data to the table but what I would like to do is specify the primary key as auto_increment.

ive seen examples but these dont work with win32::odbc. Can anyone point me in the right direction. or am I goin to have to use some other way to connect to the database

Thanks for you time.

Janitored by Arunbear - retitled from 'win32::odbc', as per Monastery guidelines

Comment on Creating tables with Win32::ODBC

Replies are listed 'Best First'.
Re: Creating tables with Win32::ODBC by hmerrill (Friar) on Nov 09, 2004 at 12:45 UTC
What database are you using?	[reply]
Re^2: Creating tables with Win32::ODBC by markkneen (Acolyte) on Nov 09, 2004 at 14:20 UTC
Database is MS access. Thanks for your reply. Mark.	[reply]
Re^3: Creating tables with Win32::ODBC by LanceDeeply (Chaplain) on Nov 09, 2004 at 15:14 UTC
googling came up w/ this example: Creating Autonumber Fields the example is in VB but the SQL you need is in there -hth	[reply]
Re^4: Creating tables with Win32::ODBC by markkneen (Acolyte) on Nov 09, 2004 at 16:33 UTC