Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursoradapter
Message
De
06/05/2005 05:31:49
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
05/05/2005 18:09:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01011456
Message ID:
01011524
Vues:
15
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform