Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC, resultcursor and datasession
Message
From
18/06/2007 18:36:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLEXEC, resultcursor and datasession
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01234140
Message ID:
01234140
Views:
58
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
Next
Reply
Map
View

Click here to load this message in the networking platform