SQLCodeSSD2k.mdb |
Post Reply |
Author | |
Jack Wolfgang
Contributor Joined: 30 Jun 2008 Status: Offline Points: 1 |
Post Options
Thanks(0)
Posted: 10 Jul 2008 at 2:52am |
This Access 2000 DB contains a module with two procedures for the handling of SQL in Access 2000. The first procedure is a function called StrForSQL, which takes a string and prepares it for inclusion in an SQL statement by encapsulating it in single quotes (apostrophe character) and doubling any single quote/apostrophe characters in the string (e.g. "Jack's Access SSD" becomes "'Jack''s Access SSD'"). The second procedure is a procedure that runs SQL on the current A2k DB without showing the warnings.
This module requires no special references. Download Access 2000: uploads/40/SQLCodeSSD2k.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |