IDE: Delphi XE6
Version: 9.3.105.1351 Server Edition
Driver: SDAC (ver 8.0.2) & SQL Server 2012
Any idea why this query make an exception to schema modeler ?
Query:
SELECT 100 Price, 1 MovID, GETDATE() Date,
FORMATMESSAGE(‘ID: [%s] Amount: [$ %s] Exp: [%s]’, ‘100’, FORMAT(99, ‘#,0.00’), FORMAT(GETDATE(), ‘dd/MM/yyyy’)) AS Ref
Data Abstract Schema Modeler
System.OutOfMemoryException
Exception of type ‘System.OutOfMemoryException’ was thrown.
at System.Collections.Generic.List1.set_Capacity(Int32 value) at System.Collections.Generic.List
1.EnsureCapacity(Int32 min)
at System.Collections.Generic.List`1.Add(T item)
at RemObjects.DataAbstract.Server.SqlParametersParser.ExtractParameters(String source, Char parameterSymbol, Char quoteSymbols, Char textDelimiter)
at RemObjects.DataAbstract.Server.SqlParametersParser.GetParameterNames(String sql, Char parameterSymbol, Char quoteSymbols, Char textDelimiter, Boolean caseInsensitive, Boolean extractUniqueNamesOnly)
at A.A.A(String )
at A.A.a(String )
at RemObjects.DataAbstract.SchemaModeler.ViewModel.StatementViewModel.ExtractParameters(String sql)
at RemObjects.DataAbstract.SchemaModeler.ViewModel.StatementViewModel.UpdateParametersForSQL(String statement, Boolean confirmationNeeded)
at RemObjects.DataAbstract.SchemaModeler.ViewModel.StatementViewModel.<>c__DisplayClass7.b__0()
at RemObjects.DataAbstract.SchemaModeler.ViewModel.StatementViewModel.EndGetMetadataForSql(SchemaDataTable metadata, Action nextAction)