Results 1 to 2 of 2

Thread: SQL question..

  1. #1
    Join Date
    Nov 2003

    SQL question..

    I got this SQL txt:

    SQL = "CREATE TABLE tabel_01( ID varchar, Webnaam varchar, Bezoeken integer)"

    What I want now is that the column ID isn't varchar but it's a Auto numbering column. How can I do this...??

  2. #2
    Join Date
    Jan 2004
    Melbourne, Australia
    You have to specify the Counter daya type. It takes two parameters, the starting number and the incremention.
    SQL = "CREATE TABLE tabel_01( ID Counter(1,1), Webnaam varchar, Bezoeken integer)"
    The preceding code tells the database application what you want to have an auto incrementing field which starts at one, and is incremented by one each time a record is entered.

    Andrew Buntine.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

Recent Articles