Zeoslib Portal

Well, I just tried cross reference with DBLib and it returned the same as exported keys, only results were filtered on the foreign table as well. Cross reference (based on pure user expectation) would list ALL connections of ALL tables but no protocol I am using (Oracle, MSSQL, MySQL) does that curr...

"Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table)." This is also the ONLY method using the Foreign* properties of the...

Added a second commit to the same PR, now MariaDB should use the new queries too.
Any idea what Cross reference should show? That one seems to be broken on MySQL as well. If I know what should be there, I could try to fix that one aswell.

I opened a pull request, seems TZSQLMeataData on MySQL is not that commonly used by the community - as even the AV went undetected for who knows how many years. I opened a pull request on GitHub which fixes the Imported and Exported keys lookup on MySQL 5+. I also forgot that the MySQL protocol is a...

I stumbled upon this SO question, where someone, 5 years ago, on MySQL 5.6 was complaining about the speed of a query against INFORMATION_SCHEMA.key_column_usage. This makes me quite comfortable that this entry was present above V5. I don't know if IMPORTED KEYS and EXPORTED KEYS metadata ever worke...

In an ideal world there's no delay; a 30 GB file is downloaded instantly from the Internet, the latest games run flawless on a 2k era Intel Celeron and Chrome is more than satisfied with 64 kb of RAM. Our challenge as software developers is to make the "real world" acceptable for the users...

Well, great. I just realized that the command in the metadata is not correct, and INFORMATION_SCHEMA.KEY_COLUMN_USAGE should be used. So I changed Imported keys and Exported keys, was about to come to ask if I should check them in, and... :) Well, I forgot to subscribe to the topic so I wasn't infor...

Why not to push everything in the background, loading and calculating? If calculation takes a second or two, most of your time will be spent with fetching anyway I suppose. I'm usually dimming all the contents and showing a progress indicator while allowing the user to cancel everything: Capture1.PNG

Is it just me, or TZSQLMetaData on MySQL, selecting mdExportedKeys throws an AV? The issue is in ZDbcMySQLMetaData.pas : 2000 (TZMySQLDatabaseMetadata.UncachedGetExportedKeys) ColumnIndexes[1] := FindColumn('Type'); The query what the metadata executes is "SHOW TABLE STATUS FROM tablename"...

At the moment no, there's none.

What you can do however is to execute the same query in two threads, two different datasets and the first one processes the first half, the second one processes the other half.

#75 fresh and ripe, ready for merging :)

As for the terminology and it's modification in an upcoming release - no idea.

As for the fixing, I support it. Just say the magic word and a pull request will be on it's way.

Hello, I realized that by simply calling SQLConnection.GetColumnNames('MYTABLE', 'MYCOLUMN', sl) returns multiple results from different schemas. If I use the other overload and specify SQLConnection.Catalog as the first parameter (schema pattern) only one row is returned as expected, as I have a sc...

Misread, nothing...

But maybe that's not needed. Afaik it's unnecessary, as GetInstance returns a new instance. As long as there's a plain driver, you'll always get an instance. I did not check the code right now, though so I might be wrong. If anyone is about to add this please make sure that it will continue to work...