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)

SQLCodeSSD2k.mdb

 Post Reply Post Reply
Author
Message
Jack Wolfgang View Drop Down
Contributor
Contributor


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/SQLCodeSSD2k.zip

--

Email: jwaccess@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down