thank you for helping me out with the time diference last week. i wanted to ask you about a problem that im having trying to figure out what rate each call has according to a preset rate. could you please please help me..you helped me last week with the time difference proble...and i also learned how to put a function to work from my main program..
my rate database loook liek this
code country rate1 rate2 rate 3
011575 colombia .34 .35 .67
the enduser presets the rate on customer
Ex. John doe has a rate 2 for all the calls
he made a call to 011575865755...we know that that call was made to colombia at a rate 2 at the price fo .35 cents..
the first thing i need to do is compare field named long_distance.code(rate)
with rate table field name rates.code
the i need to put this condition in it
if left(view1.dialednr,1)="0" && view1.dialednr is fieldname of phone#dialed
seek left(view1.dialednr,6)
endif
if left(view1.dialednr,1)="1"
seek left(view1.dialednr,4)
endif
this measn if number dialed starts with cero compare first 6 digits with ratetable fieldname rates.code
if number dialed starts with 1 then compare first 4 digits with ratetable fieldname rates.code
somewhere in the functions goes this..
for n=1 to fcount()
if field(n)=upper(code)
return eval(field(n))
endif
endfor
nl=rate
return rate
endfunc
but i dont know...this is supose to tell me what rate is the person using
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only