General information
Category:
Coding, syntax & commands
>>>>Using vfp5...
>>>>
>>>>When I save my parent I need to set a flag in the parent table indicating
>>>>whether or not the parent has children. This really speeds up another
>>>>part of my app. I was going to do a locate during the save and see if
>>>>it finds any children. Is there some slick way to do this?
>>>
>>>Joe,
>>>
>>>If you're trying to determine whether or not a table is engaged as a parent to a related child table, look at the TARGET() function.
>>
>>No... I'm using a logical field in my parent to indicate if there are
>>children to process. That way as I'm looping my parent I don't
>>have to look for child records unless that flag is set.
>
>And you're trying to find only those records that have a child record or are you trying to determine whether or not to set the flag? If the former then SCAN FOR < expression > can do it. If the latter, test for EOF() in the child work area.
Thanks to everyone for your suggestions!
Previous
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