Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Switching DS in code - error
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Switching DS in code - error
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01412260
Message ID:
01412260
Vues:
109
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform