I would firs make sure that there're no index or data corruption in underlying tables.
>Does anyone know if there are specific problems with doing a requery on a view in which the view definition is pulling records from 2 different tables into 1 view? From past threads I know it is most likely a driver on the machine but I have removed just about all the driver printer driver on the machines that are producing the errors without any success.
>
>This is my view definition
>
>CREATE SQL VIEW mastaka AS ;
>select SPACE(18) as aka_lname,space(16) as aka_fname, space(1) as aka_mname, {} as aka_dob,;
>999999999999 as aka_keyid,* from database!master where mas_name1 LIKE ?vpLname+"%"
>
>and this is the line of code where the C5 error occurs
>requery('mastaka')
>
--sb--