Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC, resultcursor and datasession
Message
De
18/06/2007 19:11:14
Luis Navas
Independent Consultant
Auckland, Nouvelle Zélande
 
 
À
18/06/2007 18:36:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01234140
Message ID:
01234142
Vues:
11
The method of the form may be changing the datasession id, try to execute the comand in the event of the container to see if that is the problem.

Luis
>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
I never forget a face, but in your case I will make an exception :-)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform