>I have purchased Drumbeat 2000 E-Commerce edition by macromedia.
>But have no end of trouble inserting from the Shopping Cart into an Orders Detail table. Does anyone have any experience of using this product with FoxPro Tables. I have used the newid() sample as a stored procedure to generate order numbers in the orders table.
>
>I should probably have bought something based on VFP.

How are you calling NewId()?