Le voici :

CREATE SQL VIEW "FINALVIEW" AS ;
SELECT Moveout.idnr, Moveout.bldg_unit, Moveout.fname, Moveout.name, Moveout.fname2, Moveout.name2, Moveout.fname3, ;
Moveout.name3, Moveout.move_in, Moveout.move_out, Moveout.lastrent, Moveout.deposit, Moveout.balance, ;
Whymove.address, Whymove.city, Whymove.state, Whymove.zip, Finaltable.keys, Finaltable.secdep, Finaltable.petdep, ;
Finaltable.totdep, Finaltable.payments, Finaltable.interest, Finaltable.otherc, Finaltable.otherc2, ;
Finaltable.otherc3, Finaltable.otherc4, Whymove.rec_id AS wrecid, Whymove.idnr AS widnr, Finaltable.rec_id AS frecid,;
Finaltable.idnr AS fidnr, Finaltable.othercdesc, Finaltable.otherc2desc, Finaltable.othercdesc3, ;
Finaltable.othercdesc4, Finaltable.lastbalance, Finaltable.adrent, Finaltable.nrkeys, Finaltable.lease, ;
Finaltable.otherd, Finaltable.otherddesc, Finaltable.otherd2, Finaltable.otherd2desc, Finaltable.otherd3, ;
Finaltable.otherddesc3, Finaltable.otherd4, Finaltable.otherddesc4 ;
FROM dbfinal!moveout ;
INNER JOIN dbfinal!whymove ;
LEFT OUTER JOIN dbfinal!finaltable ;
ON Whymove.idnr = Finaltable.idnr ;
ON Moveout.idnr = Whymove.idnr ;
WHERE ALLTRIM(Moveout.bldg_unit) = ALLTRIM(THISFORM.Pgf.page1.txtBldgUnit.Value) ;
AND ALLTRIM(UPPER(Moveout.name)) = ALLTRIM(UPPER(THISFORM.Pgf.page1.txtName.Value))

DBSetProp('FINALVIEW', 'View', 'UpdateType', 1)
DBSetProp('FINALVIEW', 'View', 'WhereType', 3)
DBSetProp('FINALVIEW', 'View', 'FetchMemo', .T.)
DBSetProp('FINALVIEW', 'View', 'SendUpdates', .T.)
DBSetProp('FINALVIEW', 'View', 'UseMemoSize', 255)
DBSetProp('FINALVIEW', 'View', 'FetchSize', 100)
DBSetProp('FINALVIEW', 'View', 'MaxRecords', -1)
DBSetProp('FINALVIEW', 'View', 'Tables', 'dbfinal!moveout,dbfinal!whymove,dbfinal!finaltable')
DBSetProp('FINALVIEW', 'View', 'Prepared', .F.)
DBSetProp('FINALVIEW', 'View', 'CompareMemo', .T.)
DBSetProp('FINALVIEW', 'View', 'FetchAsNeeded', .F.)
DBSetProp('FINALVIEW', 'View', 'FetchSize', 100)
DBSetProp('FINALVIEW', 'View', 'Comment', "")
DBSetProp('FINALVIEW', 'View', 'BatchUpdateCount', 1)
DBSetProp('FINALVIEW', 'View', 'ShareConnection', .F.)

*!* Field Level Properties for FINALVIEW
* Props for the FINALVIEW.idnr field.
DBSetProp('FINALVIEW.idnr', 'Field', 'KeyField', .T.)
DBSetProp('FINALVIEW.idnr', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.idnr', 'Field', 'UpdateName', 'dbfinal!moveout.idnr')
DBSetProp('FINALVIEW.idnr', 'Field', 'DataType', "N(6)")
* Props for the FINALVIEW.bldg_unit field.
DBSetProp('FINALVIEW.bldg_unit', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.bldg_unit', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.bldg_unit', 'Field', 'UpdateName', 'dbfinal!moveout.bldg_unit')
DBSetProp('FINALVIEW.bldg_unit', 'Field', 'DataType', "C(9)")
* Props for the FINALVIEW.fname field.
DBSetProp('FINALVIEW.fname', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.fname', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.fname', 'Field', 'UpdateName', 'dbfinal!moveout.fname')
DBSetProp('FINALVIEW.fname', 'Field', 'DataType', "C(15)")
* Props for the FINALVIEW.name field.
DBSetProp('FINALVIEW.name', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.name', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.name', 'Field', 'UpdateName', 'dbfinal!moveout.name')
DBSetProp('FINALVIEW.name', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.fname2 field.
DBSetProp('FINALVIEW.fname2', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.fname2', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.fname2', 'Field', 'UpdateName', 'dbfinal!moveout.fname2')
DBSetProp('FINALVIEW.fname2', 'Field', 'DataType', "C(15)")
* Props for the FINALVIEW.name2 field.
DBSetProp('FINALVIEW.name2', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.name2', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.name2', 'Field', 'UpdateName', 'dbfinal!moveout.name2')
DBSetProp('FINALVIEW.name2', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.fname3 field.
DBSetProp('FINALVIEW.fname3', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.fname3', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.fname3', 'Field', 'UpdateName', 'dbfinal!moveout.fname3')
DBSetProp('FINALVIEW.fname3', 'Field', 'DataType', "C(15)")
* Props for the FINALVIEW.name3 field.
DBSetProp('FINALVIEW.name3', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.name3', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.name3', 'Field', 'UpdateName', 'dbfinal!moveout.name3')
DBSetProp('FINALVIEW.name3', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.move_in field.
DBSetProp('FINALVIEW.move_in', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.move_in', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.move_in', 'Field', 'UpdateName', 'dbfinal!moveout.move_in')
DBSetProp('FINALVIEW.move_in', 'Field', 'DataType', "D")
* Props for the FINALVIEW.move_out field.
DBSetProp('FINALVIEW.move_out', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.move_out', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.move_out', 'Field', 'UpdateName', 'dbfinal!moveout.move_out')
DBSetProp('FINALVIEW.move_out', 'Field', 'DataType', "D")
* Props for the FINALVIEW.lastrent field.
DBSetProp('FINALVIEW.lastrent', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.lastrent', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.lastrent', 'Field', 'UpdateName', 'dbfinal!moveout.lastrent')
DBSetProp('FINALVIEW.lastrent', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.deposit field.
DBSetProp('FINALVIEW.deposit', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.deposit', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.deposit', 'Field', 'UpdateName', 'dbfinal!moveout.deposit')
DBSetProp('FINALVIEW.deposit', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.balance field.
DBSetProp('FINALVIEW.balance', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.balance', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.balance', 'Field', 'UpdateName', 'dbfinal!moveout.balance')
DBSetProp('FINALVIEW.balance', 'Field', 'DataType', "N(10,2)")
* Props for the FINALVIEW.address field.
DBSetProp('FINALVIEW.address', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.address', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.address', 'Field', 'UpdateName', 'dbfinal!whymove.address')
DBSetProp('FINALVIEW.address', 'Field', 'DataType', "C(40)")
* Props for the FINALVIEW.city field.
DBSetProp('FINALVIEW.city', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.city', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.city', 'Field', 'UpdateName', 'dbfinal!whymove.city')
DBSetProp('FINALVIEW.city', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.state field.
DBSetProp('FINALVIEW.state', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.state', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.state', 'Field', 'UpdateName', 'dbfinal!whymove.state')
DBSetProp('FINALVIEW.state', 'Field', 'DataType', "C(2)")
* Props for the FINALVIEW.zip field.
DBSetProp('FINALVIEW.zip', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.zip', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.zip', 'Field', 'UpdateName', 'dbfinal!whymove.zip')
DBSetProp('FINALVIEW.zip', 'Field', 'DataType', "C(7)")
* Props for the FINALVIEW.keys field.
DBSetProp('FINALVIEW.keys', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.keys', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.keys', 'Field', 'UpdateName', 'dbfinal!finaltable.keys')
DBSetProp('FINALVIEW.keys', 'Field', 'DataType', "D")
* Props for the FINALVIEW.secdep field.
DBSetProp('FINALVIEW.secdep', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.secdep', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.secdep', 'Field', 'UpdateName', 'dbfinal!finaltable.secdep')
DBSetProp('FINALVIEW.secdep', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.petdep field.
DBSetProp('FINALVIEW.petdep', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.petdep', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.petdep', 'Field', 'UpdateName', 'dbfinal!finaltable.petdep')
DBSetProp('FINALVIEW.petdep', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.totdep field.
DBSetProp('FINALVIEW.totdep', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.totdep', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.totdep', 'Field', 'UpdateName', 'dbfinal!finaltable.totdep')
DBSetProp('FINALVIEW.totdep', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.payments field.
DBSetProp('FINALVIEW.payments', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.payments', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.payments', 'Field', 'UpdateName', 'dbfinal!finaltable.payments')
DBSetProp('FINALVIEW.payments', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.interest field.
DBSetProp('FINALVIEW.interest', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.interest', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.interest', 'Field', 'UpdateName', 'dbfinal!finaltable.interest')
DBSetProp('FINALVIEW.interest', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherc field.
DBSetProp('FINALVIEW.otherc', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherc', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherc', 'Field', 'UpdateName', 'dbfinal!finaltable.otherc')
DBSetProp('FINALVIEW.otherc', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherc2 field.
DBSetProp('FINALVIEW.otherc2', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherc2', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherc2', 'Field', 'UpdateName', 'dbfinal!finaltable.otherc2')
DBSetProp('FINALVIEW.otherc2', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherc3 field.
DBSetProp('FINALVIEW.otherc3', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherc3', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherc3', 'Field', 'UpdateName', 'dbfinal!finaltable.otherc3')
DBSetProp('FINALVIEW.otherc3', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherc4 field.
DBSetProp('FINALVIEW.otherc4', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherc4', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherc4', 'Field', 'UpdateName', 'dbfinal!finaltable.otherc4')
DBSetProp('FINALVIEW.otherc4', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.wrecid field.
DBSetProp('FINALVIEW.wrecid', 'Field', 'KeyField', .T.)
DBSetProp('FINALVIEW.wrecid', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.wrecid', 'Field', 'UpdateName', 'dbfinal!whymove.rec_id')
DBSetProp('FINALVIEW.wrecid', 'Field', 'DataType', "C(8)")
* Props for the FINALVIEW.widnr field.
DBSetProp('FINALVIEW.widnr', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.widnr', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.widnr', 'Field', 'UpdateName', 'dbfinal!whymove.idnr')
DBSetProp('FINALVIEW.widnr', 'Field', 'DataType', "N(6)")
* Props for the FINALVIEW.frecid field.
DBSetProp('FINALVIEW.frecid', 'Field', 'KeyField', .T.)
DBSetProp('FINALVIEW.frecid', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.frecid', 'Field', 'UpdateName', 'dbfinal!finaltable.rec_id')
DBSetProp('FINALVIEW.frecid', 'Field', 'DataType', "C(8)")
* Props for the FINALVIEW.fidnr field.
DBSetProp('FINALVIEW.fidnr', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.fidnr', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.fidnr', 'Field', 'UpdateName', 'dbfinal!finaltable.idnr')
DBSetProp('FINALVIEW.fidnr', 'Field', 'DataType', "N(4)")
* Props for the FINALVIEW.othercdesc field.
DBSetProp('FINALVIEW.othercdesc', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.othercdesc', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.othercdesc', 'Field', 'UpdateName', 'dbfinal!finaltable.othercdesc')
DBSetProp('FINALVIEW.othercdesc', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.otherc2desc field.
DBSetProp('FINALVIEW.otherc2desc', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherc2desc', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherc2desc', 'Field', 'UpdateName', 'dbfinal!finaltable.otherc2desc')
DBSetProp('FINALVIEW.otherc2desc', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.othercdesc3 field.
DBSetProp('FINALVIEW.othercdesc3', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.othercdesc3', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.othercdesc3', 'Field', 'UpdateName', 'dbfinal!finaltable.othercdesc3')
DBSetProp('FINALVIEW.othercdesc3', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.othercdesc4 field.
DBSetProp('FINALVIEW.othercdesc4', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.othercdesc4', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.othercdesc4', 'Field', 'UpdateName', 'dbfinal!finaltable.othercdesc4')
DBSetProp('FINALVIEW.othercdesc4', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.lastbalance field.
DBSetProp('FINALVIEW.lastbalance', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.lastbalance', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.lastbalance', 'Field', 'UpdateName', 'dbfinal!finaltable.lastbalance')
DBSetProp('FINALVIEW.lastbalance', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.adrent field.
DBSetProp('FINALVIEW.adrent', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.adrent', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.adrent', 'Field', 'UpdateName', 'dbfinal!finaltable.adrent')
DBSetProp('FINALVIEW.adrent', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.nrkeys field.
DBSetProp('FINALVIEW.nrkeys', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.nrkeys', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.nrkeys', 'Field', 'UpdateName', 'dbfinal!finaltable.nrkeys')
DBSetProp('FINALVIEW.nrkeys', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.lease field.
DBSetProp('FINALVIEW.lease', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.lease', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.lease', 'Field', 'UpdateName', 'dbfinal!finaltable.lease')
DBSetProp('FINALVIEW.lease', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherd field.
DBSetProp('FINALVIEW.otherd', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherd', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherd', 'Field', 'UpdateName', 'dbfinal!finaltable.otherd')
DBSetProp('FINALVIEW.otherd', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherddesc field.
DBSetProp('FINALVIEW.otherddesc', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherddesc', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherddesc', 'Field', 'UpdateName', 'dbfinal!finaltable.otherddesc')
DBSetProp('FINALVIEW.otherddesc', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.otherd2 field.
DBSetProp('FINALVIEW.otherd2', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherd2', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherd2', 'Field', 'UpdateName', 'dbfinal!finaltable.otherd2')
DBSetProp('FINALVIEW.otherd2', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherd2desc field.
DBSetProp('FINALVIEW.otherd2desc', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherd2desc', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherd2desc', 'Field', 'UpdateName', 'dbfinal!finaltable.otherd2desc')
DBSetProp('FINALVIEW.otherd2desc', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.otherd3 field.
DBSetProp('FINALVIEW.otherd3', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherd3', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherd3', 'Field', 'UpdateName', 'dbfinal!finaltable.otherd3')
DBSetProp('FINALVIEW.otherd3', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherddesc3 field.
DBSetProp('FINALVIEW.otherddesc3', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherddesc3', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherddesc3', 'Field', 'UpdateName', 'dbfinal!finaltable.otherddesc3')
DBSetProp('FINALVIEW.otherddesc3', 'Field', 'DataType', "C(20)")
* Props for the FINALVIEW.otherd4 field.
DBSetProp('FINALVIEW.otherd4', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherd4', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherd4', 'Field', 'UpdateName', 'dbfinal!finaltable.otherd4')
DBSetProp('FINALVIEW.otherd4', 'Field', 'DataType', "N(9,2)")
* Props for the FINALVIEW.otherddesc4 field.
DBSetProp('FINALVIEW.otherddesc4', 'Field', 'KeyField', .F.)
DBSetProp('FINALVIEW.otherddesc4', 'Field', 'Updatable', .T.)
DBSetProp('FINALVIEW.otherddesc4', 'Field', 'UpdateName', 'dbfinal!finaltable.otherddesc4')
DBSetProp('FINALVIEW.otherddesc4', 'Field', 'DataType', "C(20)")


La seule partie qui ne vient pas de GenDbc est le WHERE.

Merci,

Bernard