Last Updated User - Level Extreme

Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last Updated User
Message
From
23/02/2005 13:20:27
Gregory Adam
Belgium
23/02/2005 13:01:46
Naomi Nosonovsky
Wisconsin, United States
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:
00989741
Views:
>>>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',[])
>
Don't think I can derive that from the view. What you can do is

- Launch a form that uses the view
- in the command window type: SET and switch to the datasession of the form
- look at the buffermode of the base tables: should be none
Gregory
Map
View
Click here to load this message in the networking platform