Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursoradapter
Message
De
05/05/2005 18:09:37
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Cursoradapter
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01011456
Message ID:
01011456
Vues:
54
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform