Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 2008 table as a record source
Message
From
21/02/2016 06:42:53
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
21/02/2016 06:15:53
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01620689
Message ID:
01631801
Views:
48
>>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform