General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
>Hi Yuri,
>
>> it looks like only logical and numeric types do not work.
>
>I would have though that currency isn't working either. Those are data types where the blank field representation doesn't match the empty value representation.
Christof,
Currency, it is not included in the field type list for which values ISBLANK( ) returns true. Why are you thinking of currency?
Also see notes there , "Expressions with Currency, Integer, or Double type are never blank; therefore, ISBLANK( ) always returns False (.F.) for these expression types"
Actually my goal is to copy data from the huge VFP tables into remote SQL Server. There in VFP records are blank numeric data which I need to represent as NULL in SQL Server. I can process it while scanning and sending records one by one, but as far as I see, it takes days for 10+ million records. I thought to use DTSx Packages, but I cannot see the way to avoid this isBlank() problem.
Sure I can prepare the VFP table first while converting data in the recods as needed, but I hoped that there could be another suitable solution.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only