Wayne,
It looks okay. Nothing out of the ordinary.
To help with debugging, when you get this error, check the return value of cursorgetprop("SourceType","viewname"). It may be that aliases are getting mangled and when you act on the view alias, you are actually working on a table alias.
Regards.
>Hi Larry,
>
>The view code is as follows:
>
>(I'm sorry I can't remember how to insert code in html page)
>
>
SELECT Services.serv_id, Services.unit_id, Services.phb_id,;
> Services.invent_id, Services.install_id, Services.subscripno,;
> Services.which_svc, Services.service, Services.start_date,;
> Services.recur_fee, Services.descrip, Services.start_time,;
> Services.createdate, Services.house_id, Services.smoke_id,;
> Services.memb_id, Services.other_id;
> FROM ;
> lw!services;
> WHERE Services.memb_id = ( ?vp_membid );
> ORDER BY Services.which_svc DESC
>
>This looks OK to me......
>
>Wayne
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao