[ic] Creating UNIQUE NUMBER

[interchange-users@interchange.redhat.com (Alma Nuker)]

Thanks Ed, it is working now fine.

For future reference I did following:

I created new counter inside etc/

etc/new.number

set it as follow:

#COUNTER-1.0
what every you want number to start from eg. TEST000

In my form I made reference to new counter as follow:

[seti my_id][counter etc/new.number][/seti]

my_id is primary key in my db so I reference it as follow in mydb.mysql
file:

Database mydb  mydb.txt   __SQLDSN__
ifdef SQLUSER
Database mydb  USER         __SQLUSER__
endif
ifdef SQLPASS
Database  mydb  PASS         __SQLPASS__
endif
Database  mydb  KEY           my_id
Database  mydb  COLUMN_DEF   "my_id=INT(9) NOT NULL PRIMARY KEY"

etc..................

And rememeber to create mydb.txt file in products/ as follow:

my_id    other fileds (make sure that you have proper spacing in between
(TAB))

Thanks

Alma