Question about data types and inserting them into FoxPro tables using VB.Net
Posted on 2005-04-26
I'm currently trying to use the INSERT statement to create new rows in FoxPro 6 tables. I've managed to do it ok with text strings and integers, but how do I do it for data, boolean and memo fields?
ie, there is a field, called cseexps, which I suspect is a date field in the foxPro table. How do I get a text string which is a date as entered into a text box, and both are in the dd/mm/yyyy format, into the date field? I tried surrounding the variable with ' and also tried # and neither work.
In the FoxPro table, some fields are listed as tick boxes, which I assume relates to a true or false declaration. If I have a text box in which a person enters the word true or false, how do I convert this into the field?
There is a memo field, called csenote, in the FoxPro table. I've tried inserting text into the field wrapping it ' characters as text, but it doesn't work.. Any idea where I may be going wrong?
I know this is theoretically 3 questions, but they all relate to one problem I am having. I've put all available points into this question, and I'm quite desperate to get this fixed, as it's confusing me to bits!