>**************************************************************************************************************
>THANK YOU FOR HELPING ME..JUST A FEW MORE QUESTIONS
>
>WHAT IS Pv1-rate?
>WHAT is m.code..?
>
>my call log table name is view1 and the field i need is dialednr
>the rate table's name is rates and the field that has the first 6 digits of the call named is code
>now the part of the customer where i have stored the rate names to pull them down and asign the to my customer,,,table name rate_code and the field name is code
>
>CREATE VIEW pv1_rate AS;
> SELECT * ;
> FROM rate ;
> WHERE code = ?m.code
>
>m.code = SUBS(callId,1,6)
>USE pv1_rate
>
>please help me i need it.......pleaseee..
pv1_rate is defined in the Create View... p=parameterized, v=view 1=1st one.
m.code is a substr of your code that depicts the first 6 characters.
When you want to get another value, just change m.code and...
Requery('pv1_rate')
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown