General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Larry,
Here is the dump.....
* *
* * 04/08/02 MAX_ORA.DBC 14:52:39
* *
* *********************************************************
* *
* * Description:
* * This program was automatically generated by GENDBC
* * Version 2.26.67
* *
* *********************************************************
CLOSE DATA ALL
CREATE DATABASE 'MAX_ORA.DBC'
***************** Connection Definitions MAX_ORA ***************
CREATE CONNECTION MAX_ORA ;
DATASOURCE "Maximo" ;
USERID "sysadm" ;
PASSWORD "xxxxxxxxx"
****
=DBSetProp('MAX_ORA', 'Connection', 'Asynchronous', .F.)
=DBSetProp('MAX_ORA', 'Connection', 'BatchMode', .T.)
=DBSetProp('MAX_ORA', 'Connection', 'Comment', '')
=DBSetProp('MAX_ORA', 'Connection', 'DispLogin', 1)
=DBSetProp('MAX_ORA', 'Connection', 'ConnectTimeOut', 15)
=DBSetProp('MAX_ORA', 'Connection', 'DispWarnings', .F.)
=DBSetProp('MAX_ORA', 'Connection', 'IdleTimeOut', 0)
=DBSetProp('MAX_ORA', 'Connection', 'QueryTimeOut', 0)
=DBSetProp('MAX_ORA', 'Connection', 'Transactions', 1)
=DBSetProp('MAX_ORA', 'Connection', 'Database', 'Maximo')
***************** View setup for LABOR ***************
CREATE SQL VIEW "LABOR" ;
REMOTE CONNECT "MAX_ORA" ;
AS SELECT * FROM LABOR Labor
DBSetProp('LABOR', 'View', 'UpdateType', 1)
DBSetProp('LABOR', 'View', 'WhereType', 3)
DBSetProp('LABOR', 'View', 'FetchMemo', .T.)
DBSetProp('LABOR', 'View', 'SendUpdates', .T.)
DBSetProp('LABOR', 'View', 'UseMemoSize', 255)
DBSetProp('LABOR', 'View', 'FetchSize', 100)
DBSetProp('LABOR', 'View', 'MaxRecords', -1)
DBSetProp('LABOR', 'View', 'Tables', 'LABOR')
DBSetProp('LABOR', 'View', 'Prepared', .F.)
DBSetProp('LABOR', 'View', 'CompareMemo', .T.)
DBSetProp('LABOR', 'View', 'FetchAsNeeded', .F.)
DBSetProp('LABOR', 'View', 'FetchSize', 100)
DBSetProp('LABOR', 'View', 'Comment', "")
DBSetProp('LABOR', 'View', 'BatchUpdateCount', 1)
DBSetProp('LABOR', 'View', 'ShareConnection', .F.)
*!* Field Level Properties for LABOR
* Props for the LABOR.laborcode field.
DBSetProp('LABOR.laborcode', 'Field', 'KeyField', .T.)
DBSetProp('LABOR.laborcode', 'Field', 'Updatable', .T.)
DBSetProp('LABOR.laborcode', 'Field', 'UpdateName', 'LABOR.LABORCODE')
DBSetProp('LABOR.laborcode', 'Field', 'DataType', "C(18)")
* Props for the LABOR.craft field.
DBSetProp('LABOR.craft', 'Field', 'KeyField', .F.)
DBSetProp('LABOR.craft', 'Field', 'Updatable', .T.)
DBSetProp('LABOR.craft', 'Field', 'UpdateName', 'LABOR.CRAFT')
DBSetProp('LABOR.craft', 'Field', 'DataType', "C(18)")
*--- Other fields but all are non-key fields and updatable.
Any guesses !
pete,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only