help: question about insert into Foxpro tables

Please help, How do I get a text string which is a date as entered into a text box in, and both are in the mm/yy/yyyy format, into the date field? I tried surrounding the variable with ' and also tried # and neither work. i always get a type mismatch error.

eg insert into temp(date, no) values('07/31/2005', 2)

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!