> Shawn Honeychurch wrote:
>
> Hi;
>
> Can someone tell me why after i delete all the items form my database,
> when I add new items the ID numbers continue counting from where they
> left off from the old items? Also how do i stop this from happening?
I supspect that you are deleting all records from one of the tables in
the database? If you use the admin meny's function for deleting items, I
belive everything is deleted. If that is to much work, you shuld make a
dump of the database and look at witch tables are involved in the item
system. I belive there are four tables that all together creates the
system of items and skus.
>
> One other question. How do i force the SKU numbers to be the same as
> the Item numbers? I am not going to use multiple SKU's and would like
> the SKU's and Items to match.
I suppose if you handle the data from 0 and add one records item and one
to sku it will, because it is numbered from 1.
You can also create a database dump from a desktop database, and control
it that way. I myself get data from customers in a access or simular
file, and create's a sql dump in Filemaker. (Would you belive it :-))
I don't know if you use phpMyAdmin, but that will help if you need to
look at the database, or perform dumps or simular.
Bjarne
> Thanks
>
> Shawn
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
