Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
>>>>>While I was doing the safe select into this 3rd bizobject's CA (i.e. senduptates=.f., zap, select into a temp cursor, append from it, all of a sudden the .sendupdates=.t. and this append is now an insert, immediately sent to server, key constraint violation, bang. Tried to work around this in several ways, and in the end only .cursorfill with a new .selectCmd worked.
>>>>
>>>>As the 3rd bizobject retrieves a "record", is that from a single table or a join from people to (main or many?) phone to display both?
>>>
>>>It has five joins to a different table (a list of lists); in detail view phones are handled separately. IOW, this third bizobject doesn't have a "f" from phones.
>>
>>Hmm, nothing to do with phones, but at least in vfp "backend" those joins probably would create a new temp cursor whereas on a single table perhaps just a filtered table would have to be piped back to the CA. Just for ticking off differences I probably would test behaviour of a copy of 3rd CA stripped off the joins if that was doable without too many changes in surrounding code (perhaps via offering constants as placeholders for previously joined fields).
>
>My suspicion was about three CA having the same updateTable. Too bad I have a deadline, this is an interesting problem to investigate :)
If you find time to investigate a bit further, pls. forward findings, even if not resolved fully to set me a mental "do not venture there" marker
Précédent
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