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 07:00:55
 
 
To
21/02/2016 06:42:53
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
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:
01631804
Views:
39
>>>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform