Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View dialog problem
Message
 
 
To
07/06/2001 17:21:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00516426
Message ID:
00517124
Views:
38
Hi Jim,

Ok, I just found a way to bypass this error. Try ctod(dtos(date())) in this dialog :) Not a very easy expression, though :)

The trick is dtos, then ctod. This way it works.

>>>>>>
>>>>>>This is the message Forum: Visual FoxPro Category: Coding, syntax & commands Title: Re: Strictdate Thread #472725 Message #472756.
>>>>>
>>>>>Yes, and I still don't get it. I open the DBC, point at my view, and select Browse. Where does the View Designer enter into this?
>>>>
>>>>I got it to work. I typed ctod('01/01/2001') in View designer and it worked.
>>>
>>>Yep. And I bet ?set("STRICTDATE") gives you 0, right?
>>
>>I gotta run now. It gave me 1. I'll experiment more tomorrow.
>
>OK. Very interesting. WIth STRICTDATE to 1, I error out. Set to 0, your solution works. I want your system. I want STRICTDATE = 1.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform