Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server 2008 table as a record source
Message
De
21/02/2016 07:00:55
 
 
À
21/02/2016 06:42:53
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01620689
Message ID:
01631804
Vues:
38
>>>>>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
Fil
Voir

Click here to load this message in the networking platform