Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last Updated User
Message
From
23/02/2005 13:01:46
Naomi Nosonovsky
Wisconsin, United States
 
 
To
23/02/2005 12:15:58
Gregory Adam
Belgium
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Last Updated User
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00988451
Message ID:
00989727
Views:
36
>>Hi Gregory,
>>
>>The code doesn't seem to work if I'm working with a view in table buffered mode.
>
>Hi Nadya,
>
>
>If the table validation rule is [ TheOldOne() and UpdateUserAndDate() ], then it behaves as it has always done.
>
>
>The code is only triggered with the record validation rule, ie where a record is about to be saved with tableupdate/insert
>
>If you update a view, say one row with tableupdate(), pls verify the tables of the view are not buffered at all
>
>Normally, if you use a view, it opens the base tables with buffermode 0 = none.. Verify that

Here is a view definition. I'm updating fields from two separate tables. Could it be a problem?
CREATE SQL VIEW LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES AS ;
SELECT Trans.ccommissioned_owner, ;
		Trans_employees_queues.cqueue_names_fk, ;
		Trans_employees_queues.ccommission_owner_usgrlink_fk, ;
		Trans.ctrans_pk, ;
		Trans_employees_queues.ctrans_employees_queues_pk, ;
		Trans.cproduct_lines_fk, ;
		Trans.cpatients_fk, ;
		Trans.tadmit_date, ;
		Trans.ytotal_charge_amount, ;
		Trans.ycurrent_balance_amount, ;
		Trans.yreferral_balance_amount, ;
		Queue_names.cqueue_name, ;
		Queue_names.cdepartment_code, ;
		Trans_employees_queues.cusgrlink_fk, ;
		Trans_employees_queues.iactive_flag ;
	FROM mmviscollect!trans INNER ;
		JOIN mmviscollect!trans_employees_queues ;
				ON Trans.ctrans_pk = Trans_employees_queues.ctrans_fk INNER ;
		JOIN mmviscollect!queue_names ;
				ON Queue_names.cqueue_names_pk = Trans_employees_queues.cqueue_names_fk ;
	WHERE ( ( Trans_employees_queues.iactive_flag = ( 1 ) ;
		AND Queue_names.cdepartment_code = ( ?vp_cDepartment_code ) ) ;
		AND Queue_names.cqueue_name = ( ?vp_cQueue_Name_Orig ) ) ;
		AND Trans_employees_queues.ccommission_owner_usgrlink_fk == ( "" )


* View Properties
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'UpdateType',1)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'WhereType',3)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'FetchMemo',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'SendUpdates',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'UseMemoSize',255)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'FetchSize',100)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'MaxRecords',-1)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'Tables',[mmviscollect!trans,mmviscollect!trans_employees_queues])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'Comment',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'BatchUpdateCount',1)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'ShareConnection',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'Prepared',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'CompareMemo',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'FetchAsNeeded',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES", 'View', 'ParameterList',[vp_cDepartment_Code,'C';vp_cQueue_Name_Orig,'C'])

* View Field Properties
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','Updatable',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','UpdateName',[mmviscollect!trans.ccommissioned_owner])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','DataType',[C(10)])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSIONED_OWNER",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','Updatable',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','UpdateName',[mmviscollect!trans_employees_queues.cqueue_names_fk])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','DataType',[C(16) NOCPTRANS])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','Updatable',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','UpdateName',[mmviscollect!trans_employees_queues.ccommission_owner_usgrlink_fk])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','DataType',[C(16) NOCPTRANS])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','KeyField',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','UpdateName',[mmviscollect!trans.ctrans_pk])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','DataType',[C(16) NOCPTRANS])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_PK",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','KeyField',.T.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','UpdateName',[mmviscollect!trans_employees_queues.ctrans_employees_queues_pk])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','DataType',[C(16) NOCPTRANS])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','UpdateName',[mmviscollect!trans.cproduct_lines_fk])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','DataType',[C(16) NOCPTRANS])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPRODUCT_LINES_FK",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','UpdateName',[mmviscollect!trans.cpatients_fk])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','DataType',[C(16) NOCPTRANS])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CPATIENTS_FK",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','UpdateName',[mmviscollect!trans.tadmit_date])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','DataType',[T])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.TADMIT_DATE",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','UpdateName',[mmviscollect!trans.ytotal_charge_amount])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','DataType',[Y])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YTOTAL_CHARGE_AMOUNT",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','UpdateName',[mmviscollect!trans.ycurrent_balance_amount])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','DataType',[Y])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YCURRENT_BALANCE_AMOUNT",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','UpdateName',[mmviscollect!trans.yreferral_balance_amount])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','DataType',[Y])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.YREFERRAL_BALANCE_AMOUNT",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','UpdateName',[mmviscollect!queue_names.cqueue_name])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','DataType',[C(50)])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CQUEUE_NAME",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','UpdateName',[mmviscollect!queue_names.cdepartment_code])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','DataType',[C(1)])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CDEPARTMENT_CODE",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','UpdateName',[mmviscollect!trans_employees_queues.cusgrlink_fk])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','DataType',[C(16) NOCPTRANS])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK",'Field','RuleText',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','KeyField',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','Updatable',.F.)
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','UpdateName',[mmviscollect!trans_employees_queues.iactive_flag])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','DataType',[I])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','Caption',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','DefaultValue',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','RuleExpression',[])
DBSetProp("LV_UNASSIGNED_TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG",'Field','RuleText',[])
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform