Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - How can you detect and empty column in a GRID?
Message
 
To
14/04/1997 12:44:06
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00028193
Message ID:
00028213
Views:
56
>>>I want to append blank to a GRID, but I do not want
>>>to save an empty record. Before, I would check for
>>>if empty(thisform.txtname) etc..
>>Oh, I understand now: you'd want to check thisform.grid.column.txtname.value.
>>However, I would check it in the table, as I said in my other message.
>I want to APPEND BLANK on a GRID, then I want to check to see if
>the new record has data in it. Inotherwords, I want to check for
>a blank record in a GRID...

You won't be doing APPEND BLANK on the grid, you'll be doing APPEND BLANK to the underlying table, which will then show up in the grid. If you don't want blank records to be saved, the best place to put the code would be in the actual table, under the Record Validation information. That way, you won't be able to save a blank record in a browse window, either. Your Rule: would be something like:
NOT (EMPTY(field1) OR EMPTY(field2) OR EMPTY(field3))
and your Message: would be something like:
Cannot save blank record.
That make sense?
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform