>Naomi,
>
>I inserted code in all the AfterCursorFill() methods of the CA objects in the DE concerned to show if the CA successfully did their CursorFill() like so:
>
>
>ACTIVATE SCREEN
>? "After: " + cSelectCmd
>
>
>It hanged up on this CA with the following SelectCmd:
>
>
>SELECT careof, company, building, street, miscaddr, city, zip FROM parcel WHERE PID IN ( SELECT MAX(pid) FROM parcel WHERE lastname=?vplastname AND firstname=?vpfirstname AND middlename=?vpmiddlename
>
>
>I then removed this CA object and it ran well again! This CA had a NoData property value of .T., which was being used to query existing address info.
>
>Why did this run well before, but froze up when the Parcel table grew?
>
>Whew! At least I can rest a little. =)
>
>Thanks to everybody!
>
>Dennis
Glad you found the problem.
If it's not broken, fix it until it is.
My Blog