Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursoradapter
Message
From
05/05/2005 18:09:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Cursoradapter
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01011456
Message ID:
01011456
Views:
53
Newbee with CA here

In my selCmd I want to use a parametized query. If I use ?lnxxx it works. If I use thisform.xxx I am prompted to enter the value for xxx. Both ar populated before cursorfill(). Using "native" datasourcetype.
local loCursor as CursorAdapter, ;
	laErrors[1]
thisform.xxx = 37000
loCursor = createobject('CursorAdapter')
with loCursor
	.Alias              = 'cPolicy'
	.DataSourceType     = 'Native'
  
    .SelectCmd   = " select sif_no,fund_yr from policy where sif_no = ?thisform.xxx " 
     
	.cursorschema = "SIF_NO I, FUND_YR I "
brow
Thanks
Gaylen
Next
Reply
Map
View

Click here to load this message in the networking platform