Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculated expression from two expression
Message
From
29/09/2006 19:31:37
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01158307
Message ID:
01158320
Views:
22
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform