Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Sydney
    Posts
    15

    Unanswered: Creating autonumber field

    I simply want to use SQL code to create a table with an autonumber field.

    I use the code:
    sql = "CREATE TABLE tblFunctionList(functListID GUID CONSTRAINT primKey PRIMARY KEY,EmployeeInd INTEGER, funcInd INTEGER);"

    using the GUID....but it doesn't end up an autonumber..

    Any help would be greatly appreciated

    Thanks

  2. #2
    Join Date
    May 2002
    Location
    Atlanta, GA
    Posts
    117

    Smile

    Hey Simmo,

    This should help you out

    "CREATE TABLE ResCmplx (SomeID COUNTER, SomeTxt TEXT(65), etc...

    Let me know if you need anything else.

    Kal

Posting Permissions

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