|
-
Sep 11th, 2001, 03:15 AM
#14
Thread Starter
Lively Member
But I required the syntax so that in a single command or sets of command all the qty is set to 0
This "Update item set qty = 0 " is working when I use directly in Visdata (Visual data manager in VB) sql statement, but through vb program it is given error when I refresh.
My syntax
f1.strRSname = "update item set qty= 0"
Data2.DatabaseName = f1.strDBname
Data2.RecordSource = f1.strRSname
Data2.Refresh
----------
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote