Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Few observations about client server (VFP/MS SQL Server 7)
Message
From
09/05/2001 11:46:39
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Few observations about client server (VFP/MS SQL Server 7)
Miscellaneous
Thread ID:
00505326
Message ID:
00505326
Views:
40
This is not question
This few observations about client setver
VFP/MS sql7
Let we do some sqlexec with select to server
and set result cursor to the grid in the form
One of the columns has check instead of text field for multiple selection from lookup
reference table. If data ssession is private, when we click check in the grid, observe the error
tablebuffer has uncommited changed.
On some reason function =cursoregetprop return for buffreing=3
and VFP trys to update cursor, but update to where. The source was on server and it is not remote
view.
datasession is default
In check click we do update to cursor thougth sqlexec
When we repeat server query to refresh grid, ( tgrid.recordsource='', sqlexec(con,'select …','cur') grid.recordsource='cur')
we observe two misterious errors 1545 and 1469
All I did , wrote code in error event doing void setting for these errors
How to call these-features, bugs on normal behaviour
Best wishes to everybody
Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.
Reply
Map
View

Click here to load this message in the networking platform