>>>
>>>CREATE VIEW pv1_rate AS;
>>> SELECT * ;
>>> FROM rate ;
>>> WHERE code = ?m.code
>>>
>>>m.code = SUBS(callId,1,6)
>>>USE pv1_rate
>>>
OPEN your database by issuing...
OPEN DATABASE MyData
Then run the code exactly as it is above/below...
CREATE VIEW pv1_rate AS;
SELECT *;
FROM yourratetable;
WHERE yourcodeid = ? m.code
then assign a code value to m.code like...
m.code = '175010'
then use pv1_rate like...
USE pv1_rate
The result will only contain entries that have a code of '175010'
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown