Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC, resultcursor and datasession
Message
From
18/06/2007 19:11:14
Luis Navas
Independent Consultant
Auckland, New Zealand
 
 
To
18/06/2007 18:36:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01234140
Message ID:
01234142
Views:
12
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 :-)
Previous
Reply
Map
View

Click here to load this message in the networking platform