Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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()
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement