www.webdeveloper.com
Results 1 to 2 of 2

Thread: SQL question..

  1. #1
    Join Date
    Nov 2003
    Posts
    287

    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
    Location
    Melbourne, Australia
    Posts
    5,298
    You have to specify the Counter daya type. It takes two parameters, the starting number and the incremention.
    Code:
    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.

    Regards,
    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