Hello,

I want to send a program(CREATE SQL VIEW "DRAWREL_DRAWINGS_VIEW") to a project where they have the database and the dataset of tables which they are running since six yrs.

If there were any changes i used to create the new exe for them.

But now i want to create a new view for them at there project.

Because we dont have the install shield here so what is the best way for me to create a program or some thing so they can run that at there site and it should automatically create the view in there pmis.dbc(database).

This will be the view code i want to use for creating the view:

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

************end***********

Please let me know is the method to handle this at there site.

Thank you very much.