>i found another problem..
>looking at the database calls made to local area toll like
>954,564,305,do not have a one in front.....
>so how can i put another do like if dialednr is 7 characters long
>take only the the number one plus the first three digist of the call...
>or better yet i aded another three records to the rates table with 305,954,561..and that solved it..
>but still my calls do not show up in my grid, the show up once i get to that page but the desapear..
>
Take a look at what i did for 411 and 911, and use those as a model for what needs to be done. Again, the DO CASE...ENDCASE is forcing things not to be looked up if they don't meet your set of acceptable prefix criteria; simply adding records isn't going to work if you don't allow for the number to be picked up in lcSeekValue in the DO CASE...ENDCASE.
It's all the same problem.