General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi barbara..
im trying still to do this..to change the database would be having 18000 records and every time y need to ad a new record i need to make drastic changes..
i trying
with this function something else
i created a function in my main program called rate()
like this
function rate()
lparameter dialednr,code,result,result,n
select rates && my rates table
set order to tag code &&code is field that contains the country areacodes
seek left(view1.dialednr,6) &&dialednr is the fieldname of the calls in view
for n=1 to fcount()
if field(n)=upper(code)
return eval(field(n))*result &&&&result is the result of the duration
endif
endfor
rate=n
return rate
endfunc
what is wring with this functions...does it do what i need it to do..
ps. result is the duration of the call allready calculated in function result()
Previous
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