view defenition has changed, how to solve? 1

Nifrabar · Nov 1, 2010

Hello to all!
This error happened before to me about 4 years ago.
I do have a parametrized view.
Once I have other parameter and I try to requery the view than I get error : view defenition has changed

In the past Tamar Granor helped me to solve this.
Those days I also had many NVL()'s in the view.
Tamar learned me that if these should be original null-value they might turn into C(1).
So I changed all into padr(nvl(field,""),10).
That solved the problem.
So I tried almost same now but without result.

Any idea how to solve this?

TIA
-Bart

Code:

SELECT Toverledenen.noverl_id, Toverledenen.linoverl,;
  Toverledenen.cpgn AS overl_bsn,;
  combineer(Toverledenen.cvnaam,Toverledenen.ctnaam,Toverledenen.canaam) AS overl_naam,;
  Toverledenen.cgeslacht AS overl_geslacht, Toverledenen.ngebdag,;
  Toverledenen.ngebmnd, Toverledenen.ngebjr,;
  num2dat(Toverledenen.ngebdag,Toverledenen.ngebmnd,Toverledenen.ngebjr) AS gebdat,;
  Toverledenen.cgebplts AS overl_gebplaats, Toverledenen.nsterfdag,;
  Toverledenen.nsterfmnd, Toverledenen.nsterfjr,;
  num2dat(Toverledenen.nsterfdag,Toverledenen.nsterfmnd,Toverledenen.nsterfjr) AS sterfdat,;
  Toverledenen.csterfplts AS overl_sterfplaats, Toverledenen.nbegrdag,;
  Toverledenen.nbegrmnd, Toverledenen.nbegrjr,;
  num2dat(Toverledenen.nbegrdag,Toverledenen.nbegrmnd,Toverledenen.nbegrjr) AS begraafdat,;
  Toverledenen.nbegrsrt AS overl_begrsrt,;
  Toverledenen.copmerk AS overl_opmerking,;
  PADR(combineer(Toverledenen.cstraat,Toverledenen.chuisnum,Toverledenen.chuislet,Toverledenen.chuistoe),40) AS overl_adres,;
  PADR(combineer(Toverledenen.cpcd,Toverledenen.cplaats),40) AS overl_pcdplaats,;
  Toverledenen.nsoort, Toverledenen.nstatus AS overl_status,;
  Tgraven.ngraf_id, Tgraven.cvak, Tgraven.crij, Tgraven.cnummer,;
  Tgraven.nlaag,;
  combineer(Tgraven.cvak,Tgraven.crij,Tgraven.cnummer,ALLTRIM(STR(Tgraven.nlaag))) AS lokatie,;
  Tgraven.copmerk AS graf_opmerking, Tgrafgroep.dgrechttot,;
  NVL(Tgraven.nstatus,0) AS graf_status, NVL(Tmm_ov_cnt.id,0) AS id,;
  NVL(Tmm_ov_cnt.nstatus,0) AS nstatus,;
  NVL(Tmm_ov_cnt.lfincontact,.F.) AS fincontact,;
  NVL(Tcontactpers.ncont_id,0) AS ncont_id,;
  PADR(NVL(Tcontactpers.cpgn,""),10) AS contact_bsn,;
  PADR(NVL(Tcontactpers.caanhef,""),20) AS caanhef,;
  PADR(combineer(Tcontactpers.cvnaam,Tcontactpers.ctnaam,Tcontactpers.canaam),40) AS contact_naam,;
  PADR(combineer(Tcontactpers.cstraat,Tcontactpers.chuisnum,Tcontactpers.chuislet,Tcontactpers.chuistoe),40) AS contact_adres,;
  PADR(combineer(Tcontactpers.cpcd,Tcontactpers.cplaats),40) AS contact_pcdplaats,;
  PADR(NVL(Tcontactpers.ctelnetnum,""),5) AS contact_netnum,;
  PADR(NVL(Tcontactpers.ctelefoon,""),27) AS contact_telefoon,;
  PADR(NVL(Tcontactpers.cemail,""),46) AS contact_email,;
  PADR(NVL(Tcontactpers.crekening,""),10) AS crekening,;
  PADR(NVL(Tcontactpers.copmerk,""),254) AS contact_opmerking,;
  PADR(NVL(Tcontactpers.cgsm,""),12) AS contact_gsm,;
  NVL(Tcontactpers.nstatus,0) AS contact_status,;
  PADR(NVL(Tcontactpers.copmerk,""),254) AS copmerk,;
  PADR(NVL(Tcontactpers.cgeslacht,""),1) AS contact_geslacht,;
  Tgrafsoort.grafsoort AS csoort, Tgrafgroep.nruimdag,;
  Tgrafgroep.nruimmnd, Tgrafgroep.nruimjr,;
  num2dat(Tgrafgroep.nruimdag,Tgrafgroep.nruimmnd,Tgrafgroep.nruimjr) AS ruimdat;
 FROM ;
     db_kerkhof!toverledenen ;
    LEFT OUTER JOIN db_kerkhof!tmm_ov_cnt ;
   ON  Toverledenen.noverl_id = Tmm_ov_cnt.noverl_id ;
    LEFT OUTER JOIN db_kerkhof!tmm_ov_graf ;
   ON  Toverledenen.noverl_id = Tmm_ov_graf.noverl_id ;
    LEFT OUTER JOIN db_kerkhof!tgraven ;
   ON  Tmm_ov_graf.ngraf_id = Tgraven.ngraf_id ;
    LEFT OUTER JOIN db_kerkhof!tgrafgroep ;
   ON  Tgraven.ngroep = Tgrafgroep.ngroep ;
    LEFT OUTER JOIN db_kerkhof!tgrafsoort ;
   ON  Tgrafgroep.nsoort = Tgrafsoort.grafsrt_id ;
    LEFT OUTER JOIN db_kerkhof!tcontactpers ;
   ON  Tmm_ov_cnt.ncont_id = Tcontactpers.ncont_id;
 WHERE  Toverledenen.noverl_id = ( ?gnOverlID )

DBSetProp(ThisView,"View","SendUpdates",.F.)
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","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","db_kerkhof!toverledenen,db_kerkhof!tgraven,db_kerkhof!tgrafsoort")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".noverl_id","Field","DataType","I")
DBSetProp(ThisView+".noverl_id","Field","UpdateName","db_kerkhof!toverledenen.noverl_id")
DBSetProp(ThisView+".noverl_id","Field","KeyField",.F.)
DBSetProp(ThisView+".noverl_id","Field","Updatable",.F.)

DBSetProp(ThisView+".linoverl","Field","DataType","C(5)")
DBSetProp(ThisView+".linoverl","Field","UpdateName","db_kerkhof!toverledenen.linoverl")
DBSetProp(ThisView+".linoverl","Field","KeyField",.F.)
DBSetProp(ThisView+".linoverl","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_bsn","Field","Caption","PGN")
DBSetProp(ThisView+".overl_bsn","Field","Comment","persoonsgebonden nummer voorheen sofinummer")
DBSetProp(ThisView+".overl_bsn","Field","DataType","C(9)")
DBSetProp(ThisView+".overl_bsn","Field","UpdateName","db_kerkhof!toverledenen.cpgn")
DBSetProp(ThisView+".overl_bsn","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_bsn","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_naam","Field","DataType","C(1)")
DBSetProp(ThisView+".overl_naam","Field","UpdateName","TOVERLEDENEN.CANAAM)")
DBSetProp(ThisView+".overl_naam","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_naam","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_geslacht","Field","Comment","M(an)  of V(rouw) of O(nbekend)")
DBSetProp(ThisView+".overl_geslacht","Field","DataType","C(1)")
DBSetProp(ThisView+".overl_geslacht","Field","UpdateName","db_kerkhof!toverledenen.cgeslacht")
DBSetProp(ThisView+".overl_geslacht","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_geslacht","Field","Updatable",.T.)

DBSetProp(ThisView+".ngebdag","Field","Caption","Geb.Dag")
DBSetProp(ThisView+".ngebdag","Field","Comment","geboortedag (dag van maand)")
DBSetProp(ThisView+".ngebdag","Field","DataType","I")
DBSetProp(ThisView+".ngebdag","Field","UpdateName","db_kerkhof!toverledenen.ngebdag")
DBSetProp(ThisView+".ngebdag","Field","KeyField",.F.)
DBSetProp(ThisView+".ngebdag","Field","Updatable",.T.)

DBSetProp(ThisView+".ngebmnd","Field","Caption","Geb.Mnd.")
DBSetProp(ThisView+".ngebmnd","Field","Comment","Geboortemaand")
DBSetProp(ThisView+".ngebmnd","Field","DataType","I")
DBSetProp(ThisView+".ngebmnd","Field","UpdateName","db_kerkhof!toverledenen.ngebmnd")
DBSetProp(ThisView+".ngebmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".ngebmnd","Field","Updatable",.T.)

DBSetProp(ThisView+".ngebjr","Field","Caption","Geb.Jr.")
DBSetProp(ThisView+".ngebjr","Field","Comment","Geboortejaar")
DBSetProp(ThisView+".ngebjr","Field","DataType","I")
DBSetProp(ThisView+".ngebjr","Field","UpdateName","db_kerkhof!toverledenen.ngebjr")
DBSetProp(ThisView+".ngebjr","Field","KeyField",.F.)
DBSetProp(ThisView+".ngebjr","Field","Updatable",.T.)

DBSetProp(ThisView+".gebdat","Field","DataType","C(10)")
DBSetProp(ThisView+".gebdat","Field","KeyField",.F.)
DBSetProp(ThisView+".gebdat","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_gebplaats","Field","Caption","Geb.plaats")
DBSetProp(ThisView+".overl_gebplaats","Field","Comment","geboorteplaats")
DBSetProp(ThisView+".overl_gebplaats","Field","DataType","C(35)")
DBSetProp(ThisView+".overl_gebplaats","Field","UpdateName","db_kerkhof!toverledenen.cgebplts")
DBSetProp(ThisView+".overl_gebplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_gebplaats","Field","Updatable",.T.)

DBSetProp(ThisView+".nsterfdag","Field","Caption","Dag van Overl.")
DBSetProp(ThisView+".nsterfdag","Field","Comment","dag van maand")
DBSetProp(ThisView+".nsterfdag","Field","DataType","I")
DBSetProp(ThisView+".nsterfdag","Field","UpdateName","db_kerkhof!toverledenen.nsterfdag")
DBSetProp(ThisView+".nsterfdag","Field","KeyField",.F.)
DBSetProp(ThisView+".nsterfdag","Field","Updatable",.T.)

DBSetProp(ThisView+".nsterfmnd","Field","Caption","Mnd.van Overl.")
DBSetProp(ThisView+".nsterfmnd","Field","DataType","I")
DBSetProp(ThisView+".nsterfmnd","Field","UpdateName","db_kerkhof!toverledenen.nsterfmnd")
DBSetProp(ThisView+".nsterfmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".nsterfmnd","Field","Updatable",.T.)

DBSetProp(ThisView+".nsterfjr","Field","Caption","Jaar van Overl.")
DBSetProp(ThisView+".nsterfjr","Field","DataType","I")
DBSetProp(ThisView+".nsterfjr","Field","UpdateName","db_kerkhof!toverledenen.nsterfjr")
DBSetProp(ThisView+".nsterfjr","Field","KeyField",.F.)
DBSetProp(ThisView+".nsterfjr","Field","Updatable",.T.)

DBSetProp(ThisView+".sterfdat","Field","DataType","C(10)")
DBSetProp(ThisView+".sterfdat","Field","KeyField",.F.)
DBSetProp(ThisView+".sterfdat","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_sterfplaats","Field","Caption","Overl.Plaats")
DBSetProp(ThisView+".overl_sterfplaats","Field","Comment","Plaats van overlijden")
DBSetProp(ThisView+".overl_sterfplaats","Field","DataType","C(35)")
DBSetProp(ThisView+".overl_sterfplaats","Field","UpdateName","db_kerkhof!toverledenen.csterfplts")
DBSetProp(ThisView+".overl_sterfplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_sterfplaats","Field","Updatable",.T.)

DBSetProp(ThisView+".nbegrdag","Field","Caption","Dag Begr.")
DBSetProp(ThisView+".nbegrdag","Field","DataType","I")
DBSetProp(ThisView+".nbegrdag","Field","UpdateName","db_kerkhof!toverledenen.nbegrdag")
DBSetProp(ThisView+".nbegrdag","Field","KeyField",.F.)
DBSetProp(ThisView+".nbegrdag","Field","Updatable",.T.)

DBSetProp(ThisView+".nbegrmnd","Field","Caption","Mnd.Begr.")
DBSetProp(ThisView+".nbegrmnd","Field","DataType","I")
DBSetProp(ThisView+".nbegrmnd","Field","UpdateName","db_kerkhof!toverledenen.nbegrmnd")
DBSetProp(ThisView+".nbegrmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".nbegrmnd","Field","Updatable",.T.)

DBSetProp(ThisView+".nbegrjr","Field","Caption","Jr.Begr.")
DBSetProp(ThisView+".nbegrjr","Field","DataType","I")
DBSetProp(ThisView+".nbegrjr","Field","UpdateName","db_kerkhof!toverledenen.nbegrjr")
DBSetProp(ThisView+".nbegrjr","Field","KeyField",.F.)
DBSetProp(ThisView+".nbegrjr","Field","Updatable",.T.)

DBSetProp(ThisView+".begraafdat","Field","DataType","C(10)")
DBSetProp(ThisView+".begraafdat","Field","KeyField",.F.)
DBSetProp(ThisView+".begraafdat","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_begrsrt","Field","Caption","Begr-Crem.")
DBSetProp(ThisView+".overl_begrsrt","Field","Comment","1=begraven  "+CHR(13)+"2=crematie"+CHR(13)+CHR(10)+"3=urn bijzetting"+CHR(13)+"4=herbegraven")
DBSetProp(ThisView+".overl_begrsrt","Field","DataType","I")
DBSetProp(ThisView+".overl_begrsrt","Field","UpdateName","db_kerkhof!toverledenen.nbegrsrt")
DBSetProp(ThisView+".overl_begrsrt","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_begrsrt","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_opmerking","Field","Caption","Opmerking")
DBSetProp(ThisView+".overl_opmerking","Field","DataType","C(254)")
DBSetProp(ThisView+".overl_opmerking","Field","UpdateName","db_kerkhof!toverledenen.copmerk")
DBSetProp(ThisView+".overl_opmerking","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_opmerking","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_adres","Field","DataType","C(40)")
DBSetProp(ThisView+".overl_adres","Field","UpdateName","40)")
DBSetProp(ThisView+".overl_adres","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_adres","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_pcdplaats","Field","DataType","C(40)")
DBSetProp(ThisView+".overl_pcdplaats","Field","UpdateName","40)")
DBSetProp(ThisView+".overl_pcdplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_pcdplaats","Field","Updatable",.F.)

DBSetProp(ThisView+".nsoort","Field","Caption","Soort")
DBSetProp(ThisView+".nsoort","Field","Comment","1=normaal"+CHR(13)+"2=koop"+CHR(13)+"3=kind")
DBSetProp(ThisView+".nsoort","Field","DataType","I")
DBSetProp(ThisView+".nsoort","Field","UpdateName","db_kerkhof!toverledenen.nsoort")
DBSetProp(ThisView+".nsoort","Field","KeyField",.F.)
DBSetProp(ThisView+".nsoort","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_status","Field","Caption","Status")
DBSetProp(ThisView+".overl_status","Field","Comment","1=normaal"+CHR(13)+"2=gewist")
DBSetProp(ThisView+".overl_status","Field","DataType","I")
DBSetProp(ThisView+".overl_status","Field","UpdateName","db_kerkhof!toverledenen.nstatus")
DBSetProp(ThisView+".overl_status","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_status","Field","Updatable",.F.)

DBSetProp(ThisView+".ngraf_id","Field","Caption","Graf-ID")
DBSetProp(ThisView+".ngraf_id","Field","DataType","I")
DBSetProp(ThisView+".ngraf_id","Field","UpdateName","db_kerkhof!tgraven.ngraf_id")
DBSetProp(ThisView+".ngraf_id","Field","KeyField",.F.)
DBSetProp(ThisView+".ngraf_id","Field","Updatable",.F.)

DBSetProp(ThisView+".cvak","Field","Caption","Vak")
DBSetProp(ThisView+".cvak","Field","DataType","C(9)")
DBSetProp(ThisView+".cvak","Field","UpdateName","db_kerkhof!tgraven.cvak")
DBSetProp(ThisView+".cvak","Field","KeyField",.F.)
DBSetProp(ThisView+".cvak","Field","Updatable",.T.)

DBSetProp(ThisView+".crij","Field","Caption","Rij")
DBSetProp(ThisView+".crij","Field","DataType","C(9)")
DBSetProp(ThisView+".crij","Field","UpdateName","db_kerkhof!tgraven.crij")
DBSetProp(ThisView+".crij","Field","KeyField",.F.)
DBSetProp(ThisView+".crij","Field","Updatable",.T.)

DBSetProp(ThisView+".cnummer","Field","Caption","Nummer")
DBSetProp(ThisView+".cnummer","Field","DataType","C(9)")
DBSetProp(ThisView+".cnummer","Field","UpdateName","db_kerkhof!tgraven.cnummer")
DBSetProp(ThisView+".cnummer","Field","KeyField",.F.)
DBSetProp(ThisView+".cnummer","Field","Updatable",.T.)

DBSetProp(ThisView+".nlaag","Field","Caption","Nivo")
DBSetProp(ThisView+".nlaag","Field","DataType","I")
DBSetProp(ThisView+".nlaag","Field","UpdateName","db_kerkhof!tgraven.nlaag")
DBSetProp(ThisView+".nlaag","Field","KeyField",.F.)
DBSetProp(ThisView+".nlaag","Field","Updatable",.T.)

DBSetProp(ThisView+".lokatie","Field","DataType","C(2)")
DBSetProp(ThisView+".lokatie","Field","KeyField",.F.)
DBSetProp(ThisView+".lokatie","Field","Updatable",.F.)

DBSetProp(ThisView+".graf_opmerking","Field","DataType","C(254)")
DBSetProp(ThisView+".graf_opmerking","Field","UpdateName","db_kerkhof!tgraven.copmerk")
DBSetProp(ThisView+".graf_opmerking","Field","KeyField",.F.)
DBSetProp(ThisView+".graf_opmerking","Field","Updatable",.F.)

DBSetProp(ThisView+".dgrechttot","Field","DataType","D")
DBSetProp(ThisView+".dgrechttot","Field","UpdateName","db_kerkhof!tgrafgroep.dgrechttot")
DBSetProp(ThisView+".dgrechttot","Field","KeyField",.F.)
DBSetProp(ThisView+".dgrechttot","Field","Updatable",.F.)

DBSetProp(ThisView+".graf_status","Field","Comment","1=normaal"+CHR(13)+"2=gewist")
DBSetProp(ThisView+".graf_status","Field","DataType","N(11)")
DBSetProp(ThisView+".graf_status","Field","UpdateName","db_kerkhof!tgraven.nstatus")
DBSetProp(ThisView+".graf_status","Field","KeyField",.F.)
DBSetProp(ThisView+".graf_status","Field","Updatable",.F.)

DBSetProp(ThisView+".id","Field","DataType","N(11)")
DBSetProp(ThisView+".id","Field","UpdateName","db_kerkhof!tmm_ov_cnt.id")
DBSetProp(ThisView+".id","Field","KeyField",.F.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)

DBSetProp(ThisView+".nstatus","Field","DataType","N(11)")
DBSetProp(ThisView+".nstatus","Field","UpdateName","db_kerkhof!tmm_ov_cnt.nstatus")
DBSetProp(ThisView+".nstatus","Field","KeyField",.F.)
DBSetProp(ThisView+".nstatus","Field","Updatable",.F.)

DBSetProp(ThisView+".fincontact","Field","DataType","L")
DBSetProp(ThisView+".fincontact","Field","UpdateName","db_kerkhof!tmm_ov_cnt.lfincontact")
DBSetProp(ThisView+".fincontact","Field","KeyField",.F.)
DBSetProp(ThisView+".fincontact","Field","Updatable",.F.)

DBSetProp(ThisView+".ncont_id","Field","DataType","N(11)")
DBSetProp(ThisView+".ncont_id","Field","UpdateName","db_kerkhof!tcontactpers.ncont_id")
DBSetProp(ThisView+".ncont_id","Field","KeyField",.F.)
DBSetProp(ThisView+".ncont_id","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_bsn","Field","Comment","BSN nummer")
DBSetProp(ThisView+".contact_bsn","Field","DataType","C(10)")
DBSetProp(ThisView+".contact_bsn","Field","UpdateName","db_kerkhof!tcontactpers.cpgn")
DBSetProp(ThisView+".contact_bsn","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_bsn","Field","Updatable",.F.)

DBSetProp(ThisView+".caanhef","Field","DataType","C(20)")
DBSetProp(ThisView+".caanhef","Field","UpdateName","db_kerkhof!tcontactpers.caanhef")
DBSetProp(ThisView+".caanhef","Field","KeyField",.F.)
DBSetProp(ThisView+".caanhef","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_naam","Field","DataType","C(40)")
DBSetProp(ThisView+".contact_naam","Field","UpdateName","40)")
DBSetProp(ThisView+".contact_naam","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_naam","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_adres","Field","DataType","C(40)")
DBSetProp(ThisView+".contact_adres","Field","UpdateName","40)")
DBSetProp(ThisView+".contact_adres","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_adres","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_pcdplaats","Field","DataType","C(40)")
DBSetProp(ThisView+".contact_pcdplaats","Field","UpdateName","40)")
DBSetProp(ThisView+".contact_pcdplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_pcdplaats","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_netnum","Field","DataType","C(5)")
DBSetProp(ThisView+".contact_netnum","Field","UpdateName","db_kerkhof!tcontactpers.ctelnetnum")
DBSetProp(ThisView+".contact_netnum","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_netnum","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_telefoon","Field","DataType","C(27)")
DBSetProp(ThisView+".contact_telefoon","Field","UpdateName","db_kerkhof!tcontactpers.ctelefoon")
DBSetProp(ThisView+".contact_telefoon","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_telefoon","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_email","Field","DataType","C(46)")
DBSetProp(ThisView+".contact_email","Field","UpdateName","db_kerkhof!tcontactpers.cemail")
DBSetProp(ThisView+".contact_email","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_email","Field","Updatable",.F.)

DBSetProp(ThisView+".crekening","Field","Comment","bankrekening")
DBSetProp(ThisView+".crekening","Field","DataType","C(10)")
DBSetProp(ThisView+".crekening","Field","UpdateName","db_kerkhof!tcontactpers.crekening")
DBSetProp(ThisView+".crekening","Field","KeyField",.F.)
DBSetProp(ThisView+".crekening","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_opmerking","Field","DataType","C(254)")
DBSetProp(ThisView+".contact_opmerking","Field","UpdateName","db_kerkhof!tcontactpers.copmerk")
DBSetProp(ThisView+".contact_opmerking","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_opmerking","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_gsm","Field","DataType","C(12)")
DBSetProp(ThisView+".contact_gsm","Field","UpdateName","db_kerkhof!tcontactpers.cgsm")
DBSetProp(ThisView+".contact_gsm","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_gsm","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_status","Field","DataType","N(11)")
DBSetProp(ThisView+".contact_status","Field","UpdateName","db_kerkhof!tcontactpers.nstatus")
DBSetProp(ThisView+".contact_status","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_status","Field","Updatable",.F.)

DBSetProp(ThisView+".copmerk","Field","DataType","C(254)")
DBSetProp(ThisView+".copmerk","Field","KeyField",.F.)
DBSetProp(ThisView+".copmerk","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_geslacht","Field","DataType","C(1)")
DBSetProp(ThisView+".contact_geslacht","Field","UpdateName","db_kerkhof!tcontactpers.cgeslacht")
DBSetProp(ThisView+".contact_geslacht","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_geslacht","Field","Updatable",.F.)

DBSetProp(ThisView+".csoort","Field","Caption","Graf/Urn")
DBSetProp(ThisView+".csoort","Field","Comment","g=graf"+CHR(13)+"u=urn")
DBSetProp(ThisView+".csoort","Field","DataType","C(20)")
DBSetProp(ThisView+".csoort","Field","UpdateName","db_kerkhof!tgrafsoort.grafsoort")
DBSetProp(ThisView+".csoort","Field","KeyField",.F.)
DBSetProp(ThisView+".csoort","Field","Updatable",.T.)

DBSetProp(ThisView+".nruimdag","Field","DataType","I")
DBSetProp(ThisView+".nruimdag","Field","UpdateName","db_kerkhof!tgrafgroep.nruimdag")
DBSetProp(ThisView+".nruimdag","Field","KeyField",.F.)
DBSetProp(ThisView+".nruimdag","Field","Updatable",.F.)

DBSetProp(ThisView+".nruimmnd","Field","DataType","I")
DBSetProp(ThisView+".nruimmnd","Field","UpdateName","db_kerkhof!tgrafgroep.nruimmnd")
DBSetProp(ThisView+".nruimmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".nruimmnd","Field","Updatable",.F.)

DBSetProp(ThisView+".nruimjr","Field","DataType","I")
DBSetProp(ThisView+".nruimjr","Field","UpdateName","db_kerkhof!tgrafgroep.nruimjr")
DBSetProp(ThisView+".nruimjr","Field","KeyField",.F.)
DBSetProp(ThisView+".nruimjr","Field","Updatable",.F.)

DBSetProp(ThisView+".ruimdat","Field","DataType","C(10)")
DBSetProp(ThisView+".ruimdat","Field","KeyField",.F.)
DBSetProp(ThisView+".ruimdat","Field","Updatable",.F.)

JRB-Bldr · Nov 1, 2010

Has the structure of your source table changed in any way?

If so, then you will have to re-build/re-create your View.

Even if the structure did not change, have you tried to re-create your View to eliminate the problem?

Good Luck,
JRB-Bldr

Nifrabar · Nov 2, 2010

Hi Jrbbldr,

No,
Base tables hav enot been changed.
Note that just changing only th eparm and requery the view throws the error.

Before I had same and assaid Tamar pointed me those days towards a solution which in fact prevented from a null value to change into a C(1).

Any other suggestions?

-Bart

Olaf Doschke · Nov 2, 2010

By all means all expressions used in the SQL field list must result in the same field type in all cases joins finding matching records or not and in all values to be expected from the original fields.

You're still having ambigous expressions in your SQL depending on a match (joined record) found or not, eg:

NVL(Tcontactpers.nstatus,0) AS contact_status

If a match is found this results in the field type of Tcontactpers.nstatus

If there is no match even though you prevetn NULL with NVL this may not result in the type of nstatus. 0 does not specify integer fields, the default will be some kind of N(1) field or even a float, but surely no integer.

Depending on the field type of Tcontactpers.nstatus you need to enforce this field type with the expression in case of a NULL, so you need a CAST, eg

CAST(NVL(Tcontactpers.nstatus,0) As int) AS contact_status

In fact with CAST you could also accept NULLs, as you can set the type with CAST even in case the value is NULL, eg you also could do:

CAST(Tcontactpers.nstatus As int) AS contact_status

But that may introduce some needed changes in the code working with the result data, as you would need to handle NULLs then.

The main piont is, that a view resul needs to always have the same structure as if the view waws a table. As in a table a field can only be one field type, it can't be an int in some cases and a date in another case. So what matters more than preventing NULLs is casting the correct field type.

If you don't have VFP9 and CAST is not available you can use a trick and define a cursor with field types, eg curDumm.nInt, add one record to it and use this field of the record as a typed variable in your expression, eg

Before executing/using the view create a cursor with
CREATE CURSOR curDummyvalues (nInt I Default 0)
APPEND BLANK

In the view you can now use curDummyvalues.nInt to enforce an integer field in the result, eg you can use

NVL(Tcontactpers.nstatus, curDummyvalues.nInt) AS contact_status

Bye, Olaf.

Nifrabar · Nov 2, 2010

Hi Olaf,

Thanks very much for your clear answer.
I will try to adapt my view with your advice useing the cast function. The trailing part 'as INT' was slipped from my mind.
I will look in the help-file for the remaining trailing figures for the logic fields and string based fields. You were right that my nStatus field is integer based.
I use to have an nStatus field in all tabledefinitions to be more fexible about record status.

Anyway thanks and star for you!

-Bart

Mike Lewis · Nov 2, 2010

Bart,

When I opened this thread, the Google Toolbar told me that it was in Dutch, and would I like to it translated. Just for fun, I said Yes.

Your code did not change, but all the other text in the thread is now in Spanish. JRB-Bldr's signature is OCR-Bldr.

Isn't software fun?

Hasta luego, Bartolomé.

Miguel

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

Nifrabar · Nov 2, 2010

Hi Mike,

Black magic using the google software or Sherlock Holmes working with them finding my roots

?

Just for the records find hereunder my updated view-code.
I found that I also had to cast my UDF's.

Once again, thanks to Olaf.

-Bart

Code:

SELECT Toverledenen.noverl_id, Toverledenen.linoverl,;
  Toverledenen.cpgn AS overl_bsn,;
  CAST(combineer(Toverledenen.cvnaam,Toverledenen.ctnaam,Toverledenen.canaam) AS C(20)) AS overl_naam,;
  Toverledenen.cgeslacht AS overl_geslacht, Toverledenen.ngebdag,;
  Toverledenen.ngebmnd, Toverledenen.ngebjr,;
  CAST(num2dat(Toverledenen.ngebdag,Toverledenen.ngebmnd,Toverledenen.ngebjr) AS C(12)) AS gebdat,;
  Toverledenen.cgebplts AS overl_gebplaats, Toverledenen.nsterfdag,;
  Toverledenen.nsterfmnd, Toverledenen.nsterfjr,;
  CAST(num2dat(Toverledenen.nsterfdag,Toverledenen.nsterfmnd,Toverledenen.nsterfjr) AS C(12)) AS sterfdat,;
  Toverledenen.csterfplts AS overl_sterfplaats, Toverledenen.nbegrdag,;
  Toverledenen.nbegrmnd, Toverledenen.nbegrjr,;
  CAST(num2dat(Toverledenen.nbegrdag,Toverledenen.nbegrmnd,Toverledenen.nbegrjr) AS C(12)) AS begraafdat,;
  Toverledenen.nbegrsrt AS overl_begrsrt,;
  Toverledenen.copmerk AS overl_opmerking,;
  CAST(combineer(Toverledenen.cstraat,Toverledenen.chuisnum,Toverledenen.chuislet,Toverledenen.chuistoe) AS C(40)) AS overl_adres,;
  CAST(combineer(Toverledenen.cpcd,Toverledenen.cplaats) AS C(40)) AS overl_pcdplaats,;
  Toverledenen.nsoort, Toverledenen.nstatus AS overl_status,;
  CAST(NVL(Tgraven.ngraf_id,0) AS I) AS ngraf_id,;
  CAST(NVL(Tgraven.cvak,"") AS C(9)) AS cvak,;
  CAST(NVL(Tgraven.crij,"") AS C(9)) AS crij,;
  CAST(NVL(Tgraven.cnummer,"") AS C(9)) AS cnummer,;
  CAST(NVL(Tgraven.nlaag,0) AS I) AS nlaag,;
  CAST(NVL(combineer(Tgraven.cvak,Tgraven.crij,Tgraven.cnummer,ALLTRIM(STR(Tgraven.nlaag))),"") AS C(12)) AS lokatie,;
  CAST(NVL(Tgraven.copmerk,"") AS C(254)) AS graf_opmerking,;
  CAST(NVL(Tgrafgroep.dgrechttot,{}) AS D) AS dgrechttot,;
  CAST(NVL(Tgraven.nstatus,0) AS I) AS graf_status,;
  CAST(NVL(Tmm_ov_cnt.id,0) AS I) AS id,;
  CAST(NVL(Tmm_ov_cnt.nstatus,0) AS I) AS nstatus,;
  CAST(NVL(Tmm_ov_cnt.lfincontact,.F.) AS L) AS fincontact,;
  CAST(NVL(Tcontactpers.ncont_id,0) AS I) AS ncont_id,;
  CAST(NVL(Tcontactpers.cpgn,"") AS C(10)) AS contact_bsn,;
  CAST(NVL(Tcontactpers.caanhef,"") AS C(16)) AS caanhef,;
  CAST(NVL(combineer(Tcontactpers.cvnaam,Tcontactpers.ctnaam,Tcontactpers.canaam),"") AS C(40)) AS contact_naam,;
  CAST(NVL(combineer(Tcontactpers.cstraat,Tcontactpers.chuisnum,Tcontactpers.chuislet,Tcontactpers.chuistoe),"") AS C(40)) AS contact_adres,;
  CAST(NVL(combineer(Tcontactpers.cpcd,Tcontactpers.cplaats),"") AS C(40)) AS contact_pcdplaats,;
  CAST(NVL(Tcontactpers.ctelnetnum,"") AS C(5)) AS contact_netnum,;
  CAST(NVL(Tcontactpers.ctelefoon,"") AS C(27)) AS contact_telefoon,;
  CAST(NVL(Tcontactpers.cemail,"") AS C(46)) AS contact_email,;
  CAST(NVL(Tcontactpers.crekening,"") AS C(10)) AS crekening,;
  CAST(NVL(Tcontactpers.copmerk,"") AS C(254)) AS contact_opmerking,;
  CAST(NVL(Tcontactpers.cgsm,"") AS C(12)) AS contact_gsm,;
  CAST(NVL(Tcontactpers.nstatus,0) AS I) AS contact_status,;
  CAST(NVL(Tcontactpers.copmerk,"") AS C(254)) AS copmerk,;
  CAST(NVL(Tcontactpers.cgeslacht,"") AS C(1)) AS contact_geslacht,;
  CAST(NVL(Tgrafsoort.grafsoort,"") AS C(20)) AS csoort,;
  CAST(NVL(Tgrafgroep.nruimdag,0) AS I) AS nruimdag,;
  CAST(NVL(Tgrafgroep.nruimmnd,0) AS I) AS nruimmnd,;
  CAST(NVL(Tgrafgroep.nruimjr,0) AS I) AS nruimjr,;
  CAST(num2dat(Tgrafgroep.nruimdag,Tgrafgroep.nruimmnd,Tgrafgroep.nruimjr) AS C(12)) AS ruimdat;
 FROM ;
     db_kerkhof!toverledenen ;
    LEFT OUTER JOIN db_kerkhof!tmm_ov_cnt ;
   ON  Toverledenen.noverl_id = Tmm_ov_cnt.noverl_id ;
    LEFT OUTER JOIN db_kerkhof!tmm_ov_graf ;
   ON  Toverledenen.noverl_id = Tmm_ov_graf.noverl_id ;
    LEFT OUTER JOIN db_kerkhof!tgraven ;
   ON  Tmm_ov_graf.ngraf_id = Tgraven.ngraf_id ;
    LEFT OUTER JOIN db_kerkhof!tgrafgroep ;
   ON  Tgraven.ngroep = Tgrafgroep.ngroep ;
    LEFT OUTER JOIN db_kerkhof!tgrafsoort ;
   ON  Tgrafgroep.nsoort = Tgrafsoort.grafsrt_id ;
    LEFT OUTER JOIN db_kerkhof!tcontactpers ;
   ON  Tmm_ov_cnt.ncont_id = Tcontactpers.ncont_id;
 WHERE  Toverledenen.noverl_id = ( ?gnOverlID )

DBSetProp(ThisView,"View","SendUpdates",.F.)
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","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","db_kerkhof!toverledenen")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".noverl_id","Field","DataType","I")
DBSetProp(ThisView+".noverl_id","Field","UpdateName","db_kerkhof!toverledenen.noverl_id")
DBSetProp(ThisView+".noverl_id","Field","KeyField",.F.)
DBSetProp(ThisView+".noverl_id","Field","Updatable",.F.)

DBSetProp(ThisView+".linoverl","Field","DataType","C(5)")
DBSetProp(ThisView+".linoverl","Field","UpdateName","db_kerkhof!toverledenen.linoverl")
DBSetProp(ThisView+".linoverl","Field","KeyField",.F.)
DBSetProp(ThisView+".linoverl","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_bsn","Field","Caption","PGN")
DBSetProp(ThisView+".overl_bsn","Field","Comment","persoonsgebonden nummer voorheen sofinummer")
DBSetProp(ThisView+".overl_bsn","Field","DataType","C(9)")
DBSetProp(ThisView+".overl_bsn","Field","UpdateName","db_kerkhof!toverledenen.cpgn")
DBSetProp(ThisView+".overl_bsn","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_bsn","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_naam","Field","DataType","C(20)")
DBSetProp(ThisView+".overl_naam","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_naam","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_geslacht","Field","DataType","C(1)")
DBSetProp(ThisView+".overl_geslacht","Field","UpdateName","db_kerkhof!toverledenen.cgeslacht")
DBSetProp(ThisView+".overl_geslacht","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_geslacht","Field","Updatable",.T.)

DBSetProp(ThisView+".ngebdag","Field","DataType","I")
DBSetProp(ThisView+".ngebdag","Field","UpdateName","db_kerkhof!toverledenen.ngebdag")
DBSetProp(ThisView+".ngebdag","Field","KeyField",.F.)
DBSetProp(ThisView+".ngebdag","Field","Updatable",.T.)

DBSetProp(ThisView+".ngebmnd","Field","DataType","I")
DBSetProp(ThisView+".ngebmnd","Field","UpdateName","db_kerkhof!toverledenen.ngebmnd")
DBSetProp(ThisView+".ngebmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".ngebmnd","Field","Updatable",.T.)

DBSetProp(ThisView+".ngebjr","Field","DataType","I")
DBSetProp(ThisView+".ngebjr","Field","UpdateName","db_kerkhof!toverledenen.ngebjr")
DBSetProp(ThisView+".ngebjr","Field","KeyField",.F.)
DBSetProp(ThisView+".ngebjr","Field","Updatable",.T.)

DBSetProp(ThisView+".gebdat","Field","DataType","C(12)")
DBSetProp(ThisView+".gebdat","Field","KeyField",.F.)
DBSetProp(ThisView+".gebdat","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_gebplaats","Field","DataType","C(35)")
DBSetProp(ThisView+".overl_gebplaats","Field","UpdateName","db_kerkhof!toverledenen.cgebplts")
DBSetProp(ThisView+".overl_gebplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_gebplaats","Field","Updatable",.T.)

DBSetProp(ThisView+".nsterfdag","Field","DataType","I")
DBSetProp(ThisView+".nsterfdag","Field","UpdateName","db_kerkhof!toverledenen.nsterfdag")
DBSetProp(ThisView+".nsterfdag","Field","KeyField",.F.)
DBSetProp(ThisView+".nsterfdag","Field","Updatable",.T.)

DBSetProp(ThisView+".nsterfmnd","Field","DataType","I")
DBSetProp(ThisView+".nsterfmnd","Field","UpdateName","db_kerkhof!toverledenen.nsterfmnd")
DBSetProp(ThisView+".nsterfmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".nsterfmnd","Field","Updatable",.T.)

DBSetProp(ThisView+".nsterfjr","Field","DataType","I")
DBSetProp(ThisView+".nsterfjr","Field","UpdateName","db_kerkhof!toverledenen.nsterfjr")
DBSetProp(ThisView+".nsterfjr","Field","KeyField",.F.)
DBSetProp(ThisView+".nsterfjr","Field","Updatable",.T.)

DBSetProp(ThisView+".sterfdat","Field","DataType","C(12)")
DBSetProp(ThisView+".sterfdat","Field","KeyField",.F.)
DBSetProp(ThisView+".sterfdat","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_sterfplaats","Field","DataType","C(35)")
DBSetProp(ThisView+".overl_sterfplaats","Field","UpdateName","db_kerkhof!toverledenen.csterfplts")
DBSetProp(ThisView+".overl_sterfplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_sterfplaats","Field","Updatable",.T.)

DBSetProp(ThisView+".nbegrdag","Field","DataType","I")
DBSetProp(ThisView+".nbegrdag","Field","UpdateName","db_kerkhof!toverledenen.nbegrdag")
DBSetProp(ThisView+".nbegrdag","Field","KeyField",.F.)
DBSetProp(ThisView+".nbegrdag","Field","Updatable",.T.)

DBSetProp(ThisView+".nbegrmnd","Field","DataType","I")
DBSetProp(ThisView+".nbegrmnd","Field","UpdateName","db_kerkhof!toverledenen.nbegrmnd")
DBSetProp(ThisView+".nbegrmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".nbegrmnd","Field","Updatable",.T.)

DBSetProp(ThisView+".nbegrjr","Field","DataType","I")
DBSetProp(ThisView+".nbegrjr","Field","UpdateName","db_kerkhof!toverledenen.nbegrjr")
DBSetProp(ThisView+".nbegrjr","Field","KeyField",.F.)
DBSetProp(ThisView+".nbegrjr","Field","Updatable",.T.)

DBSetProp(ThisView+".begraafdat","Field","DataType","C(12)")
DBSetProp(ThisView+".begraafdat","Field","KeyField",.F.)
DBSetProp(ThisView+".begraafdat","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_begrsrt","Field","DataType","I")
DBSetProp(ThisView+".overl_begrsrt","Field","UpdateName","db_kerkhof!toverledenen.nbegrsrt")
DBSetProp(ThisView+".overl_begrsrt","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_begrsrt","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_opmerking","Field","DataType","C(254)")
DBSetProp(ThisView+".overl_opmerking","Field","UpdateName","db_kerkhof!toverledenen.copmerk")
DBSetProp(ThisView+".overl_opmerking","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_opmerking","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_adres","Field","DataType","C(40)")
DBSetProp(ThisView+".overl_adres","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_adres","Field","Updatable",.F.)

DBSetProp(ThisView+".overl_pcdplaats","Field","DataType","C(40)")
DBSetProp(ThisView+".overl_pcdplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_pcdplaats","Field","Updatable",.F.)

DBSetProp(ThisView+".nsoort","Field","DataType","I")
DBSetProp(ThisView+".nsoort","Field","UpdateName","db_kerkhof!toverledenen.nsoort")
DBSetProp(ThisView+".nsoort","Field","KeyField",.F.)
DBSetProp(ThisView+".nsoort","Field","Updatable",.T.)

DBSetProp(ThisView+".overl_status","Field","DataType","I")
DBSetProp(ThisView+".overl_status","Field","UpdateName","db_kerkhof!toverledenen.nstatus")
DBSetProp(ThisView+".overl_status","Field","KeyField",.F.)
DBSetProp(ThisView+".overl_status","Field","Updatable",.F.)

DBSetProp(ThisView+".ngraf_id","Field","DataType","I")
DBSetProp(ThisView+".ngraf_id","Field","KeyField",.F.)
DBSetProp(ThisView+".ngraf_id","Field","Updatable",.F.)

DBSetProp(ThisView+".cvak","Field","DataType","C(9)")
DBSetProp(ThisView+".cvak","Field","KeyField",.F.)
DBSetProp(ThisView+".cvak","Field","Updatable",.F.)

DBSetProp(ThisView+".crij","Field","DataType","C(9)")
DBSetProp(ThisView+".crij","Field","KeyField",.F.)
DBSetProp(ThisView+".crij","Field","Updatable",.F.)

DBSetProp(ThisView+".cnummer","Field","DataType","C(9)")
DBSetProp(ThisView+".cnummer","Field","KeyField",.F.)
DBSetProp(ThisView+".cnummer","Field","Updatable",.F.)

DBSetProp(ThisView+".nlaag","Field","DataType","I")
DBSetProp(ThisView+".nlaag","Field","KeyField",.F.)
DBSetProp(ThisView+".nlaag","Field","Updatable",.F.)

DBSetProp(ThisView+".lokatie","Field","DataType","C(12)")
DBSetProp(ThisView+".lokatie","Field","KeyField",.F.)
DBSetProp(ThisView+".lokatie","Field","Updatable",.F.)

DBSetProp(ThisView+".graf_opmerking","Field","DataType","C(254)")
DBSetProp(ThisView+".graf_opmerking","Field","KeyField",.F.)
DBSetProp(ThisView+".graf_opmerking","Field","Updatable",.F.)

DBSetProp(ThisView+".dgrechttot","Field","DataType","D")
DBSetProp(ThisView+".dgrechttot","Field","KeyField",.F.)
DBSetProp(ThisView+".dgrechttot","Field","Updatable",.F.)

DBSetProp(ThisView+".graf_status","Field","DataType","I")
DBSetProp(ThisView+".graf_status","Field","KeyField",.F.)
DBSetProp(ThisView+".graf_status","Field","Updatable",.F.)

DBSetProp(ThisView+".id","Field","DataType","I")
DBSetProp(ThisView+".id","Field","KeyField",.F.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)

DBSetProp(ThisView+".nstatus","Field","DataType","I")
DBSetProp(ThisView+".nstatus","Field","KeyField",.F.)
DBSetProp(ThisView+".nstatus","Field","Updatable",.F.)

DBSetProp(ThisView+".fincontact","Field","DataType","L")
DBSetProp(ThisView+".fincontact","Field","KeyField",.F.)
DBSetProp(ThisView+".fincontact","Field","Updatable",.F.)

DBSetProp(ThisView+".ncont_id","Field","DataType","I")
DBSetProp(ThisView+".ncont_id","Field","KeyField",.F.)
DBSetProp(ThisView+".ncont_id","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_bsn","Field","DataType","C(10)")
DBSetProp(ThisView+".contact_bsn","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_bsn","Field","Updatable",.F.)

DBSetProp(ThisView+".caanhef","Field","DataType","C(16)")
DBSetProp(ThisView+".caanhef","Field","KeyField",.F.)
DBSetProp(ThisView+".caanhef","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_naam","Field","DataType","C(40)")
DBSetProp(ThisView+".contact_naam","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_naam","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_adres","Field","DataType","C(40)")
DBSetProp(ThisView+".contact_adres","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_adres","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_pcdplaats","Field","DataType","C(40)")
DBSetProp(ThisView+".contact_pcdplaats","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_pcdplaats","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_netnum","Field","DataType","C(5)")
DBSetProp(ThisView+".contact_netnum","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_netnum","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_telefoon","Field","DataType","C(27)")
DBSetProp(ThisView+".contact_telefoon","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_telefoon","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_email","Field","DataType","C(46)")
DBSetProp(ThisView+".contact_email","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_email","Field","Updatable",.F.)

DBSetProp(ThisView+".crekening","Field","DataType","C(10)")
DBSetProp(ThisView+".crekening","Field","KeyField",.F.)
DBSetProp(ThisView+".crekening","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_opmerking","Field","DataType","C(254)")
DBSetProp(ThisView+".contact_opmerking","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_opmerking","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_gsm","Field","DataType","C(12)")
DBSetProp(ThisView+".contact_gsm","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_gsm","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_status","Field","DataType","I")
DBSetProp(ThisView+".contact_status","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_status","Field","Updatable",.F.)

DBSetProp(ThisView+".copmerk","Field","DataType","C(254)")
DBSetProp(ThisView+".copmerk","Field","KeyField",.F.)
DBSetProp(ThisView+".copmerk","Field","Updatable",.F.)

DBSetProp(ThisView+".contact_geslacht","Field","DataType","C(1)")
DBSetProp(ThisView+".contact_geslacht","Field","KeyField",.F.)
DBSetProp(ThisView+".contact_geslacht","Field","Updatable",.F.)

DBSetProp(ThisView+".csoort","Field","DataType","C(20)")
DBSetProp(ThisView+".csoort","Field","KeyField",.F.)
DBSetProp(ThisView+".csoort","Field","Updatable",.F.)

DBSetProp(ThisView+".nruimdag","Field","DataType","I")
DBSetProp(ThisView+".nruimdag","Field","KeyField",.F.)
DBSetProp(ThisView+".nruimdag","Field","Updatable",.F.)

DBSetProp(ThisView+".nruimmnd","Field","DataType","I")
DBSetProp(ThisView+".nruimmnd","Field","KeyField",.F.)
DBSetProp(ThisView+".nruimmnd","Field","Updatable",.F.)

DBSetProp(ThisView+".nruimjr","Field","DataType","I")
DBSetProp(ThisView+".nruimjr","Field","KeyField",.F.)
DBSetProp(ThisView+".nruimjr","Field","Updatable",.F.)

DBSetProp(ThisView+".ruimdat","Field","DataType","C(12)")
DBSetProp(ThisView+".ruimdat","Field","KeyField",.F.)
DBSetProp(ThisView+".ruimdat","Field","Updatable",.F.)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

view defenition has changed, how to solve? 1

Nifrabar

Programmer

JRB-Bldr

Programmer

Nifrabar

Programmer

Olaf Doschke

Programmer

Nifrabar

Programmer

Mike Lewis

Programmer

Nifrabar

Programmer

Similar threads

Part and Inventory Search

Sponsor