View Issue Details

IDProjectCategoryView StatusLast Update
0001258Database Comparer VCL[All Projects] Generalpublic2018-06-19 19:21
ReportershirokovAssigned Tobarry 
Status feedbackResolutionreopened 
Product Version 
Target VersionFixed in Version 
Summary0001258: FB 3 database and script extracting errors
DescriptionWhen you extract the PROCEDURE_FILIAL_ZERO stored procedure from the DATABASE_TEST.FDB, the following error occurs:
Procedure PROCEDURE_FILIAL_ZERO: Invalid factor in expression (POSITION)
Script: Line:19 Pos:19

The script contains the following code:
if (position('TABLE_', vTabela) > 0) then

Also, when extracting from the "Script_Comparer.Sql" script, the following error occurs:
Invalid char in source text: "{".
Script: C:\Progects\DbComparer\bug\DB\Script_Comparer.Sql Line:1 Pos:2

In fact, this script doesn't include the "{" symbol at Line:1 Pos:2
Steps To ReproduceThe demo project, DB, and script are attached.

There is a video that describes the problem:!l3Y3ATxR!xRfhvdyrsOkvWNtob03sIQxY5oQHN9YfDJ9DCovpPcg

The demo uses IBDAC and Delphi 10.2 Tokyo. But in fact, the problem can be reproduced with any database connection.
TagsNo tags attached.



2018-03-13 22:05


Demo (81,019 bytes)


2018-06-01 05:22

administrator   ~0003740

Скрипт в каком-то полу-RTF формате, конечно будет Invalid char in source text: "{".


2018-06-19 19:21

administrator   ~0003836

The problem is not resolved in build 1673.
See the screenshot
FB 2.1.7

Issue History

Date Modified Username Field Change
2018-03-13 22:05 shirokov New Issue
2018-03-13 22:05 shirokov File Added: Demo
2018-03-29 18:38 shirokov Assigned To => barry
2018-03-29 18:38 shirokov Status new => assigned
2018-06-01 05:22 barry Note Added: 0003740
2018-06-01 05:23 barry Status assigned => resolved
2018-06-01 05:23 barry Resolution open => no change required
2018-06-19 19:21 shirokov Status resolved => feedback
2018-06-19 19:21 shirokov Resolution no change required => reopened
2018-06-19 19:21 shirokov Note Added: 0003836