Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculate field in Grid with free table
Message
De
02/09/2003 13:11:14
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
02/09/2003 12:40:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00825363
Message ID:
00825385
Vues:
22
>VFP 6.0
>SP 5
>Windows 98
>
>Anyone can help me?
>
>How can I calculate a column in Grid poblated by free fields.
>My coding is like this:
>
>If x
> LnMyVariable = 1
>Else
> LnMyVariable = 2
>Endif
>
>select DETAILS
>Thisform.GridLiquidac.RecordSource = 'DETAILS’
>Thisform.GridLiquidac.Liquid.ControlSource='DETAILS.Field1'
>Thisform.GridLiquidac.Item.ControlSource ='DETAILS.Field2' Thisform.GridLiquidac.Weight.ControlSource='DETAILS.Field3'
>Thisform.GridLiquidac.Libras.ControlSource='DETAILS.Field3' * LnMyVariable'
>Thisform.GridLiquidac.refresh()
>
>* But can´t obtaind the desired results, and receive the error message: Data type Mismatch (or error number 1742) when I define like this:
>
>'DETAILS.Field3' * LnMyVariable
>
>And see nothing when I define the line as follow:
>Thisform.GridLiquidac.Libras.TxtLibras.value ='DETAILS.Field3' * LnMyVariable'
>
>Property Status in Grid:
>Bound = .f.
>Sparse = .f.
>
>What is wrong here?..What am I doing bad.?.
>Any better idea?
>
>Thanks
>Carlos Burgos

Carlos,
Double post :)

Thisform.GridLiquidac.Libras.TxtLibras.ControlSource = ;
'(DETAILS.Field3 * ' + iif(x,'1','2')+')'

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