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