can you please take a look again to the getrate function...its not working properly
i added a new rate 411 to see it in the calls that show up say instead of 0 .75 cents..and it does not change...
please give me a hand,....i know you'v been extremelly kind with me...but im begging you i need it...












>>ed good morning, its working, but it needs a litle work more..
>>for example call in a client thet is 411 calls...those do show upa at 0 dollars...thats goods.
>>im thinking....using chrtran(dialednr,"-","") that replaces visually the dahes with blank...but how do i doit fisically in the database...?i know thats the problem..
>>
>
>You know how to change the string, so all you have to do is save it; you have several things you could do, fixing the value before it's saved in the field would be one obvious solution, or at some point before processing the table after new records are added, you could use REPLACE to 'fix' the data fields. If the number of records involved in the table is large, you'd want to scope the REPLACE to only update records not previously processed, or if the number of records were fairly small (for example, if your import worked by pulling in new records to an intermediate file before putting them in their final resting place), something as simple as:
>
>USE MyImportTable
>REPLACE ALL dialednr WITH CHRTRAN(dialednr, "-", "")
>
>would fix the field content in all the records.