Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible EVL() bug
Message
From
28/03/2006 15:01:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01108281
Message ID:
01108562
Views:
13
>>>In my Employee table sample, the Birth_date field is of type Date. I think that exist something around it.
>>
>>No Erick,
>>It happens with datetime fields consistently (it was a quick sample to send here. In original code I hit this the field was really a datetime field).
>>
>>SELECT emp_id, DTOT(birth_date)+3600 as bdate ;
>>  FROM (_samples+'data\employee') ;
>>  INTO CURSOR crsDummy nofilter
>>SELECT emp_id,EVL('dummy',TTOC(bdate)) as bdate FROM crsDummy
>>
Cetin
>
>Why would you expect 'dummy' to be empty to start with? Should it be
>evl(ttoc(bDate),'dummy') instead?

I don't expect anything:) I only found a case where it causes C...5 where it shouldn't.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform