View Issue Details

IDProjectCategoryView StatusLast Update
0001354Database Comparer VCLGeneralpublic2019-12-28 00:04
Reportershirokov Assigned Tobarry  
PriorityurgentSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version8.0.0.1913.Beta 
Summary0001354: MS SQL CTE SQL parse error when there is more that one CTE within the script
DescriptionThe error occurs: Missing: SELECT (<,>) Script: Line 5 pos 148

See the attached SchemaComplete.sql script.
Steps To ReproduceMSSQLDBExtract.DBStructure.Objs.MSSQLServerOptions.SQLServerVersion := st_MSSQL2008;
 MSSQLDBExtract.ExtractObjects := MSSQLDBExtract.ExtractObjects - [coRole];
 if MSSQLDBExtract.ExtractDatabase then begin

-------------------------------------

object MSSQLDBExtract: TMSSQLDBExtract
 DBCConnection = DBCConnectionUniDAC
 DBStructure = DBStructure
 Left = 384
 Top = 56
 end
 object DBStructure: TDBStructure
 Left = 280
 Top = 80
 end
 object DBCConnectionUniDAC: TDBCConnectionUniDAC
 Connection = WinfuelConnection.Connection
 Left = 208
 Top = 56
 end
TagsNo tags attached.

Activities

shirokov

2018-04-17 20:53

administrator  

SchemaComplete.zip (27,394 bytes)

Issue History

Date Modified Username Field Change
2018-04-17 20:53 shirokov New Issue
2018-04-17 20:53 shirokov Status new => assigned
2018-04-17 20:53 shirokov Assigned To => barry
2018-04-17 20:53 shirokov File Added: SchemaComplete.zip
2019-12-28 00:04 barry Status assigned => resolved
2019-12-28 00:04 barry Resolution open => fixed
2019-12-28 00:04 barry Fixed in Version => 8.0.0.1913.Beta