Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ttod on dynamic sql
Message
 
To
19/06/2009 07:18:37
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01407095
Message ID:
01407110
Views:
27
>But then it is wrong for the cases where ttod(mycursor.createtime)=thisform.txtdate() except midnight
>Intention was to compare on a daily base (date vs. date) not on time as Time vs. Date. (As suggested by the TTOD)

It's true...
But main idea in my example was using parameter in macro.

And your notice is important :-)

MartinaJ

>
>Agnes
>>Hi Agnes,
>>
>>But Chaim use ">" not "="
>>
>>MartinaJ
>>
>>>Hi MArtina,
>>>
>>>are your sure?
>>>
>>>if mycursor.createtime is Time (as TTOD suggests) it should return mostly false since the date value will be changed to {^YYYY.MMM.DD 00:00:00}
>>>
>>>DATE()=DATETIME() is true it at midnight only
>>>
"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