Zeoslib Portal

I think firebird developers suppose that you should backup the database and then restore from the backup

Also, please add "VALUE" as a keyword

long time no fix
right now if the connection is lost and you try to call reconnect it will raise exception
what is more serious, even after manual call to connect it seems to damage the process memory causing random AVs
it is a bug, is it not?

My solution was to replace "_" with "&" - works fine for me so far!

Initially I was thinking about "$" but then I remembered about the rdb$ stuff and switched to "&"

I don't have the full list - this four are used in my program as field names, so I suggest to add only them

I am aware of the default ansi keywords function, thanks anyway

There are some keywords missing in TZInterbase6DatabaseInfo.GetSQLKeywords, such as DATE, TIME, MIN, MAX, USER

Hello everyone
Just updated to the latest testing sources, and the problem is still there
Can we change '_' to any other character in TZAbstractDatabaseMetadata.FillWildcards?

I am porting an existing dbase IV system to firebird\zeos and got some serios speed issues. I've been trying to look into it and now I would like to know this: how come TZQuery.Post is so slow, and why does it executes so many code when trying to define table name for the update sql? Attached is scr...

I had to change it a bit
Otherwise it would try to close transaction (?) when performing disconnect and give an error

Yeah, eventually I had to find another way to get what I wanted

4dk2, thanks, but I needed this for string fields

How do I work with string fields that have #0 characters in them - like rdb$db_key? They seem to be truncated before the first #0 character when I try to select.

P.S. I really love easy delphi strings, but sometimes you just have to write C-style code to keep performance high

Well, trupka has explained about TZDefaultIdentifierConvertor.Quote exhaustively :) and even benchmarked it :up: Yep, it's ugly, but this is the price for speed. And I did not write it inside "asm .. end", did I? ;) Regarding TZGenericCachedResolver.FormInsertStatement: Old code would real...

I recommend to change from function TZGenericCachedResolver.FormInsertStatement(Columns: TObjectList; NewRowAccessor: TZRowAccessor): string; var I: Integer; Current: TZResolverParameter; TableName: string; Temp1, Temp2: string; begin TableName := DefineTableName; DefineInsertColumns(Columns); if Co...