Devart Forums

When using quoted field names (IBDAC 2.0, Firebird 2.0), all fields are quoted by the "SQL Generator", but it seems only partially to use correct casing when generating SQL statements based on a given SELECT statement

Example:
INSERT INTO "TableX"
("ID", "MAALID", "METODEID", "STATUSID")
VALUES
(:"Id", :"MaalId", :"MetodeId", :"StatusId")

should have been generated as

INSERT INTO "TableX"
("Id", "MaalId", "MetodeId", "StatusId")
VALUES
(:"Id", :"MaalId", :"MetodeId", :"StatusId")

We have reproduced and fixed this problem. This fix will be included in the next IBDAC build.

It seems like the handling of quoted names have several problems:

Example 1:
Stored procedures with quoted names and quoted parameter names can not be called using the IBCStoredProc component: When the IBCStoredProc editor is envoked, you get this messagebox
---------------------------
Error
---------------------------
Dynamic SQL Error
Input parameter mismatch for procedure .
---------------------------
OK Details >>
---------------------------

Example 2:
In components having a "KeyGenerator" property, the quotes around the generator name must be placed manually, but the "KeyFields" property handles quoted names correctly, if Options -> QuotedNames are set to true.


Maybe it should be checked that quoted names are generally handled as expected

Best regards
Thomas

All these quotation problems were caused by the same code issue, that we have already fixed. This fix will be available with the next IBDAC build. IBDAC build will be released next week.