Numeric Values
Simply use the value as is:
"WHERE SomeFieldName=4"Text Values
Surround the value in single qutoes:
"WHERE SomeFieldName=\'This Is The Value\'"When you need to include single quotes in the string (e.g. ‘St Mary’s’) use a doudle single quote. E.g. in VC++:
NewString = NewString->Replace("\'", "\'\'"); //Replace all ' with '' (needed if string you are trying to save contains a quotation mark
Boolean Values
Surround the word True or False with single quotes:
"WHERE SomeFieldName=\'True\'"
"WHERE SomeFieldName=\'False\'"
To use a VC++ boolean variable just use ToString:
"...SET SomeFieldName=\'" + Convert::ToString(MyBooleanVariable) + "\' WHERE..."
USEFUL?
We benefit hugely from resources on the web so we decided we should try and give back some of our knowledge and resources to the community by opening up many of our company’s internal notes and libraries through mini sites like this. We hope you find the site helpful.
Please feel free to comment if you can add help to this page or point out issues and solutions you have found, but please note that we do not provide support on this site. If you need help with a problem please use one of the many online forums.