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 06:42:53
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
21/02/2016 06:15:53
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:
01631801
Vues:
47
>>>>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 :)

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform