Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax ADO in cursoradapter ( Date )
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01460787
Message ID:
01460794
Views:
39
How is connecstring?

MartinaJ

>Hi martina,
>
>when i use your code
>
>TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
>			SELECT HDBK, Hid , HDOCNO, HAMOUNT,  HDOCDATE ,CREATEDBY,
>			Createdon , hremint   FROM <<.TABLES>>
>			WHERE hdocdate > {d '2010-01-31'}
>      ENDTEXT
>
>I have the error in attachment
>
>>Hi Bernhart,
>>
>>You try use escape sequence...
>>
>>...where hdocdate > {d '2010-01-31'}
>>...where hdocdatetime > {ts '2010-01-31 12:13:14'}
>>
>>
>>MartinaJ
>>
>>>Hi all,
>>>
>>>please see attachment.
>>>
>>>
>>>...where hdocdate > {^2010-01-31}...
>>>
>>>
>>>Fails..
>>>
>>>what 's the good command ?
>>>
>>>Thank in advance
>>>
>>>
>>>bernhart
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform