Hello Gordon,
Thank you very much.
Please i am very new to visual foxpro.
Could you please tell me how i can integrate this updateperform.fxp into my exe.
I have this code for creating the view:
and in the updateperform.fxp where can i put this code:
******************Start***********
CREATE SQL VIEW "DRAWREL_DRAWINGS_VIEW" ;
AS SELECT * FROM drawrel WHERE Drawrel.drawing_id = ?Drawings.drawing_Id AND DELETED() = .f.
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'UpdateType', 1)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'WhereType', 3)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'FetchMemo', .T.)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'SendUpdates', .T.)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'UseMemoSize', 255)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'FetchSize', 100)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'MaxRecords', -1)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'Tables', 'drawrel')
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'Prepared', .F.)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'CompareMemo', .T.)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'FetchAsNeeded', .F.)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'FetchSize', 100)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'Comment', "")
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'BatchUpdateCount', 1)
DBSetProp('DRAWREL_DRAWINGS_VIEW', 'View', 'ShareConnection', .F.)
************************************************************************
Thank you very much Gordon.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement