blacksaibot
Registered User.
- Local time
- Today, 11:30
- Joined
- Jan 20, 2010
- Messages
- 31
First of all, this is not my database design choice, it's just what I have to deal with....
The DB guy designed a table which has a field with a default value of 'No' (single quotes include). It's a textfield.
I am creating a form to input data into that table. I want the textbox that is associated with the above mentioned field to have its default value as 'No' (single quotes included). If I just type 'No' in the properties box for the text box, it removes the single quote when I view my Form in Form View.
ALSO, I then need to make my code below create a SQL query that will not have an error in it when inserting a string with a single quote in it.
Thanks
The DB guy designed a table which has a field with a default value of 'No' (single quotes include). It's a textfield.
I am creating a form to input data into that table. I want the textbox that is associated with the above mentioned field to have its default value as 'No' (single quotes included). If I just type 'No' in the properties box for the text box, it removes the single quote when I view my Form in Form View.
ALSO, I then need to make my code below create a SQL query that will not have an error in it when inserting a string with a single quote in it.
Thanks