Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Update syntax
Message
From
11/09/2001 13:30:41
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Access
Title:
SQL Update syntax
Miscellaneous
Thread ID:
00555230
Message ID:
00555230
Views:
50
Does anyone know what the correct syntax for an update command is?

I tried the following with no luck:
DOCMD.RunSQL("Update mytable Set myfield = "FRED" WHERE myfield2 <> 9 ")
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson
Next
Reply
Map
View

Click here to load this message in the networking platform