Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Ummmmm Terry
I'm really against the idea of accessing properties directly in such a fashion.
First off, it is slower than using a memvar. Second, you can hook up access code to the property - which will fire at some point while the replace command is executing. If an access method fires a thisform.refresh and the refresh of some control does a GO BOTTOM... This just sounds terribly risky to me.
Do you have any access method on THISFORM.cOpDays?
>Yes. I first noticed that after I'd set some look-up FKs from listboxes, on the INFOBASE rec (textbox shows the key and listbox shows the look-up text name), and saved, the values disappeared from the record. These are chronological journey records pertaining to a parent ROUTE. There may be many of them for each Route, all maybe practically identical save for their start and end times, so I'd not noticed the rec changing in the past (if it did).
>
>So when I checked the list page of the form I found that i'd gone to eof(). Recs near the bottom of the table had got the values I'd just edited in. I thought I'd found the flaw in my class save logic and fixed this. Further tracing found this command was the culprit.
>
>>Does it happen if you don't have Browse open?
>>
>>>UPDATE: I can confirm that this line of code does not fire a trigger :-?
>>>
>>>>Do you have a trigger on the table?
>>>>
>>>>>Hi Sergey. Thanks
>>>>>
>>>>>No it's a well-established database table
>>>>>There is no timer in operation
>>>>>
>>>>>>Is it a free table? Do you have a timer that could move pointer?
>>>>>>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement