Could someone please me how I can delete all items that have no description with item? Created these items from Percon download - and I know you guys can easily tell me what SQL statement should have in it...thanks in advance.
Always backup your database before executing any UPDATE, INSERT or DELETE query. Execute any query at your own risk.
To test which records will be affected, try this: SELECT ItemLookupCode, Description from ITEM were DataLength(Description) = 0
If the result contains the items you wish to delete, try this: DELETE FROM ITEM were DataLength(Description) = 0
Here's a helpful link to an SQL Tutorial:
Hey Terrible Tom, Thanks so much, you're a dear. And the SQL tutorial is just perfect. I know I can write them once I have the parameters - and the time to mess around. In the meantime, your expertise as well as everybody who responds on this website is just priceless.
If I can ever do anything to help you out, I will be glad to do what I can.
As I told Rob who has helped me out incredibly with a couple of "triggers", I am using those triggers and writing documentation to train back office staff with procedures regarding ordering, receiving, updating costs and changing prices from cost updates. And identifying reports that may be helpful in ordering/receiving.
If this will help you or anybody else out, I will be glad to share. Not quite the RMS add-ons offered by 2B Inventory and Realm, but it will be using RMS Store Ops to its fullest capacity on a user level.
Mahalo!
"Terrible Tom" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.