Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Matrix rate
Message
From
28/06/1999 14:20:05
Dovi Gilberd
Dovtware Consulting Inc
Miami, Florida, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00233562
Message ID:
00234885
Views:
30
hi barbara how are you doing today..i was up until 5 am last night tringing this still
im using this function which returns in the grid the actual ratename that the customer is using..
if i change the rete in the customer it changes in the grid too..
what is the nect stec to detrmine the actual rate taht that call has under that rateplan....
can you please help me...the forum has been grat with me..no complains..


FUNCTION getrate()
PARAMETERS Result
cRateField="long_distance.rate"
select rates
set orde to tag code

IF LEFT(view1.dialednr,1)='0'
SEEK LEFT(view1.dialednr,6)
endif

IF LEFT(view1.dialednr,1)="#"
SEEK LEFT(view1.dialednr,3)
endif

if LEFT(view1.dialednr,1)='1'
SEEK LEFT(view1.dialednr,4)
ENDIF
RETURN EVAL(cRateField)
Previous
Reply
Map
View

Click here to load this message in the networking platform