Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Switching DS in code - error
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Switching DS in code - error
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01412260
Message ID:
01412260
Views:
108
Hi everybody,

I have the application that tries to switch DS in form's load using SET DATASESSION command. One of the main tables was in buffering 3 mode.

I tried to switch to buffering mode 5 and now I'm getting this error
Program Error
Cancel
Suspend
Ignore
Help
Error loading file - record number 27.  CUSTOMERS <or one of its members>. 
 Loading form or the data environment : Table buffer for alias "CONFIGHEADER" contains uncommitted changes
So, does it mean that SET DATASESSION TO command produces this error? Or there could be another source of it?

Thanks in advance.

UPDATE. The problem seems to be related to the fact that the Customers form has more than 12 different tables in its DE including ConfigHeader.

UPDATE2. Also this form has the following code in its BOT method of DE
Set Talk Off && was displaying ndataSession at Public nDataSession line???
If Vartype(nDataSession) <> "N"
	Public nDataSession
	nDataSession = Set("Datasession")
Endif	

Set Datasession To nDataSession
This code could be found in almost every form of this application. I don't understand why do we need such coding and what problems does it cause.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform