SQL VFP Office Automation

  • Thread starter Thread starter D Van
  • Start date Start date
D

D Van

Hello,

I have the below command that gets ready to export the data to Excel, this
works fine.

_vfp.DoCmd("SELECT type, handler, new_claim, errorcode, errormsg,
office FROM archives WHERE office = current INTO CURSOR results1")

Each record has a date and I want to incorporate the date into the SELECT
statement but it errors out saying invalid command. I tried this

_vfp.DoCmd("SELECT type, handler, new_claim, errorcode, errormsg,
office FROM archives WHERE office = current and dtoc(dt) > "12/31/03" INTO
CURSOR results1")

Thanks in advance.

Doug
 
I'd guess:

_vfp.DoCmd("SELECT type, handler, new_claim, errorcode, errormsg,
office FROM archives WHERE office = current and dtoc(dt) > #31 DEC 03# INTO
CURSOR results1")
 
Back
Top