Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculated expression from two expression
Message
De
29/09/2006 19:31:37
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01158307
Message ID:
01158320
Vues:
25
>Thanks for the reply Mike,
>CrsResult is allready cursor i need just debit - credit action but problem is expressions is long for this or field expression doesnt accept (-) action

Not crsResult. tblCredit.

create table tblDebit (cDebit c(3))
index on cDebit tag cDebit

insert into tblDebit (cDebit) values ('101')
insert into tblDebit (cDebit) values ('104')
insert into tblDebit (cDebit) values ('105')

etc.

Then in grid

IIF(seek(crsresult.fischcode, tblDebit, "cDebit"),,crsresult.amount,0)

Much shorter expression. Now it can have millions of debit codes.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform