Here again is the code I use to access foxpro 2.6 data from visual interdev:

< %
datethen=date()-6
datenow=date()
qry = "select * from kdata where k_date >= '" & datethen & " and"
qry = qry & " k_date <= '" & datenow & "'"

set rs1 = server.createobject("ADODB.Recordset")
open.rs1 qry, "DSN=foxcon"

while not rs1.eof
response.write rs1.name & " " rs1.k_date
wend
% >


I think the mistake is in the field k_date since k_date is a foxpro 2.6 date datatype. I tried using curly braces - it did not work.

Also, I set the foxcon DSN at the system DSN in ODBC Data Sources in Control Panel. I don't think the problem is here since the query works well when I leave out the k_date condition.

Can somebody help me fix my code?


Ramon Carlos