Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Logical field in grid not showing Yes/No instead T/F
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01216898
Message ID:
01216901
Vues:
12
>I'm trying to set the column that is displayed as logical field to accept Y/N and display Y or N instead of T/F. This is a readwrite cursor that is shown in the grid as follow:
>
>
>SELECT P_productname, O_orddte, O_qty, ;
>Sum_rd_qtyrec, O_unitprice, O_checkmark, O_tmp_qtyrec, ;
>O_tmp_daterec, O_tmp_amt, O_orderid, O_p_productid ;
>from lv_order_by_dte_nrp INTO CURSOR crs_grid readwrite
>
>SELECT crs_grid
>thisform.pf1.p1.g1.RecordSource="crs_grid"
>thisform.pf1.p1.g1.RecordSourceType = 1
>thisform.pf1.p1.g1.column6.ControlSource = "=TRANSFORM(crs_grid.O_checkmark,'Y')"
>
>
>However, I keep getting errors when setting the controlsource for the column. The user will be entering a Y or N into the columns. Why can't I set the controlsource? Is there another way of doing this? The cursor field name is crs_grid.O_checkmark.
>
>Thanks
>Nick

Try:
thisform.pf1.p1.g1.column6.ControlSource = crs_grid.O_checkmark
thisform.pf1.p1.g1.column6.InputMask     = 'Y'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform