Print Page | Close Window

SQLCodeSSD2k.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Wolfgang, Jack
Forum Description: Jack Wolfgang's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=147
Printed Date: 15 Dec 2017 at 6:19pm


Topic: SQLCodeSSD2k.mdb
Posted By: Jack Wolfgang
Subject: SQLCodeSSD2k.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/40/SQLCodeSSD2k.zip -




Print Page | Close Window