Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert-update-replace-update doesn't work
Message
From
28/10/2016 09:41:48
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
28/10/2016 08:28:27
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 7
Database:
MS SQL Server
Virtual environment:
VirtualBox
Miscellaneous
Thread ID:
01642269
Message ID:
01642439
Views:
28
>first check would be key column after insert and update pattern...
>perhaps log called in hook methods on record level of CRUD executing from CA

Followed those in the debugger and it found no errors. Then traced it in the profiler (express profiler, that is - much easier on a single user machine) and saw that the where clause of the update statement was quite long. Ran that statement in Toad and it returned no errors, updated no records. Because some of the values mentioned in the where clause were wrong - wrong length or whatever.

Because my cursoradapter class simply defaulted to .wheretype=3. Changed it to 1 and it all works as advertised.

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