Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there something like SetNextModified(0) = 0?
Message
From
27/02/2008 12:19:07
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01296902
Message ID:
01296946
Views:
4
BTW why I needed it? Maybe you'd need too:

I have a conversion in progress and I have date/datetime fields which are empty on VFP side but NULL on SQLserver side. I created a code that does the upsizing + generates CA classes with code like this in AfterCursorFill:

replace myDate with {} for isnull(myDate)

rather than checking each place in application where some calculation is done with empty() - many date/datetime fields. It works just fine. But then a code something like this:

scan
endscan

takes ages to complete. It doesn't do anything but very sloooow (ie: measured as 14+ seconds on 5K records). Strangely a code like this:

replace all f1 with f1

takes only 0.001. Go figure:)
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