>ed...hey how are you...im still here with this rate thing...
> ed im doing debuging here..
> i tested canceling the second assert and replasing with lnresult=0
> and the error went away...no another error came up after that..says alias lcinalias not found..what is that?
>
A typo on my part - you need to use name substitution. I stored the active alias in a variable lcInAlias when the function started, and on exit, i want to reselect it, so rather than the line that reads:
SELECT lcInAlias
try
SELECT (lcInAlias)
which substitutes the content of lcInAlias for the name of the alias to select.
>
>
>
>>>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.