>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.)