General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for the help. That soultion seems to work great when they can only cancel the order before they leave the order entry screen. But since later in the system they can cancel an order, I am left with both order header and order line items that are deleted but show up in queries. For example in another form the deleted items get selected:
SELECT DISTINCT descode,destype FROM orditems INTO CURSOR desitems WHERE !EMPTY(descode) ORDER BY descode
I need a way to exclude the records form being selected by this select statement.
Any ideas?
Thanks,
Randy Wessels
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only