Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ttod on dynamic sql
Message
From
19/06/2009 07:40:09
Lutz Scheffler
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:
01407111
Views:
30
Martina,

I'm only that picky because if the originator of the thread does not see the simple problems of the original macro (use of right formated literals or "parameters" [this is not a parameter - it's just the use of a variable in a macro but I have no better word anyway {but it could give those that have little knowlegde of macros the idea a macro works as a little bit like a proc - this is true for a exescript}]) and I fear he will not notice the problem with this little problem.

Also I've learned that I can compare date vs. time and how it works. That could be usefull for some special cases.

Agnes

>>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform