Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change value for deleted() records
Message
 
To
31/08/2001 10:33:19
Fabian Borghi
Xenon Information Technology
Itaparica, Brazil
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00551411
Message ID:
00551421
Views:
19
>I need to change the information in a grid,
>for example :
>if record is deleted() i need to i display the values, but if the record is !deleted() i need to display "Active Article"
>
>Thanks in advance
>Fabian Borghi
>EAN Argentina
>Buenos Aires


There are several ways to do this, but the one I have tried and use is to put an IIF in the control source of the text box on the grid. Such as:

IIF(DELETED(),Table.FieldName,'Active Article')

Try that and see if it works for you.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform