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..









>>am i clling the function ok
>>in the control source of the mygrid.column6
>>getrate()
>
>Sounds like it, since you don't pass in any parameters, deriving all the values from fields in various related tables in your code fragment that I used as the basis for my code example.
>>
>>
>>
>>
>>>>ed are you with me...did i offend you in anyway...? please let me know..i did now quite undeerstood your last lines...did you wanted me to explai every thing i need again....
>>>>im having some problems with this function the clnalias at the end is not working..i took it off and the form works but it does not put anything on the grid...woluld you give me my last help.....please..i've been trying to do this 5 days allready...thanks to the forum im almost done.....please
>>>>
>>>
>>>No, you didn't offend me at all, I'm just working on a couple of things here at home as well as sitting out on UT, so I got distracted for a few minutes 9I do have to do some work for a living once in a while < g > ). As I said, there was a typo in my code, so substituting SELECT (lcInAlias) for SELECT lcInAlias should fix that particular problem.
>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>>i know that it would be easie if you had it inform..showuld i tray to explain to you again.
>>>>>>
>>>>>
>>>>>It would help to know what has to be done...
>>>>>
>>>>>>anyway i took care of the 0 result..
>>>>>>now thre is one more error..its where the assert !isnull(lcseekvalue)message
>>>>>>
>>>>>
>>>>>That means that it couldn't find the prefix in the rate table. So what do you do if you look for a prefix and it isn't in the rate table?
>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>ok. i have a function called duration.i placed it as duration() in my grid and it gives me the duration for each call
>>>>>>>>i want to do the same thing to call the getrate() from the grid so it gives me the correct rate per call according to the rate of the customer
>>>>>>>>
>>>>>>>
>>>>>>>So what manual process do you perform to make this determination? Once you describe that in terms of the information available to you from various sources (like the rate table, the current customer record, the current call record), you can translate the manual process of determining what the correct rate is into code that VFP can execute.
>>>>>>>
>>>>>>>It's easier to design and code things if you describe the process first, plan how the data needs to be stored logically, and only then try to write code to mirror what you describe using the logical data organization.