Shared Connection Problem

Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shared Connection Problem
Message
From
13/07/2005 14:29:13
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, United States
13/07/2005 14:14:09
Mark McCasland
Midlothian, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Shared Connection Problem
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01032328
Message ID:
01032337
Views:
>Could you post the SQL code used to create those views?
>
Sure.
***************** Begin View Definition V_LABEL ***************


LOCAL LAOPENEDDBCS[1,1], lcSet_Exact
PRIVATE lWriteDBCXProps

lcSet_Exact=SET('EXACT')
IF lcSet_Exact='OFF'
	SET EXACT ON
ENDIF


***Make sure the current database is correct
IF ADATABASES(LAOPENEDDBCS)=0 or ASCAN(LAOPENEDDBCS,"PLAY")=0
	OPEN DATABASE "C:\VFEAPPS\CONVERSION\DATA\PLAY"
ELSE
	SET DATABASE TO "PLAY"
ENDIF


IF lcSet_Exact='OFF'
	SET EXACT OFF
ENDIF



CREATE SQL VIEW "V_LABEL" ; 
 REMOTE CONNECT "CONNECTPLAY" ; 
	AS SELECT tblLabel.lab_KEY,;
		tblLabel.lab_NAME,;
		tblLabel.lev_LEVEL,;
		tblLabel.lab_ATTENTION,;
		tblLabel.lab_DEPARTMENT,;
		tblLabel.lab_DELIVER_TO,;
		tblLabel.lab_STREET,;
		tblLabel.lab_CITY,;
		tblLabel.lab_CITY_LINE,;
		tblLabel.sta_STATE_CODE,;
		tblLabel.lab_POSTAL_CODE,;
		tblLabel.cou_COUNTRY_CODE,;
		tblLabel.lab_COUNTRY_LINE,;
		tblLabel.lab_CREATION_DATE,;
		tblLabel.cnc_CURRENCY_CODE,;
		tblLabel.lab_ALT_NUMBER,;
		tblLabel.lab_E_MAIL,;
		tblLabel.typ_CUSTOMER_TYPE,;
		tblLabel.lab_ENTERED_BY,;
		tblLabel.lan_LANGUAGE_CODE,;
		tblLabel.lab_REVISION_DATE,;
		tblLabel.lab_SAN,;
		tblLabel.lab_PARENT_LABEL,;
		tblLabel.lab_REMINDER,;
		tblLabel.lab_SAN_SUFFIX,;
		tblLabel.cus_SOLD_TO_CUSTOMER,;
		tblLabel.lab_PREFERRED_COMM,;
		tblLabel.lab_FIRST_NAME,;
		tblLabel.lab_MIDDLE_INITIAL,;
		tblLabel.lab_LAST_NAME,;
		tblLabel.lab_NAME_SUFFIX,;
		tblLabel.npr_NAME_PREFIX,;
		tblLabel.own_OWNER_CODE,;
		tblLabel.lab_EMAIL_FORMAT;
	FROM dbo.tblLabel

DBSetProp('V_LABEL', 'View', 'UpdateType', 1)
DBSetProp('V_LABEL', 'View', 'WhereType', 1)
DBSetProp('V_LABEL', 'View', 'FetchMemo', .T.)
DBSetProp('V_LABEL', 'View', 'SendUpdates', .T.)
DBSetProp('V_LABEL', 'View', 'UseMemoSize', 255)
DBSetProp('V_LABEL', 'View', 'MaxRecords', -1)
DBSetProp('V_LABEL', 'View', 'Tables', 'dbo.tblLabel')
DBSetProp('V_LABEL', 'View', 'Prepared', .T.)
DBSetProp('V_LABEL', 'View', 'CompareMemo', .T.)
DBSetProp('V_LABEL', 'View', 'FetchAsNeeded', .F.)
DBSetProp('V_LABEL', 'View', 'FetchSize', 100)
DBSetProp('V_LABEL', 'View', 'ParameterList', "v_key,'I'")
DBSetProp('V_LABEL', 'View', 'Comment', "")
DBSetProp('V_LABEL', 'View', 'BatchUpdateCount', 1)
DBSetProp('V_LABEL', 'View', 'ShareConnection', .T.)

*!* Field Level Properties for V_LABEL
*** Props for the V_LABEL.lab_key field.
DBSetProp('V_LABEL.lab_key', 'Field', 'KeyField', .T.)
DBSetProp('V_LABEL.lab_key', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_key', 'Field', 'UpdateName', 'dbo.tblLabel.lab_KEY')
DBSetProp('V_LABEL.lab_key', 'Field', 'DataType', "I")
DBSetProp('V_LABEL.lab_key', 'Field', 'DefaultValue', "VFENEWKEY('v_label.lab_key')")
 
*** Props for the V_LABEL.lab_name field.
DBSetProp('V_LABEL.lab_name', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_name', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_name', 'Field', 'UpdateName', 'dbo.tblLabel.lab_NAME')
DBSetProp('V_LABEL.lab_name', 'Field', 'DataType', "C(35)")
 
*** Props for the V_LABEL.lev_level field.
DBSetProp('V_LABEL.lev_level', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lev_level', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lev_level', 'Field', 'UpdateName', 'dbo.tblLabel.lev_LEVEL')
DBSetProp('V_LABEL.lev_level', 'Field', 'DataType', "C(2)")
DBSetProp('V_LABEL.lev_level', 'Field', 'DefaultValue', "'DF'")
 
*** Props for the V_LABEL.lab_attention field.
DBSetProp('V_LABEL.lab_attention', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_attention', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_attention', 'Field', 'UpdateName', 'dbo.tblLabel.lab_ATTENTION')
DBSetProp('V_LABEL.lab_attention', 'Field', 'DataType', "C(35)")
 
*** Props for the V_LABEL.lab_department field.
DBSetProp('V_LABEL.lab_department', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_department', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_department', 'Field', 'UpdateName', 'dbo.tblLabel.lab_DEPARTMENT')
DBSetProp('V_LABEL.lab_department', 'Field', 'DataType', "C(35)")
 
*** Props for the V_LABEL.lab_deliver_to field.
DBSetProp('V_LABEL.lab_deliver_to', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_deliver_to', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_deliver_to', 'Field', 'UpdateName', 'dbo.tblLabel.lab_DELIVER_TO')
DBSetProp('V_LABEL.lab_deliver_to', 'Field', 'DataType', "C(35)")
 
*** Props for the V_LABEL.lab_street field.
DBSetProp('V_LABEL.lab_street', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_street', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_street', 'Field', 'UpdateName', 'dbo.tblLabel.lab_STREET')
DBSetProp('V_LABEL.lab_street', 'Field', 'DataType', "C(35)")
 
*** Props for the V_LABEL.lab_city field.
DBSetProp('V_LABEL.lab_city', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_city', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_city', 'Field', 'UpdateName', 'dbo.tblLabel.lab_CITY')
DBSetProp('V_LABEL.lab_city', 'Field', 'DataType', "C(30)")
 
*** Props for the V_LABEL.lab_city_line field.
DBSetProp('V_LABEL.lab_city_line', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_city_line', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_city_line', 'Field', 'UpdateName', 'dbo.tblLabel.lab_CITY_LINE')
DBSetProp('V_LABEL.lab_city_line', 'Field', 'DataType', "C(35)")
 
*** Props for the V_LABEL.sta_state_code field.
DBSetProp('V_LABEL.sta_state_code', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.sta_state_code', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.sta_state_code', 'Field', 'UpdateName', 'dbo.tblLabel.sta_STATE_CODE')
DBSetProp('V_LABEL.sta_state_code', 'Field', 'DataType', "C(2)")
 
*** Props for the V_LABEL.lab_postal_code field.
DBSetProp('V_LABEL.lab_postal_code', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_postal_code', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_postal_code', 'Field', 'UpdateName', 'dbo.tblLabel.lab_POSTAL_CODE')
DBSetProp('V_LABEL.lab_postal_code', 'Field', 'DataType', "C(10)")
 
*** Props for the V_LABEL.cou_country_code field.
DBSetProp('V_LABEL.cou_country_code', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.cou_country_code', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.cou_country_code', 'Field', 'UpdateName', 'dbo.tblLabel.cou_COUNTRY_CODE')
DBSetProp('V_LABEL.cou_country_code', 'Field', 'DataType', "C(3)")
 
*** Props for the V_LABEL.lab_country_line field.
DBSetProp('V_LABEL.lab_country_line', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_country_line', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_country_line', 'Field', 'UpdateName', 'dbo.tblLabel.lab_COUNTRY_LINE')
DBSetProp('V_LABEL.lab_country_line', 'Field', 'DataType', "C(35)")
 
*** Props for the V_LABEL.lab_creation_date field.
DBSetProp('V_LABEL.lab_creation_date', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_creation_date', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_creation_date', 'Field', 'UpdateName', 'dbo.tblLabel.lab_CREATION_DATE')
DBSetProp('V_LABEL.lab_creation_date', 'Field', 'DataType', "T")
DBSetProp('V_LABEL.lab_creation_date', 'Field', 'DefaultValue', "DATETIME()")
 
*** Props for the V_LABEL.cnc_currency_code field.
DBSetProp('V_LABEL.cnc_currency_code', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.cnc_currency_code', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.cnc_currency_code', 'Field', 'UpdateName', 'dbo.tblLabel.cnc_CURRENCY_CODE')
DBSetProp('V_LABEL.cnc_currency_code', 'Field', 'DataType', "C(1)")
DBSetProp('V_LABEL.cnc_currency_code', 'Field', 'DefaultValue', "'D'")
 
*** Props for the V_LABEL.lab_alt_number field.
DBSetProp('V_LABEL.lab_alt_number', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_alt_number', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_alt_number', 'Field', 'UpdateName', 'dbo.tblLabel.lab_ALT_NUMBER')
DBSetProp('V_LABEL.lab_alt_number', 'Field', 'DataType', "C(18)")
 
*** Props for the V_LABEL.lab_e_mail field.
DBSetProp('V_LABEL.lab_e_mail', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_e_mail', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_e_mail', 'Field', 'UpdateName', 'dbo.tblLabel.lab_E_MAIL')
DBSetProp('V_LABEL.lab_e_mail', 'Field', 'DataType', "C(100)")
 
*** Props for the V_LABEL.typ_customer_type field.
DBSetProp('V_LABEL.typ_customer_type', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.typ_customer_type', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.typ_customer_type', 'Field', 'UpdateName', 'dbo.tblLabel.typ_CUSTOMER_TYPE')
DBSetProp('V_LABEL.typ_customer_type', 'Field', 'DataType', "C(3)")
 
*** Props for the V_LABEL.lab_entered_by field.
DBSetProp('V_LABEL.lab_entered_by', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_entered_by', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_entered_by', 'Field', 'UpdateName', 'dbo.tblLabel.lab_ENTERED_BY')
DBSetProp('V_LABEL.lab_entered_by', 'Field', 'DataType', "C(10)")
 
*** Props for the V_LABEL.lan_language_code field.
DBSetProp('V_LABEL.lan_language_code', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lan_language_code', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lan_language_code', 'Field', 'UpdateName', 'dbo.tblLabel.lan_LANGUAGE_CODE')
DBSetProp('V_LABEL.lan_language_code', 'Field', 'DataType', "C(1)")
DBSetProp('V_LABEL.lan_language_code', 'Field', 'DefaultValue', "'E'")
 
*** Props for the V_LABEL.lab_revision_date field.
DBSetProp('V_LABEL.lab_revision_date', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_revision_date', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_revision_date', 'Field', 'UpdateName', 'dbo.tblLabel.lab_REVISION_DATE')
DBSetProp('V_LABEL.lab_revision_date', 'Field', 'DataType', "T")
DBSetProp('V_LABEL.lab_revision_date', 'Field', 'DefaultValue', "DATETIME()")
 
*** Props for the V_LABEL.lab_san field.
DBSetProp('V_LABEL.lab_san', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_san', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_san', 'Field', 'UpdateName', 'dbo.tblLabel.lab_SAN')
DBSetProp('V_LABEL.lab_san', 'Field', 'DataType', "C(16)")
 
*** Props for the V_LABEL.lab_parent_label field.
DBSetProp('V_LABEL.lab_parent_label', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_parent_label', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_parent_label', 'Field', 'UpdateName', 'dbo.tblLabel.lab_PARENT_LABEL')
DBSetProp('V_LABEL.lab_parent_label', 'Field', 'DataType', "I")
 
*** Props for the V_LABEL.lab_reminder field.
DBSetProp('V_LABEL.lab_reminder', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_reminder', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_reminder', 'Field', 'UpdateName', 'dbo.tblLabel.lab_REMINDER')
DBSetProp('V_LABEL.lab_reminder', 'Field', 'DataType', "C(254)")
 
*** Props for the V_LABEL.lab_san_suffix field.
DBSetProp('V_LABEL.lab_san_suffix', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_san_suffix', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_san_suffix', 'Field', 'UpdateName', 'dbo.tblLabel.lab_SAN_SUFFIX')
DBSetProp('V_LABEL.lab_san_suffix', 'Field', 'DataType', "C(4)")
 
*** Props for the V_LABEL.cus_sold_to_customer field.
DBSetProp('V_LABEL.cus_sold_to_customer', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.cus_sold_to_customer', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.cus_sold_to_customer', 'Field', 'UpdateName', 'dbo.tblLabel.cus_SOLD_TO_CUSTOMER')
DBSetProp('V_LABEL.cus_sold_to_customer', 'Field', 'DataType', "I")
 
*** Props for the V_LABEL.lab_preferred_comm field.
DBSetProp('V_LABEL.lab_preferred_comm', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_preferred_comm', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_preferred_comm', 'Field', 'UpdateName', 'dbo.tblLabel.lab_PREFERRED_COMM')
DBSetProp('V_LABEL.lab_preferred_comm', 'Field', 'DataType', "C(1)")
 
*** Props for the V_LABEL.lab_first_name field.
DBSetProp('V_LABEL.lab_first_name', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_first_name', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_first_name', 'Field', 'UpdateName', 'dbo.tblLabel.lab_FIRST_NAME')
DBSetProp('V_LABEL.lab_first_name', 'Field', 'DataType', "C(25)")
 
*** Props for the V_LABEL.lab_middle_initial field.
DBSetProp('V_LABEL.lab_middle_initial', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_middle_initial', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_middle_initial', 'Field', 'UpdateName', 'dbo.tblLabel.lab_MIDDLE_INITIAL')
DBSetProp('V_LABEL.lab_middle_initial', 'Field', 'DataType', "C(25)")
 
*** Props for the V_LABEL.lab_last_name field.
DBSetProp('V_LABEL.lab_last_name', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_last_name', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_last_name', 'Field', 'UpdateName', 'dbo.tblLabel.lab_LAST_NAME')
DBSetProp('V_LABEL.lab_last_name', 'Field', 'DataType', "C(25)")
 
*** Props for the V_LABEL.lab_name_suffix field.
DBSetProp('V_LABEL.lab_name_suffix', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_name_suffix', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_name_suffix', 'Field', 'UpdateName', 'dbo.tblLabel.lab_NAME_SUFFIX')
DBSetProp('V_LABEL.lab_name_suffix', 'Field', 'DataType', "C(25)")
 
*** Props for the V_LABEL.npr_name_prefix field.
DBSetProp('V_LABEL.npr_name_prefix', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.npr_name_prefix', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.npr_name_prefix', 'Field', 'UpdateName', 'dbo.tblLabel.npr_NAME_PREFIX')
DBSetProp('V_LABEL.npr_name_prefix', 'Field', 'DataType', "C(25)")
 
*** Props for the V_LABEL.own_owner_code field.
DBSetProp('V_LABEL.own_owner_code', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.own_owner_code', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.own_owner_code', 'Field', 'UpdateName', 'dbo.tblLabel.own_OWNER_CODE')
DBSetProp('V_LABEL.own_owner_code', 'Field', 'DataType', "C(2)")
DBSetProp('V_LABEL.own_owner_code', 'Field', 'DefaultValue', "'PA'")
 
*** Props for the V_LABEL.lab_email_format field.
DBSetProp('V_LABEL.lab_email_format', 'Field', 'KeyField', .F.)
DBSetProp('V_LABEL.lab_email_format', 'Field', 'Updatable', .T.)
DBSetProp('V_LABEL.lab_email_format', 'Field', 'UpdateName', 'dbo.tblLabel.lab_EMAIL_FORMAT')
DBSetProp('V_LABEL.lab_email_format', 'Field', 'DataType', "C(1)")
DBSetProp('V_LABEL.lab_email_format', 'Field', 'DefaultValue', "'H'")
 

***************** Begin View Definition V_VENDOR ***************


LOCAL LAOPENEDDBCS[1,1], lcSet_Exact
PRIVATE lWriteDBCXProps

lcSet_Exact=SET('EXACT')
IF lcSet_Exact='OFF'
	SET EXACT ON
ENDIF


***Make sure the current database is correct
IF ADATABASES(LAOPENEDDBCS)=0 or ASCAN(LAOPENEDDBCS,"PLAY")=0
	OPEN DATABASE "C:\VFEAPPS\CONVERSION\DATA\PLAY"
ELSE
	SET DATABASE TO "PLAY"
ENDIF


IF lcSet_Exact='OFF'
	SET EXACT OFF
ENDIF



CREATE SQL VIEW "V_VENDOR" ; 
 REMOTE CONNECT "CONNECTPLAY" ; 
	AS SELECT tblVendor.own_Owner_Code,;
		tblVendor.ven_VENDOR_NAME,;
		tblVendor.loc_STORAGE_LOCATION_NAME,;
		tblVendor.vra_CODE,;
		tblVendor.vty_VENDOR_TYPE_CODE,;
		tblVendor.ven_1099,;
		tblVendor.ven_ALT_VENDOR_NUMBER,;
		tblVendor.ven_EARLY_DAYS,;
		tblVendor.ven_EARLY_DISCOUNT,;
		tblVendor.ven_GRACE_DAYS,;
		tblVendor.lab_KEY,;
		tblVendor.ven_KEY_VENDOR,;
		tblVendor.ven_MIN_PO_VALUE,;
		tblVendor.ven_MIN_FOR_FREE_FREIGHT,;
		tblVendor.ven_RELIABILITY,;
		tblVendor.ven_REMINDER,;
		tblVendor.ven_REQUESTED_SHIPPER,;
		tblVendor.ven_SHIPPING_TERMS,;
		tblVendor.ven_TERMS,;
		tblVendor.ven_TAX_CODE,;
		tblVendor.ven_TAX_ID,;
		tblVendor.ven_USER_DEFINED_0,;
		tblVendor.ven_USER_DEFINED_1,;
		tblVendor.ven_USER_DEFINED_2,;
		tblVendor.ven_USER_DEFINED_3,;
		tblVendor.ven_USER_DEFINED_4,;
		tblVendor.ven_USER_DEFINED_5,;
		tblVendor.ven_USER_DEFINED_6,;
		tblVendor.ven_USER_DEFINED_7,;
		tblVendor.ven_USER_DEFINED_8,;
		tblVendor.ven_USER_DEFINED_9,;
		tblVendor.ven_USER_DEFINED_10,;
		tblVendor.ven_USER_DEFINED_11,;
		tblVendor.ven_USER_DEFINED_12,;
		tblVendor.ven_USER_DEFINED_13,;
		tblVendor.ven_USER_DEFINED_14,;
		tblVendor.ven_USER_DEFINED_15,;
		tblVendor.ven_USER_DEFINED_16,;
		tblVendor.ven_USER_DEFINED_17,;
		tblVendor.ven_USER_DEFINED_18,;
		tblVendor.ven_USER_DEFINED_19,;
		tblVendor.ven_USER_DEFINED_20,;
		tblVendor.ven_VAT_NUMBER,;
		tblVendor.ven_REMIT_TO_VENDOR,;
		tblVendor.ven_LAST_PO,;
		tblVendor.ven_FIRST_PO,;
		tblVendor.ven_PO_COUNT,;
		tblVendor.ven_TOTAL_DAYS_TO_RECEIVE,;
		tblVendor.ven_CREDIT_LIMIT,;
		tblVendor.ven_DEFAULT_LEAD_TIME;
	FROM dbo.tblVendor;
		JOIN tblLabel;
			ON tblVendor.Lab_Key = tblLabel.Lab_Key

DBSetProp('V_VENDOR', 'View', 'UpdateType', 1)
DBSetProp('V_VENDOR', 'View', 'WhereType', 1)
DBSetProp('V_VENDOR', 'View', 'FetchMemo', .T.)
DBSetProp('V_VENDOR', 'View', 'SendUpdates', .T.)
DBSetProp('V_VENDOR', 'View', 'UseMemoSize', 255)
DBSetProp('V_VENDOR', 'View', 'MaxRecords', -1)
DBSetProp('V_VENDOR', 'View', 'Tables', 'dbo.tblVendor')
DBSetProp('V_VENDOR', 'View', 'Prepared', .F.)
DBSetProp('V_VENDOR', 'View', 'CompareMemo', .T.)
DBSetProp('V_VENDOR', 'View', 'FetchAsNeeded', .F.)
DBSetProp('V_VENDOR', 'View', 'FetchSize', 100)
DBSetProp('V_VENDOR', 'View', 'Comment', "")
DBSetProp('V_VENDOR', 'View', 'BatchUpdateCount', 1)
DBSetProp('V_VENDOR', 'View', 'ShareConnection', .T.)

*!* Field Level Properties for V_VENDOR
*** Props for the V_VENDOR.own_owner_code field.
DBSetProp('V_VENDOR.own_owner_code', 'Field', 'KeyField', .T.)
DBSetProp('V_VENDOR.own_owner_code', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.own_owner_code', 'Field', 'UpdateName', 'dbo.tblVendor.own_Owner_Code')
DBSetProp('V_VENDOR.own_owner_code', 'Field', 'DataType', "C(2)")
DBSetProp('V_VENDOR.own_owner_code', 'Field', 'DefaultValue', "'PA'")
 
*** Props for the V_VENDOR.ven_vendor_name field.
DBSetProp('V_VENDOR.ven_vendor_name', 'Field', 'KeyField', .T.)
DBSetProp('V_VENDOR.ven_vendor_name', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_vendor_name', 'Field', 'UpdateName', 'dbo.tblVendor.ven_VENDOR_NAME')
DBSetProp('V_VENDOR.ven_vendor_name', 'Field', 'DataType', "C(9)")
 
*** Props for the V_VENDOR.loc_storage_location_name field.
DBSetProp('V_VENDOR.loc_storage_location_name', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.loc_storage_location_name', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.loc_storage_location_name', 'Field', 'UpdateName', 'dbo.tblVendor.loc_STORAGE_LOCATION_NAME')
DBSetProp('V_VENDOR.loc_storage_location_name', 'Field', 'DataType', "C(9)")
 
*** Props for the V_VENDOR.vra_code field.
DBSetProp('V_VENDOR.vra_code', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.vra_code', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.vra_code', 'Field', 'UpdateName', 'dbo.tblVendor.vra_CODE')
DBSetProp('V_VENDOR.vra_code', 'Field', 'DataType', "C(1)")
 
*** Props for the V_VENDOR.vty_vendor_type_code field.
DBSetProp('V_VENDOR.vty_vendor_type_code', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.vty_vendor_type_code', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.vty_vendor_type_code', 'Field', 'UpdateName', 'dbo.tblVendor.vty_VENDOR_TYPE_CODE')
DBSetProp('V_VENDOR.vty_vendor_type_code', 'Field', 'DataType', "C(3)")
DBSetProp('V_VENDOR.vty_vendor_type_code', 'Field', 'DefaultValue', "'DEF'")
 
*** Props for the V_VENDOR.ven_1099 field.
DBSetProp('V_VENDOR.ven_1099', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_1099', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_1099', 'Field', 'UpdateName', 'dbo.tblVendor.ven_1099')
DBSetProp('V_VENDOR.ven_1099', 'Field', 'DataType', "C(1)")
 
*** Props for the V_VENDOR.ven_alt_vendor_number field.
DBSetProp('V_VENDOR.ven_alt_vendor_number', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_alt_vendor_number', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_alt_vendor_number', 'Field', 'UpdateName', 'dbo.tblVendor.ven_ALT_VENDOR_NUMBER')
DBSetProp('V_VENDOR.ven_alt_vendor_number', 'Field', 'DataType', "C(10)")
 
*** Props for the V_VENDOR.ven_early_days field.
DBSetProp('V_VENDOR.ven_early_days', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_early_days', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_early_days', 'Field', 'UpdateName', 'dbo.tblVendor.ven_EARLY_DAYS')
DBSetProp('V_VENDOR.ven_early_days', 'Field', 'DataType', "I")
 
*** Props for the V_VENDOR.ven_early_discount field.
DBSetProp('V_VENDOR.ven_early_discount', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_early_discount', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_early_discount', 'Field', 'UpdateName', 'dbo.tblVendor.ven_EARLY_DISCOUNT')
DBSetProp('V_VENDOR.ven_early_discount', 'Field', 'DataType', "N(17,3)")
 
*** Props for the V_VENDOR.ven_grace_days field.
DBSetProp('V_VENDOR.ven_grace_days', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_grace_days', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_grace_days', 'Field', 'UpdateName', 'dbo.tblVendor.ven_GRACE_DAYS')
DBSetProp('V_VENDOR.ven_grace_days', 'Field', 'DataType', "I")
 
*** Props for the V_VENDOR.lab_key field.
DBSetProp('V_VENDOR.lab_key', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.lab_key', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.lab_key', 'Field', 'UpdateName', 'dbo.tblVendor.lab_KEY')
DBSetProp('V_VENDOR.lab_key', 'Field', 'DataType', "I")
 
*** Props for the V_VENDOR.ven_key_vendor field.
DBSetProp('V_VENDOR.ven_key_vendor', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_key_vendor', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_key_vendor', 'Field', 'UpdateName', 'dbo.tblVendor.ven_KEY_VENDOR')
DBSetProp('V_VENDOR.ven_key_vendor', 'Field', 'DataType', "C(1)")
 
*** Props for the V_VENDOR.ven_min_po_value field.
DBSetProp('V_VENDOR.ven_min_po_value', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_min_po_value', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_min_po_value', 'Field', 'UpdateName', 'dbo.tblVendor.ven_MIN_PO_VALUE')
DBSetProp('V_VENDOR.ven_min_po_value', 'Field', 'DataType', "N(17,2)")
 
*** Props for the V_VENDOR.ven_min_for_free_freight field.
DBSetProp('V_VENDOR.ven_min_for_free_freight', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_min_for_free_freight', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_min_for_free_freight', 'Field', 'UpdateName', 'dbo.tblVendor.ven_MIN_FOR_FREE_FREIGHT')
DBSetProp('V_VENDOR.ven_min_for_free_freight', 'Field', 'DataType', "N(17,2)")
 
*** Props for the V_VENDOR.ven_reliability field.
DBSetProp('V_VENDOR.ven_reliability', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_reliability', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_reliability', 'Field', 'UpdateName', 'dbo.tblVendor.ven_RELIABILITY')
DBSetProp('V_VENDOR.ven_reliability', 'Field', 'DataType', "I")
 
*** Props for the V_VENDOR.ven_reminder field.
DBSetProp('V_VENDOR.ven_reminder', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_reminder', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_reminder', 'Field', 'UpdateName', 'dbo.tblVendor.ven_REMINDER')
DBSetProp('V_VENDOR.ven_reminder', 'Field', 'DataType', "M")
 
*** Props for the V_VENDOR.ven_requested_shipper field.
DBSetProp('V_VENDOR.ven_requested_shipper', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_requested_shipper', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_requested_shipper', 'Field', 'UpdateName', 'dbo.tblVendor.ven_REQUESTED_SHIPPER')
DBSetProp('V_VENDOR.ven_requested_shipper', 'Field', 'DataType', "C(40)")
 
*** Props for the V_VENDOR.ven_shipping_terms field.
DBSetProp('V_VENDOR.ven_shipping_terms', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_shipping_terms', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_shipping_terms', 'Field', 'UpdateName', 'dbo.tblVendor.ven_SHIPPING_TERMS')
DBSetProp('V_VENDOR.ven_shipping_terms', 'Field', 'DataType', "C(40)")
 
*** Props for the V_VENDOR.ven_terms field.
DBSetProp('V_VENDOR.ven_terms', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_terms', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_terms', 'Field', 'UpdateName', 'dbo.tblVendor.ven_TERMS')
DBSetProp('V_VENDOR.ven_terms', 'Field', 'DataType', "I")
 
*** Props for the V_VENDOR.ven_tax_code field.
DBSetProp('V_VENDOR.ven_tax_code', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_tax_code', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_tax_code', 'Field', 'UpdateName', 'dbo.tblVendor.ven_TAX_CODE')
DBSetProp('V_VENDOR.ven_tax_code', 'Field', 'DataType', "C(20)")
 
*** Props for the V_VENDOR.ven_tax_id field.
DBSetProp('V_VENDOR.ven_tax_id', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_tax_id', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_tax_id', 'Field', 'UpdateName', 'dbo.tblVendor.ven_TAX_ID')
DBSetProp('V_VENDOR.ven_tax_id', 'Field', 'DataType', "C(18)")
 
*** Props for the V_VENDOR.ven_user_defined_0 field.
DBSetProp('V_VENDOR.ven_user_defined_0', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_0', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_0', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_0')
DBSetProp('V_VENDOR.ven_user_defined_0', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_1 field.
DBSetProp('V_VENDOR.ven_user_defined_1', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_1', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_1', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_1')
DBSetProp('V_VENDOR.ven_user_defined_1', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_2 field.
DBSetProp('V_VENDOR.ven_user_defined_2', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_2', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_2', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_2')
DBSetProp('V_VENDOR.ven_user_defined_2', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_3 field.
DBSetProp('V_VENDOR.ven_user_defined_3', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_3', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_3', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_3')
DBSetProp('V_VENDOR.ven_user_defined_3', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_4 field.
DBSetProp('V_VENDOR.ven_user_defined_4', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_4', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_4', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_4')
DBSetProp('V_VENDOR.ven_user_defined_4', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_5 field.
DBSetProp('V_VENDOR.ven_user_defined_5', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_5', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_5', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_5')
DBSetProp('V_VENDOR.ven_user_defined_5', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_6 field.
DBSetProp('V_VENDOR.ven_user_defined_6', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_6', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_6', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_6')
DBSetProp('V_VENDOR.ven_user_defined_6', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_7 field.
DBSetProp('V_VENDOR.ven_user_defined_7', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_7', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_7', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_7')
DBSetProp('V_VENDOR.ven_user_defined_7', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_8 field.
DBSetProp('V_VENDOR.ven_user_defined_8', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_8', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_8', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_8')
DBSetProp('V_VENDOR.ven_user_defined_8', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_9 field.
DBSetProp('V_VENDOR.ven_user_defined_9', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_9', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_9', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_9')
DBSetProp('V_VENDOR.ven_user_defined_9', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_10 field.
DBSetProp('V_VENDOR.ven_user_defined_10', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_10', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_10', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_10')
DBSetProp('V_VENDOR.ven_user_defined_10', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_11 field.
DBSetProp('V_VENDOR.ven_user_defined_11', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_11', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_11', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_11')
DBSetProp('V_VENDOR.ven_user_defined_11', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_12 field.
DBSetProp('V_VENDOR.ven_user_defined_12', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_12', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_12', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_12')
DBSetProp('V_VENDOR.ven_user_defined_12', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_13 field.
DBSetProp('V_VENDOR.ven_user_defined_13', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_13', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_13', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_13')
DBSetProp('V_VENDOR.ven_user_defined_13', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_14 field.
DBSetProp('V_VENDOR.ven_user_defined_14', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_14', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_14', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_14')
DBSetProp('V_VENDOR.ven_user_defined_14', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_15 field.
DBSetProp('V_VENDOR.ven_user_defined_15', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_15', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_15', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_15')
DBSetProp('V_VENDOR.ven_user_defined_15', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_16 field.
DBSetProp('V_VENDOR.ven_user_defined_16', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_16', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_16', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_16')
DBSetProp('V_VENDOR.ven_user_defined_16', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_17 field.
DBSetProp('V_VENDOR.ven_user_defined_17', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_17', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_17', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_17')
DBSetProp('V_VENDOR.ven_user_defined_17', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_18 field.
DBSetProp('V_VENDOR.ven_user_defined_18', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_18', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_18', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_18')
DBSetProp('V_VENDOR.ven_user_defined_18', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_19 field.
DBSetProp('V_VENDOR.ven_user_defined_19', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_19', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_19', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_19')
DBSetProp('V_VENDOR.ven_user_defined_19', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_user_defined_20 field.
DBSetProp('V_VENDOR.ven_user_defined_20', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_user_defined_20', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_user_defined_20', 'Field', 'UpdateName', 'dbo.tblVendor.ven_USER_DEFINED_20')
DBSetProp('V_VENDOR.ven_user_defined_20', 'Field', 'DataType', "C(30)")
 
*** Props for the V_VENDOR.ven_vat_number field.
DBSetProp('V_VENDOR.ven_vat_number', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_vat_number', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_vat_number', 'Field', 'UpdateName', 'dbo.tblVendor.ven_VAT_NUMBER')
DBSetProp('V_VENDOR.ven_vat_number', 'Field', 'DataType', "C(20)")
 
*** Props for the V_VENDOR.ven_remit_to_vendor field.
DBSetProp('V_VENDOR.ven_remit_to_vendor', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_remit_to_vendor', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_remit_to_vendor', 'Field', 'UpdateName', 'dbo.tblVendor.ven_REMIT_TO_VENDOR')
DBSetProp('V_VENDOR.ven_remit_to_vendor', 'Field', 'DataType', "C(9)")
 
*** Props for the V_VENDOR.ven_last_po field.
DBSetProp('V_VENDOR.ven_last_po', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_last_po', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_last_po', 'Field', 'UpdateName', 'dbo.tblVendor.ven_LAST_PO')
DBSetProp('V_VENDOR.ven_last_po', 'Field', 'DataType', "T")
 
*** Props for the V_VENDOR.ven_first_po field.
DBSetProp('V_VENDOR.ven_first_po', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_first_po', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_first_po', 'Field', 'UpdateName', 'dbo.tblVendor.ven_FIRST_PO')
DBSetProp('V_VENDOR.ven_first_po', 'Field', 'DataType', "T")
 
*** Props for the V_VENDOR.ven_po_count field.
DBSetProp('V_VENDOR.ven_po_count', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_po_count', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_po_count', 'Field', 'UpdateName', 'dbo.tblVendor.ven_PO_COUNT')
DBSetProp('V_VENDOR.ven_po_count', 'Field', 'DataType', "I")
 
*** Props for the V_VENDOR.ven_total_days_to_receive field.
DBSetProp('V_VENDOR.ven_total_days_to_receive', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_total_days_to_receive', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_total_days_to_receive', 'Field', 'UpdateName', 'dbo.tblVendor.ven_TOTAL_DAYS_TO_RECEIVE')
DBSetProp('V_VENDOR.ven_total_days_to_receive', 'Field', 'DataType', "I")
 
*** Props for the V_VENDOR.ven_credit_limit field.
DBSetProp('V_VENDOR.ven_credit_limit', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_credit_limit', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_credit_limit', 'Field', 'UpdateName', 'dbo.tblVendor.ven_CREDIT_LIMIT')
DBSetProp('V_VENDOR.ven_credit_limit', 'Field', 'DataType', "N(17,2)")
 
*** Props for the V_VENDOR.ven_default_lead_time field.
DBSetProp('V_VENDOR.ven_default_lead_time', 'Field', 'KeyField', .F.)
DBSetProp('V_VENDOR.ven_default_lead_time', 'Field', 'Updatable', .T.)
DBSetProp('V_VENDOR.ven_default_lead_time', 'Field', 'UpdateName', 'dbo.tblVendor.ven_DEFAULT_LEAD_TIME')
DBSetProp('V_VENDOR.ven_default_lead_time', 'Field', 'DataType', "I")
Regards,
Jim
Map
View
Click here to load this message in the networking platform