Hi All

This appears to have been something to do with allowing NULL values on some fields but I am not 100% sure what.

Anyway I have it working now.

Regards
Geoff

>Hi
>
>I have a simple parameterised view on a table (see bottom). When I add a new record to the view and then execute a tableupdate on it the tableupdate returns .T. but the record is not added top the table in the remote database. Modifications to existing tables are similarly ignored.
>
>This is the only table it happens on.
>
>Could some kind sould enlighten me as to why this might be happening?
>
>The table in the remote database had a rule on it (updating the modno field) when I remove this I get a "Connectivity error 00000001 : Incorrect function" error.
>
>Alas, I'm none the wiser.
>
>Regards
>Geoff Scott
>
>

SELECT Woitems.wo_id, Woitems.wo_itemno, Woitems.ex_ref,;
>  Woitems.contractcode, Woitems.origin, Woitems.prodserv, Woitems.location,;
>  Woitems.contractor, Woitems.contsub, Woitems.baserate, Woitems.status,;
>  Woitems.qty, Woitems.price, Woitems.invqty, Woitems.invprice,;
>  Woitems.custqty, Woitems.custprice, Woitems.notes, Woitems.t_key,;
>  Woitems.p_key, Woitems.q_key, Woitems.damages, Woitems.vo_cust,;
>  Woitems.vo_cont, Woitems.c_price, Woitems.qa_raised, Woitems.qa_note,;
>  Woitems.i_key, Woitems.modno, Woitems.schedule, Woitems.jobcost,;
>  Woitems.gl, Woitems.viz, Woitems.pmod, Woitems.qmod, Woitems.mastkey,;
>  Woitems.capital;
> FROM ;
>     woitems Woitems;
> WHERE  Woitems.wo_id = ( ?lnWo_id )
>
>DBSetProp(ThisView,"View","SendUpdates",.T.)
>DBSetProp(ThisView,"View","BatchUpdateCount",1)
>DBSetProp(ThisView,"View","CompareMemo",.T.)
>DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
>DBSetProp(ThisView,"View","FetchMemo",.T.)
>DBSetProp(ThisView,"View","FetchSize",100)
>DBSetProp(ThisView,"View","MaxRecords",-1)
>DBSetProp(ThisView,"View","Prepared",.F.)
>DBSetProp(ThisView,"View","ShareConnection",.F.)
>DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
>DBSetProp(ThisView,"View","UpdateType",1)
>DBSetProp(ThisView,"View","UseMemoSize",255)
>DBSetProp(ThisView,"View","Tables","woitems")
>DBSetProp(ThisView,"View","WhereType",3)
>
>DBSetProp(ThisView+".wo_id","Field","DataType","I")
>DBSetProp(ThisView+".wo_id","Field","UpdateName","woitems.wo_id")
>DBSetProp(ThisView+".wo_id","Field","KeyField",.F.)
>DBSetProp(ThisView+".wo_id","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".wo_itemno","Field","DataType","I")
>DBSetProp(ThisView+".wo_itemno","Field","DefaultValue","NEWID_R("+CHR(34)+"WOITEMS"+CHR(34)+")")
>DBSetProp(ThisView+".wo_itemno","Field","UpdateName","woitems.wo_itemno")
>DBSetProp(ThisView+".wo_itemno","Field","KeyField",.T.)
>DBSetProp(ThisView+".wo_itemno","Field","Updatable",.F.)
>
>DBSetProp(ThisView+".ex_ref","Field","DataType","C(10)")
>DBSetProp(ThisView+".ex_ref","Field","UpdateName","woitems.ex_ref")
>DBSetProp(ThisView+".ex_ref","Field","KeyField",.F.)
>DBSetProp(ThisView+".ex_ref","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".contractcode","Field","DataType","C(10)")
>DBSetProp(ThisView+".contractcode","Field","UpdateName","woitems.contractcode")
>DBSetProp(ThisView+".contractcode","Field","KeyField",.F.)
>DBSetProp(ThisView+".contractcode","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".origin","Field","DataType","C(1)")
>DBSetProp(ThisView+".origin","Field","UpdateName","woitems.origin")
>DBSetProp(ThisView+".origin","Field","KeyField",.F.)
>DBSetProp(ThisView+".origin","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".prodserv","Field","DataType","C(10)")
>DBSetProp(ThisView+".prodserv","Field","UpdateName","woitems.prodserv")
>DBSetProp(ThisView+".prodserv","Field","KeyField",.F.)
>DBSetProp(ThisView+".prodserv","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".location","Field","DataType","C(4)")
>DBSetProp(ThisView+".location","Field","UpdateName","woitems.location")
>DBSetProp(ThisView+".location","Field","KeyField",.F.)
>DBSetProp(ThisView+".location","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".contractor","Field","DataType","C(10)")
>DBSetProp(ThisView+".contractor","Field","UpdateName","woitems.contractor")
>DBSetProp(ThisView+".contractor","Field","KeyField",.F.)
>DBSetProp(ThisView+".contractor","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".contsub","Field","DataType","C(10)")
>DBSetProp(ThisView+".contsub","Field","UpdateName","woitems.contsub")
>DBSetProp(ThisView+".contsub","Field","KeyField",.F.)
>DBSetProp(ThisView+".contsub","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".baserate","Field","DataType","N(10,3)")
>DBSetProp(ThisView+".baserate","Field","UpdateName","woitems.baserate")
>DBSetProp(ThisView+".baserate","Field","KeyField",.F.)
>DBSetProp(ThisView+".baserate","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".status","Field","DataType","C(1)")
>DBSetProp(ThisView+".status","Field","UpdateName","woitems.status")
>DBSetProp(ThisView+".status","Field","KeyField",.F.)
>DBSetProp(ThisView+".status","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".qty","Field","DataType","N(8,2)")
>DBSetProp(ThisView+".qty","Field","UpdateName","woitems.qty")
>DBSetProp(ThisView+".qty","Field","KeyField",.F.)
>DBSetProp(ThisView+".qty","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".price","Field","DataType","N(10,2)")
>DBSetProp(ThisView+".price","Field","UpdateName","woitems.price")
>DBSetProp(ThisView+".price","Field","KeyField",.F.)
>DBSetProp(ThisView+".price","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".invqty","Field","DataType","N(8,2)")
>DBSetProp(ThisView+".invqty","Field","UpdateName","woitems.invqty")
>DBSetProp(ThisView+".invqty","Field","KeyField",.F.)
>DBSetProp(ThisView+".invqty","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".invprice","Field","DataType","N(10,2)")
>DBSetProp(ThisView+".invprice","Field","UpdateName","woitems.invprice")
>DBSetProp(ThisView+".invprice","Field","KeyField",.F.)
>DBSetProp(ThisView+".invprice","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".custqty","Field","DataType","N(8,2)")
>DBSetProp(ThisView+".custqty","Field","UpdateName","woitems.custqty")
>DBSetProp(ThisView+".custqty","Field","KeyField",.F.)
>DBSetProp(ThisView+".custqty","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".custprice","Field","DataType","N(10,2)")
>DBSetProp(ThisView+".custprice","Field","UpdateName","woitems.custprice")
>DBSetProp(ThisView+".custprice","Field","KeyField",.F.)
>DBSetProp(ThisView+".custprice","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".notes","Field","DataType","M")
>DBSetProp(ThisView+".notes","Field","DefaultValue",".NULL.")
>DBSetProp(ThisView+".notes","Field","UpdateName","woitems.notes")
>DBSetProp(ThisView+".notes","Field","KeyField",.F.)
>DBSetProp(ThisView+".notes","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".t_key","Field","DataType","I")
>DBSetProp(ThisView+".t_key","Field","UpdateName","woitems.t_key")
>DBSetProp(ThisView+".t_key","Field","KeyField",.F.)
>DBSetProp(ThisView+".t_key","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".p_key","Field","DataType","I")
>DBSetProp(ThisView+".p_key","Field","UpdateName","woitems.p_key")
>DBSetProp(ThisView+".p_key","Field","KeyField",.F.)
>DBSetProp(ThisView+".p_key","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".q_key","Field","DataType","I")
>DBSetProp(ThisView+".q_key","Field","UpdateName","woitems.q_key")
>DBSetProp(ThisView+".q_key","Field","KeyField",.F.)
>DBSetProp(ThisView+".q_key","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".damages","Field","DataType","L")
>DBSetProp(ThisView+".damages","Field","UpdateName","woitems.damages")
>DBSetProp(ThisView+".damages","Field","KeyField",.F.)
>DBSetProp(ThisView+".damages","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".vo_cust","Field","DataType","L")
>DBSetProp(ThisView+".vo_cust","Field","UpdateName","woitems.vo_cust")
>DBSetProp(ThisView+".vo_cust","Field","KeyField",.F.)
>DBSetProp(ThisView+".vo_cust","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".vo_cont","Field","DataType","L")
>DBSetProp(ThisView+".vo_cont","Field","UpdateName","woitems.vo_cont")
>DBSetProp(ThisView+".vo_cont","Field","KeyField",.F.)
>DBSetProp(ThisView+".vo_cont","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".c_price","Field","DataType","N(10,2)")
>DBSetProp(ThisView+".c_price","Field","UpdateName","woitems.c_price")
>DBSetProp(ThisView+".c_price","Field","KeyField",.F.)
>DBSetProp(ThisView+".c_price","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".qa_raised","Field","DataType","L")
>DBSetProp(ThisView+".qa_raised","Field","UpdateName","woitems.qa_raised")
>DBSetProp(ThisView+".qa_raised","Field","KeyField",.F.)
>DBSetProp(ThisView+".qa_raised","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".qa_note","Field","DataType","M")
>DBSetProp(ThisView+".qa_note","Field","DefaultValue",".NULL.")
>DBSetProp(ThisView+".qa_note","Field","UpdateName","woitems.qa_note")
>DBSetProp(ThisView+".qa_note","Field","KeyField",.F.)
>DBSetProp(ThisView+".qa_note","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".i_key","Field","DataType","I")
>DBSetProp(ThisView+".i_key","Field","UpdateName","woitems.i_key")
>DBSetProp(ThisView+".i_key","Field","KeyField",.F.)
>DBSetProp(ThisView+".i_key","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".modno","Field","DataType","I")
>DBSetProp(ThisView+".modno","Field","UpdateName","woitems.modno")
>DBSetProp(ThisView+".modno","Field","KeyField",.F.)
>DBSetProp(ThisView+".modno","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".schedule","Field","DataType","N(2)")
>DBSetProp(ThisView+".schedule","Field","UpdateName","woitems.schedule")
>DBSetProp(ThisView+".schedule","Field","KeyField",.F.)
>DBSetProp(ThisView+".schedule","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".jobcost","Field","DataType","C(10)")
>DBSetProp(ThisView+".jobcost","Field","UpdateName","woitems.jobcost")
>DBSetProp(ThisView+".jobcost","Field","KeyField",.F.)
>DBSetProp(ThisView+".jobcost","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".gl","Field","DataType","C(30)")
>DBSetProp(ThisView+".gl","Field","UpdateName","woitems.gl")
>DBSetProp(ThisView+".gl","Field","KeyField",.F.)
>DBSetProp(ThisView+".gl","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".viz","Field","DataType","N(1)")
>DBSetProp(ThisView+".viz","Field","UpdateName","woitems.viz")
>DBSetProp(ThisView+".viz","Field","KeyField",.F.)
>DBSetProp(ThisView+".viz","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".pmod","Field","DataType","N(1)")
>DBSetProp(ThisView+".pmod","Field","UpdateName","woitems.pmod")
>DBSetProp(ThisView+".pmod","Field","KeyField",.F.)
>DBSetProp(ThisView+".pmod","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".qmod","Field","DataType","N(1)")
>DBSetProp(ThisView+".qmod","Field","UpdateName","woitems.qmod")
>DBSetProp(ThisView+".qmod","Field","KeyField",.F.)
>DBSetProp(ThisView+".qmod","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".mastkey","Field","DataType","I")
>DBSetProp(ThisView+".mastkey","Field","UpdateName","woitems.mastkey")
>DBSetProp(ThisView+".mastkey","Field","KeyField",.F.)
>DBSetProp(ThisView+".mastkey","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".capital","Field","DataType","N(1)")
>DBSetProp(ThisView+".capital","Field","UpdateName","woitems.capital")
>DBSetProp(ThisView+".capital","Field","KeyField",.F.)
>DBSetProp(ThisView+".capital","Field","Updatable",.T.)