Quote table name problems

[Babis Michael]

1) Updating a Table upon resolve kbmMW generates “triple” quotes on the table name instead of single with an EDB database.

kbmwMW generates:
UPDATE “My Table” SET “DeviceID” = :DeviceID, “Processed” = :Processed WHERE “””My Table”””.”RecordID” = :KBMMW_KEY_RecordID

Correct:
UPDATE “My Table” SET “DeviceID” = :DeviceID, “Processed” = :Processed WHERE “My Table”.”RecordID” = :KBMMW_KEY_RecordID

changing this on kbmMWCustomSQLMetaData.pas is working but i guess it is not the correct way:
function TkbmMWCustomSQLMetaData.FormatSchemaTableAndFieldName(const ASchemaName:string; const ATableName:string; const AFieldName:string; const AFieldType:TkbmSQLFieldNodeType = ntField):string;
begin
Result:= ATableName +TableFieldSeperator+FormatFieldName(AFieldName,AFieldType);
end;

2) if you assign a Rewrite component on the ConnectionPool and the Delete the “Rewrite component”, if you click on the Connection pool you’ll get AV.

Thank you

[Babis Michael]

Any news on this ?

[kimbomadsen]

Hi,

I digged somewhat into the resolver and metadata code to check what could result in what you describe.

I did not find any bugs, and considering that the metadata and resolver components are used extensively for storing data to databases, also using the ORM,

Changing the code as suggested is not the correct solution.

Which metadata component are you using?
How is its QuoteTableName, TableNameQuote and TableNameBrackets properties set?

Can you send me a super short sample that shows the problem?

best regards

Kim/C4D

[Babis Michael]

Hello,

Here’s a video for the 2nd issue. I’ll try to make an example of the 1st issue.

[video src="http://www.creationpower.gr/rewriter-ide-crashing.mp4" /]

Thank you

[Author]

Posts