Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Control - Append a new record in the last grid row
Message
 
To
10/11/1998 16:32:20
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00156026
Message ID:
00156544
Views:
37
>>>
>>>how about
>>>
>>>IF RECCOUNT(THIS.RecordSource) = 0
>>
>>RECCOUNT ignores SET DELETED status so if I deleted a child record, RECCOUNT will always come back with at least 1.
>
>Ok, still trying here...
>
>IF EOF(THIS.RecordSource) OR BOF(THIS.RecordSource) OR DELETED(THIS.RecordSource)
>    GO TOP IN (This.RecordSource)
>    IF EOF(THIS.RecordSource)
>       APPEND BLANK IN (THIS.RecordSource)
>    ENDIF
>ENDIF
>
I just realized that if other parent records have child records then this won't work. The only way I can think of that this might work is when the grid for the child records has a RecordSource of a p-view based on the parent record. I'm using a relationship between the parent and child tables. Looks like we need solution#2 :-)
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform