General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Creating a view in an existing database at production site.
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.
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