[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Conditional Drop View

  • Thread starter Thread starter Tinco
  • Start date Start date
Status
Not open for further replies.
T

Tinco

Guest
Hi, In the java code I wrote for the following article: knowledgebase.progress.com/.../java-program-to-create-SQL-views-of-non-empty-PUB-tables-having-the-same-default-display-column-order-as-in-4GL I also did a SQL query on PUB._Sysviews to determine if a view already existed and then did a SQL 'DROP VIEW myViews.theViewName' to delete the SQL view before recreating the SQL view with a 'CREATE VIEW myViews.theViewName AS ...' later on in the same java code. Ii should be possible to reuse that part of the java code. Hopes this help, Tinco

Continue reading...
 
Status
Not open for further replies.
Back
Top