Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursoradapter
Message
From
06/05/2005 05:31:49
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
05/05/2005 18:09:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01011456
Message ID:
01011524
Views:
14
>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

Gaylen,
I don't know the answer (weird for me too and trying to understand CA myself). Interestingly if you create that in DE and use builder, it works.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform