Create table with Autonumber field

Results 1 to 2 of 2

Thread: Create table with Autonumber field

  1. #1
    Gert Guest

    Default Create table with Autonumber field

    Executing the following sql statement causes an error. <BR>sql="CREATE TABLE Products (ProductNr AUTONUMBER, ProductName TEXT)"<BR>set rs=conn.execute(sql)<BR>How do I create a Table with an autonumber field????<BR>

  2. #2
    John Weeflaar Guest

    Default RE: Create table with Autonumber field

    I assume you are using Access:<BR><BR>sql="CREATE TABLE Products(ProdNr COUNTER, ProdName TEXT)"<BR><BR>John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •