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

  • Thread starter Thread starter sjellin.dovetail
  • Start date Start date
Status
Not open for further replies.
S

sjellin.dovetail

Guest
(Sorry if this isn't the right Forum). OpenEdge 11.6 - to ease SQL view creation / modification with deployments I've been trying to figure out how to conditionally delete a View IF it exists as not all views are at all clients at any given time (we would like to have a standard script to delete specific views, reload them - and leave any custom views that are at the client alone). I've tried if (exists (select * from .sysview.. )) and that didn't work (The select on its own works). Any help would as always be greatly apreciated.

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