Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 General help me questions
 Resetting categories and products		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

savage943
Starting Member

USA
26 Posts
Posted - June 09 2006 :  06:59:56  Show Profile  Visit savage943's Homepage  Reply with Quote
I would like to reset both of these to 1, however, they both insist on going to the next number in the sequence. With the package came 61 products and 19 categories. I deleted them all and then added a new category and product. The new category is 19 and the product is 62. Have run the convertcategories.asp and convertproducts.asp, but still the same results.

devshb
Senior Member

United Kingdom
1904 Posts
Posted - June 09 2006 :  07:29:58  Show Profile  Visit devshb's Homepage  Reply with Quote
strange coincidence, I just posted something relevant on a previous message:

http://vpasp.com/virtprog/vpaspforum/topic.asp?TOPIC_ID=5234

(make sure you delete your prodcategories records first)

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

savage943
Starting Member

USA
26 Posts
Posted - June 09 2006 :  08:10:11  Show Profile  Visit savage943's Homepage  Reply with Quote
I am using the access database, not mysql or sqlserver. I do appreciate the help though. Have removed all of the category records and product records, then run the converts and still get the same.
Go to Top of Page

devshb
Senior Member

United Kingdom
1904 Posts
Posted - June 09 2006 :  09:10:59  Show Profile  Visit devshb's Homepage  Reply with Quote
try doing a compact+repair on it (I'm not sure if that'll do the trick, but it's worth a try)

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

savage943
Starting Member

USA
26 Posts
Posted - June 09 2006 :  11:11:03  Show Profile  Visit savage943's Homepage  Reply with Quote
Access won't do that as there is no description. Back to the drawing board.
Go to Top of Page

dwight
VP-CART New User

USA
143 Posts
Posted - September 03 2006 :  19:57:10  Show Profile  Reply with Quote
I have version 6.0 and have the same question If someone could help with this.
Go to Top of Page

support
Administrator

4679 Posts
Posted - September 03 2006 :  23:16:37  Show Profile  Visit support's Homepage  Reply with Quote
If you delete all records from the required table in Access and then run the compact and repair it will reset the auto numbers back to 0.

Alternatively open Access and select the table with your mouse.

Right click and select Cut

Now Paste and enter the name of the table.

Do not select to bring across data.

You will now have an empty table with all fields retined.

Thanks
Cam

VP-ASP Support
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty