I’ve been wracking my brain for like the past three days with this problem… I am trying to insert data into a Foxpro for Windows 2.6 DBF that has logical fields from an ASP page.
In my SQL Insert query I’ve tried 1, 0, .T., .F., True, False and a whole slew of other things to get this field to update, and every time I get a “Data Type Mismatch” error. What’s the proper value to update it?? I also notice that it flags a syntax error if I try to do something like this:
INSERT INTO table_name(field_name) VALUES(value).. is it not possible under Foxpro 2.6 to specify certain fields to update?? I know my way around SQL, but using this dinosaur is something else entirely.
I’d appreciate any help with this problem.. it’s driving me crazy!
EDIT: It appears that the logical field might not be the problem.. it might be a Date field, but again whats the way to insert this? the format mm/dd/yyyy gives a type mismatch error as well.
