Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Wolfgang, Jack
Forum Description: Jack Wolfgang's Library
Printed Date: 24 Jul 2021 at 11:27pm
Software Version: Web Wiz Forums 12.03 -

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: -

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -