Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with append blank
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00358942
Message ID:
00359134
Views:
12
Hi,
Can you use GETFLDSTATE?

Ex.
Getfldstate("myfield") = 3 equals User didn't touch the field
Getfldstate("myfield") = 4 equals User made it whatever it is even if it's 0

>Hi David,
>
>Ug. I kept looking at the Numeric type in the help. Thanks.
>
>So any ideas how tell if it's 0 for a newly appended blank record? I append a blank a record to a view, then show the user a form to edit it. I need to tell if the user picked 0 or if it is 0 from the append.
>
>Here's what wierd. If it's a remote view using ODBC to connect to a VFP table (with that field marked to not allow null's). Append to the view, the field has a 0. Now TableUpdate it, you get an error "Field XXX does not allow NULL's". ???
>
>
>
>
>>Uh, guys...
>>
>>The help also says this:
>>
>>Note that Currency, Integer and Double type expressions are never blank, and ISBLANK( ) always returns false (.F.) for these data types.
>>

>>So you are seeing the documented return value for Integer.
>>
>>>Whew! I thought I was going nuts ;) Thanks.
>>>
>>>Now I need to find a work around.
>>>
>>>>I get the same results. Looks like you found a bug, at least according to the help file's definition of how IsBlank() should work.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform