Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Oracle Update
Message
From
08/05/2002 14:58:10
Peter Sass
Marathon Pulp Inc.
Marathon, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00653915
Message ID:
00654172
Views:
20
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
Map
View

Click here to load this message in the networking platform