Weird problem - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Weird problem

Message

16/03/2006 16:27:13

Geoff Scott
Christchurch, Nouvelle Zélande

16/03/2006 00:59:52

Janis Booth
Webmd
Prospect, Connecticut, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Weird problem

Divers

Thread ID:

01104771

Message ID:

01105082

Vues:

Hi Jim

Thanks for the reply.

I have put the view definition at the end. The code is fairly simple. First I set up the record.

SELECT v_schedules
SCATTER FIELDS i_key, t_key, schedule, wo_id, our_ref, wotype, c_key, u_key, prsched, contcode, contname,;
					status, contstatus, createdt, lastaction ;
			NAME oSchedule BLANK MEMO
WITH oSchedule
	.i_key = IIF(this.lOldWots, NEWID_O('INVCONT'),  NEWID_R('INVCONT'))
	.t_Key = v_Contsub.t_key
	.schedule = 1
	.wo_id = v_woheads.wo_id
	.our_ref = v_woheads.our_ref
	.wotype = v_woheads.type
	.c_key = v_woheads.c_key
	.u_key = v_woheads.u_key
	.prsched = v_Contsub.prsched
	.contcode = v_Contsub.contractor
	.contname = v_Contsub.name
	.status = [U]
	.contstatus = [U]
	.createdt = m.dt_Now
	.lastaction = m.dt_Now
ENDWITH
INSERT INTO v_schedules FROM NAME oSchedule

I could just do this in a single insert statement but it works fine the data is in my view cursor. I should point out at this stage that v_schedules is a remote view that has optimistic buffering and is empty prior to the insertion.

there is a little other processing and then I was issuing a

REPLACE wotype WITH m.cType IN v_schedules ALL

Before this statement everything is fine. After it my record is blank or not there.
Ah ha, me thinks knowingly, I shall use SCAN and just do one record at a time. Alas

SELECT v_schedules
SCAN
	REPLACE wotype WITH m.cType IN v_schedules
ENDSCAN

has the same result as before but the interesting thing here is that the record is cleared not by the REPLACE statement but by the SCAN.

There is no error message (i.e. MESSAGE() does not change) just wammo data gone.

Because the table has buffering there is no issue with underlying keys because nothing is written to the underlying till I issue a TABLEUPDATE.

The other major question is why does it only happen the second time I use the v_schedules (i.e. after a TABLEUPDATE operation has been issued and a REQUERY to empty it of records.)

I am at a total loss as to why this is happening or why it has just started happening. The program was running fine until yesterday.

Regards
Geoff Scott

CREATE SQL VIEW V_SCHEDULES REMOTE CONNECTION rWots AS ;
SELECT Invcont.i_key, ;
		Invcont.wo_id, ;
		Invcont.our_ref, ;
		Invcont.schedule, ;
		Invcont.t_key, ;
		Invcont.contcode, ;
		Invcont.modno, ;
		Invcont.stage, ;
		Invcont.contname, ;
		Invcont.tt_key, ;
		Invcont.lastaction, ;
		Invcont.c_key, ;
		Invcont.u_key, ;
		Invcont.status, ;
		Invcont.contstatus, ;
		Invcont.wotype, ;
		Invcont.conttype, ;
		Invcont.estimate, ;
		Invcont.prsched, ;
		Invcont.continvno, ;
		Invcont.custinvno, ;
		Invcont.invno, ;
		Invcont.vacant, ;
		Invcont.ex_ref, ;
		Invcont.o_key, ;
		Invcont.jobcost, ;
		Invcont.gl, ;
		Invcont.notes, ;
		Invcont.contrep, ;
		Invcont.updflag, ;
		Invcont.cont_sdesc, ;
		Invcont.cust_sdesc, ;
		Invcont.createdt, ;
		Invcont.activated, ;
		Invcont.completed, ;
		Invcont.invdate, ;
		Invcont.paidref, ;
		Invcont.paiddate, ;
		Invcont.contpaid, ;
		Invcont.custpaid, ;
		Invcont.dt_response, ;
		Invcont.dt_t_st, ;
		Invcont.dt_t_w1, ;
		Invcont.dt_t_resp, ;
		Invcont.dt_t_rest, ;
		Invcont.dt_t_w2, ;
		Invcont.dt_t_comp, ;
		Invcont.dt_t_w3, ;
		Invcont.dt_t_inv, ;
		Invcont.mn_resp, ;
		Invcont.ms_resp, ;
		Invcont.mn_comp, ;
		Invcont.ms_comp, ;
		Invcont.mn_inv, ;
		Invcont.ms_inv, ;
		Invcont.kpi, ;
		Invcont.kt_resp_ex, ;
		Invcont.kt_comp_ex, ;
		Invcont.kt_inv_ex, ;
		Invcont.kt_outlyer, ;
		Invcont.kt_target, ;
		Invcont.dt_a, ;
		Invcont.dt_b, ;
		Invcont.dt_c, ;
		Invcont.dt_d, ;
		Invcont.dt_e, ;
		Invcont.dt_f, ;
		Invcont.dt_g, ;
		Invcont.dt_h, ;
		Invcont.dt_i, ;
		Invcont.dt_j, ;
		Invcont.dt_k, ;
		Invcont.dt_l, ;
		Invcont.dt_m, ;
		Invcont.dt_n, ;
		Invcont.dt_o, ;
		Invcont.dt_p, ;
		Invcont.dt_q, ;
		Invcont.dt_r, ;
		Invcont.dt_s, ;
		Invcont.dt_t, ;
		Invcont.dt_u, ;
		Invcont.dt_v, ;
		Invcont.dt_w, ;
		Invcont.dt_x, ;
		Invcont.dt_y, ;
		Invcont.dt_z, ;
		Invcont.dt_0, ;
		Invcont.dt_1, ;
		Invcont.dt_2, ;
		Invcont.dt_3, ;
		Invcont.dt_4, ;
		Invcont.dt_5, ;
		Invcont.dt_6, ;
		Invcont.dt_7, ;
		Invcont.dt_8, ;
		Invcont.dt_9, ;
		Invcont.dt_cust_c, ;
		Invcont.dt_cust_f, ;
		Invcont.dt_cust_g, ;
		Invcont.dt_cust_h, ;
		Invcont.dt_cust_j, ;
		Invcont.dt_cust_m, ;
		Invcont.dt_cust_n, ;
		Invcont.dt_cust_o, ;
		Invcont.dt_cust_p, ;
		Invcont.dt_cust_s, ;
		Invcont.dt_cust_w, ;
		Invcont.dt_cust_x, ;
		Invcont.dt_cust_z, ;
		Invcont.dt_t_so, ;
		Invcont.dt_c_so, ;
		Invcont.items, ;
		Invcont.t_invtot_q, ;
		Invcont.t_invtot_f, ;
		Invcont.c_invtot_q, ;
		Invcont.c_invtot_f ;
	FROM invcont Invcont ;
	WHERE Invcont.wo_id = ( ?lnWo_id )


* View Properties
DBSetProp("V_SCHEDULES", 'View', 'UpdateType',1)
DBSetProp("V_SCHEDULES", 'View', 'WhereType',3)
DBSetProp("V_SCHEDULES", 'View', 'FetchMemo',.T.)
DBSetProp("V_SCHEDULES", 'View', 'SendUpdates',.T.)
DBSetProp("V_SCHEDULES", 'View', 'UseMemoSize',255)
DBSetProp("V_SCHEDULES", 'View', 'FetchSize',100)
DBSetProp("V_SCHEDULES", 'View', 'MaxRecords',-1)
DBSetProp("V_SCHEDULES", 'View', 'Tables',[invcont])
DBSetProp("V_SCHEDULES", 'View', 'Comment',[])
DBSetProp("V_SCHEDULES", 'View', 'BatchUpdateCount',1)
DBSetProp("V_SCHEDULES", 'View', 'ShareConnection',.T.)
DBSetProp("V_SCHEDULES", 'View', 'Prepared',.F.)
DBSetProp("V_SCHEDULES", 'View', 'CompareMemo',.T.)
DBSetProp("V_SCHEDULES", 'View', 'FetchAsNeeded',.F.)
DBSetProp("V_SCHEDULES", 'View', 'RuleExpression',[])
DBSetProp("V_SCHEDULES", 'View', 'RuleText',[])
DBSetProp("V_SCHEDULES", 'View', 'ParameterList',[])

* View Field Properties
DBSetProp("V_SCHEDULES.I_KEY",'Field','KeyField',.T.)
DBSetProp("V_SCHEDULES.I_KEY",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.I_KEY",'Field','UpdateName',[invcont.i_key])
DBSetProp("V_SCHEDULES.I_KEY",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.I_KEY",'Field','Caption',[])
DBSetProp("V_SCHEDULES.I_KEY",'Field','DefaultValue',[NEWID_R("INVCONT")])
DBSetProp("V_SCHEDULES.I_KEY",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.I_KEY",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.WO_ID",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.WO_ID",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.WO_ID",'Field','UpdateName',[invcont.wo_id])
DBSetProp("V_SCHEDULES.WO_ID",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.WO_ID",'Field','Caption',[])
DBSetProp("V_SCHEDULES.WO_ID",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.WO_ID",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.WO_ID",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.OUR_REF",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.OUR_REF",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.OUR_REF",'Field','UpdateName',[invcont.our_ref])
DBSetProp("V_SCHEDULES.OUR_REF",'Field','DataType',[C(10)])
DBSetProp("V_SCHEDULES.OUR_REF",'Field','Caption',[])
DBSetProp("V_SCHEDULES.OUR_REF",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.OUR_REF",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.OUR_REF",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','UpdateName',[invcont.schedule])
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','DataType',[N(2)])
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','DefaultValue',[1])
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.SCHEDULE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.T_KEY",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.T_KEY",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.T_KEY",'Field','UpdateName',[invcont.t_key])
DBSetProp("V_SCHEDULES.T_KEY",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.T_KEY",'Field','Caption',[])
DBSetProp("V_SCHEDULES.T_KEY",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.T_KEY",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.T_KEY",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONTCODE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONTCODE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONTCODE",'Field','UpdateName',[invcont.contcode])
DBSetProp("V_SCHEDULES.CONTCODE",'Field','DataType',[C(10)])
DBSetProp("V_SCHEDULES.CONTCODE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONTCODE",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.CONTCODE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONTCODE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.MODNO",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.MODNO",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.MODNO",'Field','UpdateName',[invcont.modno])
DBSetProp("V_SCHEDULES.MODNO",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.MODNO",'Field','Caption',[])
DBSetProp("V_SCHEDULES.MODNO",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.MODNO",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.MODNO",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.STAGE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.STAGE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.STAGE",'Field','UpdateName',[invcont.stage])
DBSetProp("V_SCHEDULES.STAGE",'Field','DataType',[N(2)])
DBSetProp("V_SCHEDULES.STAGE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.STAGE",'Field','DefaultValue',[1])
DBSetProp("V_SCHEDULES.STAGE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.STAGE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONTNAME",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONTNAME",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONTNAME",'Field','UpdateName',[invcont.contname])
DBSetProp("V_SCHEDULES.CONTNAME",'Field','DataType',[C(30)])
DBSetProp("V_SCHEDULES.CONTNAME",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONTNAME",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.CONTNAME",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONTNAME",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.TT_KEY",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.TT_KEY",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.TT_KEY",'Field','UpdateName',[invcont.tt_key])
DBSetProp("V_SCHEDULES.TT_KEY",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.TT_KEY",'Field','Caption',[])
DBSetProp("V_SCHEDULES.TT_KEY",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.TT_KEY",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.TT_KEY",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.LASTACTION",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.LASTACTION",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.LASTACTION",'Field','UpdateName',[invcont.lastaction])
DBSetProp("V_SCHEDULES.LASTACTION",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.LASTACTION",'Field','Caption',[])
DBSetProp("V_SCHEDULES.LASTACTION",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.LASTACTION",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.LASTACTION",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.C_KEY",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.C_KEY",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.C_KEY",'Field','UpdateName',[invcont.c_key])
DBSetProp("V_SCHEDULES.C_KEY",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.C_KEY",'Field','Caption',[])
DBSetProp("V_SCHEDULES.C_KEY",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.C_KEY",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.C_KEY",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.U_KEY",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.U_KEY",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.U_KEY",'Field','UpdateName',[invcont.u_key])
DBSetProp("V_SCHEDULES.U_KEY",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.U_KEY",'Field','Caption',[])
DBSetProp("V_SCHEDULES.U_KEY",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.U_KEY",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.U_KEY",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.STATUS",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.STATUS",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.STATUS",'Field','UpdateName',[invcont.status])
DBSetProp("V_SCHEDULES.STATUS",'Field','DataType',[C(1)])
DBSetProp("V_SCHEDULES.STATUS",'Field','Caption',[])
DBSetProp("V_SCHEDULES.STATUS",'Field','DefaultValue',[" "])
DBSetProp("V_SCHEDULES.STATUS",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.STATUS",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','UpdateName',[invcont.contstatus])
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','DataType',[C(1)])
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','DefaultValue',[" "])
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONTSTATUS",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.WOTYPE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.WOTYPE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.WOTYPE",'Field','UpdateName',[invcont.wotype])
DBSetProp("V_SCHEDULES.WOTYPE",'Field','DataType',[C(1)])
DBSetProp("V_SCHEDULES.WOTYPE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.WOTYPE",'Field','DefaultValue',[" "])
DBSetProp("V_SCHEDULES.WOTYPE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.WOTYPE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','UpdateName',[invcont.conttype])
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONTTYPE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','UpdateName',[invcont.estimate])
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.ESTIMATE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.PRSCHED",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.PRSCHED",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.PRSCHED",'Field','UpdateName',[invcont.prsched])
DBSetProp("V_SCHEDULES.PRSCHED",'Field','DataType',[C(4)])
DBSetProp("V_SCHEDULES.PRSCHED",'Field','Caption',[])
DBSetProp("V_SCHEDULES.PRSCHED",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.PRSCHED",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.PRSCHED",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','UpdateName',[invcont.continvno])
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONTINVNO",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','UpdateName',[invcont.custinvno])
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CUSTINVNO",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.INVNO",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.INVNO",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.INVNO",'Field','UpdateName',[invcont.invno])
DBSetProp("V_SCHEDULES.INVNO",'Field','DataType',[N(10)])
DBSetProp("V_SCHEDULES.INVNO",'Field','Caption',[])
DBSetProp("V_SCHEDULES.INVNO",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.INVNO",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.INVNO",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.VACANT",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.VACANT",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.VACANT",'Field','UpdateName',[invcont.vacant])
DBSetProp("V_SCHEDULES.VACANT",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.VACANT",'Field','Caption',[])
DBSetProp("V_SCHEDULES.VACANT",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.VACANT",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.VACANT",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.EX_REF",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.EX_REF",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.EX_REF",'Field','UpdateName',[invcont.ex_ref])
DBSetProp("V_SCHEDULES.EX_REF",'Field','DataType',[C(10)])
DBSetProp("V_SCHEDULES.EX_REF",'Field','Caption',[])
DBSetProp("V_SCHEDULES.EX_REF",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.EX_REF",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.EX_REF",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.O_KEY",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.O_KEY",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.O_KEY",'Field','UpdateName',[invcont.o_key])
DBSetProp("V_SCHEDULES.O_KEY",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.O_KEY",'Field','Caption',[])
DBSetProp("V_SCHEDULES.O_KEY",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.O_KEY",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.O_KEY",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.JOBCOST",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.JOBCOST",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.JOBCOST",'Field','UpdateName',[invcont.jobcost])
DBSetProp("V_SCHEDULES.JOBCOST",'Field','DataType',[C(10)])
DBSetProp("V_SCHEDULES.JOBCOST",'Field','Caption',[])
DBSetProp("V_SCHEDULES.JOBCOST",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.JOBCOST",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.JOBCOST",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.GL",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.GL",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.GL",'Field','UpdateName',[invcont.gl])
DBSetProp("V_SCHEDULES.GL",'Field','DataType',[C(30)])
DBSetProp("V_SCHEDULES.GL",'Field','Caption',[])
DBSetProp("V_SCHEDULES.GL",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.GL",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.GL",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.NOTES",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.NOTES",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.NOTES",'Field','UpdateName',[invcont.notes])
DBSetProp("V_SCHEDULES.NOTES",'Field','DataType',[M])
DBSetProp("V_SCHEDULES.NOTES",'Field','Caption',[])
DBSetProp("V_SCHEDULES.NOTES",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.NOTES",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.NOTES",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONTREP",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONTREP",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONTREP",'Field','UpdateName',[invcont.contrep])
DBSetProp("V_SCHEDULES.CONTREP",'Field','DataType',[L])
DBSetProp("V_SCHEDULES.CONTREP",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONTREP",'Field','DefaultValue',[.F.])
DBSetProp("V_SCHEDULES.CONTREP",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONTREP",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','UpdateName',[invcont.updflag])
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','DataType',[C(1)])
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','Caption',[])
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','DefaultValue',[" "])
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.UPDFLAG",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','UpdateName',[invcont.cont_sdesc])
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','DataType',[C(30)])
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONT_SDESC",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','UpdateName',[invcont.cust_sdesc])
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','DataType',[C(30)])
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CUST_SDESC",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CREATEDT",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CREATEDT",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CREATEDT",'Field','UpdateName',[invcont.createdt])
DBSetProp("V_SCHEDULES.CREATEDT",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.CREATEDT",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CREATEDT",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.CREATEDT",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CREATEDT",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','UpdateName',[invcont.activated])
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','Caption',[])
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.ACTIVATED",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.COMPLETED",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.COMPLETED",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.COMPLETED",'Field','UpdateName',[invcont.completed])
DBSetProp("V_SCHEDULES.COMPLETED",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.COMPLETED",'Field','Caption',[])
DBSetProp("V_SCHEDULES.COMPLETED",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.COMPLETED",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.COMPLETED",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.INVDATE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.INVDATE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.INVDATE",'Field','UpdateName',[invcont.invdate])
DBSetProp("V_SCHEDULES.INVDATE",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.INVDATE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.INVDATE",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.INVDATE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.INVDATE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.PAIDREF",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.PAIDREF",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.PAIDREF",'Field','UpdateName',[invcont.paidref])
DBSetProp("V_SCHEDULES.PAIDREF",'Field','DataType',[C(10)])
DBSetProp("V_SCHEDULES.PAIDREF",'Field','Caption',[])
DBSetProp("V_SCHEDULES.PAIDREF",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.PAIDREF",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.PAIDREF",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','UpdateName',[invcont.paiddate])
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','DataType',[D])
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.PAIDDATE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CONTPAID",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CONTPAID",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CONTPAID",'Field','UpdateName',[invcont.contpaid])
DBSetProp("V_SCHEDULES.CONTPAID",'Field','DataType',[L])
DBSetProp("V_SCHEDULES.CONTPAID",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CONTPAID",'Field','DefaultValue',[.F.])
DBSetProp("V_SCHEDULES.CONTPAID",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CONTPAID",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','UpdateName',[invcont.custpaid])
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','DataType',[L])
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','Caption',[])
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','DefaultValue',[.F.])
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.CUSTPAID",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','UpdateName',[invcont.dt_response])
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_RESPONSE",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','UpdateName',[invcont.dt_t_st])
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_ST",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','UpdateName',[invcont.dt_t_w1])
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_W1",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','UpdateName',[invcont.dt_t_resp])
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_RESP",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','UpdateName',[invcont.dt_t_rest])
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_REST",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','UpdateName',[invcont.dt_t_w2])
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_W2",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','UpdateName',[invcont.dt_t_comp])
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_COMP",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','UpdateName',[invcont.dt_t_w3])
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_W3",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','UpdateName',[invcont.dt_t_inv])
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_INV",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.MN_RESP",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.MN_RESP",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.MN_RESP",'Field','UpdateName',[invcont.mn_resp])
DBSetProp("V_SCHEDULES.MN_RESP",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.MN_RESP",'Field','Caption',[])
DBSetProp("V_SCHEDULES.MN_RESP",'Field','DefaultValue',[])
DBSetProp("V_SCHEDULES.MN_RESP",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.MN_RESP",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.MS_RESP",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.MS_RESP",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.MS_RESP",'Field','UpdateName',[invcont.ms_resp])
DBSetProp("V_SCHEDULES.MS_RESP",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.MS_RESP",'Field','Caption',[])
DBSetProp("V_SCHEDULES.MS_RESP",'Field','DefaultValue',[])
DBSetProp("V_SCHEDULES.MS_RESP",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.MS_RESP",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.MN_COMP",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.MN_COMP",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.MN_COMP",'Field','UpdateName',[invcont.mn_comp])
DBSetProp("V_SCHEDULES.MN_COMP",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.MN_COMP",'Field','Caption',[])
DBSetProp("V_SCHEDULES.MN_COMP",'Field','DefaultValue',[])
DBSetProp("V_SCHEDULES.MN_COMP",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.MN_COMP",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.MS_COMP",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.MS_COMP",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.MS_COMP",'Field','UpdateName',[invcont.ms_comp])
DBSetProp("V_SCHEDULES.MS_COMP",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.MS_COMP",'Field','Caption',[])
DBSetProp("V_SCHEDULES.MS_COMP",'Field','DefaultValue',[])
DBSetProp("V_SCHEDULES.MS_COMP",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.MS_COMP",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.MN_INV",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.MN_INV",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.MN_INV",'Field','UpdateName',[invcont.mn_inv])
DBSetProp("V_SCHEDULES.MN_INV",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.MN_INV",'Field','Caption',[])
DBSetProp("V_SCHEDULES.MN_INV",'Field','DefaultValue',[])
DBSetProp("V_SCHEDULES.MN_INV",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.MN_INV",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.MS_INV",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.MS_INV",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.MS_INV",'Field','UpdateName',[invcont.ms_inv])
DBSetProp("V_SCHEDULES.MS_INV",'Field','DataType',[I])
DBSetProp("V_SCHEDULES.MS_INV",'Field','Caption',[])
DBSetProp("V_SCHEDULES.MS_INV",'Field','DefaultValue',[])
DBSetProp("V_SCHEDULES.MS_INV",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.MS_INV",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.KPI",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.KPI",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.KPI",'Field','UpdateName',[invcont.kpi])
DBSetProp("V_SCHEDULES.KPI",'Field','DataType',[C(10)])
DBSetProp("V_SCHEDULES.KPI",'Field','Caption',[])
DBSetProp("V_SCHEDULES.KPI",'Field','DefaultValue',[""])
DBSetProp("V_SCHEDULES.KPI",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.KPI",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','UpdateName',[invcont.kt_resp_ex])
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','Caption',[])
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','DefaultValue',[1])
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.KT_RESP_EX",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','UpdateName',[invcont.kt_comp_ex])
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','Caption',[])
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','DefaultValue',[1])
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.KT_COMP_EX",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','UpdateName',[invcont.kt_inv_ex])
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','Caption',[])
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','DefaultValue',[1])
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.KT_INV_EX",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','UpdateName',[invcont.kt_outlyer])
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','Caption',[])
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.KT_OUTLYER",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','UpdateName',[invcont.kt_target])
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','DataType',[N(1)])
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','Caption',[])
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.KT_TARGET",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_A",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_A",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_A",'Field','UpdateName',[invcont.dt_a])
DBSetProp("V_SCHEDULES.DT_A",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_A",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_A",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_A",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_A",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_B",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_B",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_B",'Field','UpdateName',[invcont.dt_b])
DBSetProp("V_SCHEDULES.DT_B",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_B",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_B",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_B",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_B",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_C",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_C",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_C",'Field','UpdateName',[invcont.dt_c])
DBSetProp("V_SCHEDULES.DT_C",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_C",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_C",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_C",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_C",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_D",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_D",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_D",'Field','UpdateName',[invcont.dt_d])
DBSetProp("V_SCHEDULES.DT_D",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_D",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_D",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_D",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_D",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_E",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_E",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_E",'Field','UpdateName',[invcont.dt_e])
DBSetProp("V_SCHEDULES.DT_E",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_E",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_E",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_E",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_E",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_F",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_F",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_F",'Field','UpdateName',[invcont.dt_f])
DBSetProp("V_SCHEDULES.DT_F",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_F",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_F",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_F",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_F",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_G",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_G",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_G",'Field','UpdateName',[invcont.dt_g])
DBSetProp("V_SCHEDULES.DT_G",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_G",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_G",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_G",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_G",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_H",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_H",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_H",'Field','UpdateName',[invcont.dt_h])
DBSetProp("V_SCHEDULES.DT_H",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_H",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_H",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_H",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_H",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_I",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_I",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_I",'Field','UpdateName',[invcont.dt_i])
DBSetProp("V_SCHEDULES.DT_I",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_I",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_I",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_I",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_I",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_J",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_J",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_J",'Field','UpdateName',[invcont.dt_j])
DBSetProp("V_SCHEDULES.DT_J",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_J",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_J",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_J",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_J",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_K",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_K",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_K",'Field','UpdateName',[invcont.dt_k])
DBSetProp("V_SCHEDULES.DT_K",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_K",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_K",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_K",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_K",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_L",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_L",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_L",'Field','UpdateName',[invcont.dt_l])
DBSetProp("V_SCHEDULES.DT_L",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_L",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_L",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_L",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_L",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_M",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_M",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_M",'Field','UpdateName',[invcont.dt_m])
DBSetProp("V_SCHEDULES.DT_M",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_M",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_M",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_M",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_M",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_N",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_N",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_N",'Field','UpdateName',[invcont.dt_n])
DBSetProp("V_SCHEDULES.DT_N",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_N",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_N",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_N",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_N",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_O",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_O",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_O",'Field','UpdateName',[invcont.dt_o])
DBSetProp("V_SCHEDULES.DT_O",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_O",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_O",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_O",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_O",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_P",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_P",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_P",'Field','UpdateName',[invcont.dt_p])
DBSetProp("V_SCHEDULES.DT_P",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_P",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_P",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_P",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_P",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_Q",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_Q",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_Q",'Field','UpdateName',[invcont.dt_q])
DBSetProp("V_SCHEDULES.DT_Q",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_Q",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_Q",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_Q",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_Q",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_R",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_R",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_R",'Field','UpdateName',[invcont.dt_r])
DBSetProp("V_SCHEDULES.DT_R",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_R",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_R",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_R",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_R",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_S",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_S",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_S",'Field','UpdateName',[invcont.dt_s])
DBSetProp("V_SCHEDULES.DT_S",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_S",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_S",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_S",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_S",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T",'Field','UpdateName',[invcont.dt_t])
DBSetProp("V_SCHEDULES.DT_T",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_U",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_U",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_U",'Field','UpdateName',[invcont.dt_u])
DBSetProp("V_SCHEDULES.DT_U",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_U",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_U",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_U",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_U",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_V",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_V",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_V",'Field','UpdateName',[invcont.dt_v])
DBSetProp("V_SCHEDULES.DT_V",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_V",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_V",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_V",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_V",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_W",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_W",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_W",'Field','UpdateName',[invcont.dt_w])
DBSetProp("V_SCHEDULES.DT_W",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_W",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_W",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_W",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_W",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_X",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_X",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_X",'Field','UpdateName',[invcont.dt_x])
DBSetProp("V_SCHEDULES.DT_X",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_X",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_X",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_X",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_X",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_Y",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_Y",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_Y",'Field','UpdateName',[invcont.dt_y])
DBSetProp("V_SCHEDULES.DT_Y",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_Y",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_Y",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_Y",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_Y",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_Z",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_Z",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_Z",'Field','UpdateName',[invcont.dt_z])
DBSetProp("V_SCHEDULES.DT_Z",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_Z",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_Z",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_Z",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_Z",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_0",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_0",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_0",'Field','UpdateName',[invcont.dt_0])
DBSetProp("V_SCHEDULES.DT_0",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_0",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_0",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_0",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_0",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_1",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_1",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_1",'Field','UpdateName',[invcont.dt_1])
DBSetProp("V_SCHEDULES.DT_1",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_1",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_1",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_1",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_1",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_2",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_2",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_2",'Field','UpdateName',[invcont.dt_2])
DBSetProp("V_SCHEDULES.DT_2",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_2",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_2",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_2",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_2",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_3",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_3",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_3",'Field','UpdateName',[invcont.dt_3])
DBSetProp("V_SCHEDULES.DT_3",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_3",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_3",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_3",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_3",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_4",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_4",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_4",'Field','UpdateName',[invcont.dt_4])
DBSetProp("V_SCHEDULES.DT_4",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_4",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_4",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_4",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_4",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_5",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_5",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_5",'Field','UpdateName',[invcont.dt_5])
DBSetProp("V_SCHEDULES.DT_5",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_5",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_5",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_5",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_5",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_6",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_6",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_6",'Field','UpdateName',[invcont.dt_6])
DBSetProp("V_SCHEDULES.DT_6",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_6",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_6",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_6",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_6",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_7",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_7",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_7",'Field','UpdateName',[invcont.dt_7])
DBSetProp("V_SCHEDULES.DT_7",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_7",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_7",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_7",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_7",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_8",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_8",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_8",'Field','UpdateName',[invcont.dt_8])
DBSetProp("V_SCHEDULES.DT_8",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_8",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_8",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_8",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_8",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_9",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_9",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_9",'Field','UpdateName',[invcont.dt_9])
DBSetProp("V_SCHEDULES.DT_9",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_9",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_9",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_9",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_9",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','UpdateName',[invcont.dt_cust_c])
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_C",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','UpdateName',[invcont.dt_cust_f])
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_F",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','UpdateName',[invcont.dt_cust_g])
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_G",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','UpdateName',[invcont.dt_cust_h])
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_H",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','UpdateName',[invcont.dt_cust_j])
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_J",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','UpdateName',[invcont.dt_cust_m])
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_M",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','UpdateName',[invcont.dt_cust_n])
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_N",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','UpdateName',[invcont.dt_cust_o])
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_O",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','UpdateName',[invcont.dt_cust_p])
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_P",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','UpdateName',[invcont.dt_cust_s])
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_S",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','UpdateName',[invcont.dt_cust_w])
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_W",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','UpdateName',[invcont.dt_cust_x])
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_X",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','UpdateName',[invcont.dt_cust_z])
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_CUST_Z",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','UpdateName',[invcont.dt_t_so])
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_T_SO",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','UpdateName',[invcont.dt_c_so])
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','DataType',[T])
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','Caption',[])
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','DefaultValue',[.NULL.])
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.DT_C_SO",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.ITEMS",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.ITEMS",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.ITEMS",'Field','UpdateName',[invcont.items])
DBSetProp("V_SCHEDULES.ITEMS",'Field','DataType',[N(3)])
DBSetProp("V_SCHEDULES.ITEMS",'Field','Caption',[])
DBSetProp("V_SCHEDULES.ITEMS",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.ITEMS",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.ITEMS",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','UpdateName',[invcont.t_invtot_q])
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','DataType',[Y])
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','Caption',[])
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.T_INVTOT_Q",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','UpdateName',[invcont.t_invtot_f])
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','DataType',[Y])
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','Caption',[])
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.T_INVTOT_F",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','UpdateName',[invcont.c_invtot_q])
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','DataType',[Y])
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','Caption',[])
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.C_INVTOT_Q",'Field','RuleText',[])
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','KeyField',.F.)
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','Updatable',.T.)
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','UpdateName',[invcont.c_invtot_f])
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','DataType',[Y])
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','Caption',[])
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','DefaultValue',[0])
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','RuleExpression',[])
DBSetProp("V_SCHEDULES.C_INVTOT_F",'Field','RuleText',[])

>Show us more code. It is very difficult to give you an answer when we have no idea what the code is doing.

May all your weeds be wildflowers

Répondre

Fil

Voir

Click here to load this message in the networking platform