Hi dragan..how are you...im sorry to bother you..i am dealing with rate...im very new to fox, but im defending myself however i can...boks, forums,,etc....Im sorry to bother you..please help me
regarding this..

i created a function in my main program called rate()
its at the end of the page

key things about my problem
customer table's name is long_distance
the field in customers where i set the rates is long_distance.code
the calls made are in view1
the field that has the calls is named dialednr

my rates table name is Rates and it looks like this

code country rate 1 rate 2 rate n
011575 Colombia .23 .24 .25

i know that John doe has rate 2, and he made a call to 01157587654..
then that call with rate 2 to colombia should be billed at .24

Now first i neeD to compare the first digits of the call against the rate table to see which country was called
if dialednr starts with 0 then take left 6 of dialednr compared with rates.code
if dialednr starts with 1 then take left 4 of dialednr compared with rates.code
then i need to compare long_distance.code (rate asigned) the correct column of rates table( meaning if john doe
had rate 3, make sure that it uses the fith column of rates table..
now that i know the rate and the country i could knwo the rate


im triying with this function to doit but its not working properly..
CAN YOU PLEASE HELP ME OUT.TO CORRECT THE FUNCTION SO IT WORKS PROPERLY..


function rate()
lparameter dialednr,code,result,result,n
select rates
set order to tag code
seek left(view1.dialednr,6)
for n=1 to fcount()
if field(n)=upper(code)
return eval(field(n))*result
endif
endfor
rate=n
return rate
endfunc
return rate




******************************************************8
***********************************************

>>i created a function in my main program called function result()
>>how, where and it what way i call the function in my grid to show the results of the function.
>>the function is suposed to calculate time lapsed between two times..
>>can any body please help me
>
>Just a tip over what Erik said: a slightly better way is to create a custom method in the form which holds the grid, and then have thisform.result() as controlsource of the column where it should appear. This way the function is kept there where its used, and you don't have to worry if tomorrow you can't remember where's the function. If this function is used at various places around the app, then you may be better off having a separate file called result.prg (and don't put "Function Result" or "Procedure Result" in the first line - it's slower) and then just do as Erik said.