Dim memory on a similar situation when working on a dbf/CA solution: creationg a oScat - empty object into which all the necessary record info from each table was scattered after seeking() the relevant record in the source table. Resulted in half generic code: you had to set some special properties in the CA to follow the SQL join logic via Seek() calls. If you are coding against a C/S backend probably a special select has to be fired. Generating that SQL should be at least reach that half-generic level of firing seek() from internal property values...
>Hi,
>
>It looks that Requery() will refresh all records in the CA cursor. But I would like to be able to requery/refresh only one - current record. I tried to use CA RecordRefresh() but it does not work. I think the reason is that the CA is build on JOIN and the JOINed column is not refreshed when calling RecordRefresh(). Requery() does the job but for all records.
>
>What else can I try?
>
>TIA
Previous
Next
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