Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.14 » View Incident Report |
Minor |
Reported By: Mauro Botta Reported On: 7/26/2013 For: Version 2.13 Build 3 |
procedure TEDBScript.ConvertSQL(TabSize: Integer=3); var TempSourceSQL: TEDBString; TempPos: Integer; TempStatement: TEDBString; begin FSQL.BeginUpdate; try TempSourceSQL:=FSQL.Text; with FSQL do begin Clear; Add('SCRIPT ()'); Add('BEGIN'); end; TempPos:=1; TempStatement:=NextSQLStatement(TempSourceSQL,TempPos); while (TempStatement <> '') do begin TempStatement:=TrimString(TempStatement); if (TempStatement <> '') then >> FSQL.Add(Replicate(' ',TabSize)+TEDBString('EXECUTE IMMEDIATE ')+ TempStatement +TEDBString(';')); TempStatement:=NextSQLStatement(TempSourceSQL,TempPos); end; FSQL.Add('END'); finally FSQL.EndUpdate; end; end; This is my correction: FSQL.Add(Replicate(' ',TabSize)+TEDBString('EXECUTE IMMEDIATE ')+ QuotedStr( TempStatement ) +TEDBString(';'));
This web page was last updated on Wednesday, October 30, 2024 at 11:41 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |