Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC, resultcursor and datasession
Message
De
18/06/2007 18:36:46
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQLEXEC, resultcursor and datasession
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01234140
Message ID:
01234140
Vues:
57
I have a form and a containner on it. The form has a private data session. I am adding a session class to the container to create a private datasesion for it. In container's Init I have the following code: (simplified)
WITH This
	.poPrivateDataSession = CREATEOBJECT('session')
	SET DATASESSION TO .poPrivateDataSession.DataSessionId
	IF !USED('curSecondDefects')
	*!* Populate defects
		TEXT TO lcSql TEXTMERGE NOSHOW
			SELECT 'Select Defect', 0 as id from seconddefects
			union
			select defect, id from seconddefects
			order by id		
		ENDTEXT	
		ThisForm.mExecuteSqlCommand(lcSql, 'curSecondDefects', '')
	ENDIF
ENDWITH
Cursor 'curSecondDefects' is getting created in the form's datasession but not in the container's. Am I missing something?

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform