Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Wolfgang, Jack
  New Posts New Posts RSS Feed - SQLCodeSSD2k.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
Jack Wolfgang View Drop Down

Joined: 30 Jun 2008
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Jack Wolfgang Quote  Post ReplyReply Direct Link To This Post Topic: SQLCodeSSD2k.mdb
    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/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down