Zeoslib Portal

Fixed :)

Pull request available on GitHub.

The latest Zeos8 from SVN or Git works just fine.
If you prefer, you also can try to install 7.2 as well with the latest package available; it might work.

OMG, this is the most paranoid code I've ever seen... "World state" suggests we are talking about a game engine. Imagine the lag 1,2 sec of saving world state will generate :) Tbh I don't see the reason of this check either. I'd only do safeguards if actual corruption happened once but co...

This by itself won't do much. - Save the original data to the disk, save the contents of blob field to the disk. Compare the differences. - After saving your blob, post the dataset and read it to a different stream. Save both streams to the disk and compare differences. My guess is your data is safe...

Fresh, ripe pull request available for picking! :)

You'll need something like TZGenericStatementAnalyser and DefineSelectSchemaFromQuery but instead of SELECT and FROM, you'll have to search to DELETE FROM, INSERT INTO and UPDATE SET. Most probably you'll end up with a class helper / derived analyzer. I just wrote one for myself, that's why I know ...

Just an fyi, if someone is interested. I wrote a descendant of TZGenericStatementAnalyser which can parse all table aliases, even if multiple SQL commands are provided. For the solution, you can visit this topic on DelphiPraxis , where the reason behind is also explained. @ Jan, If you think it has ...

Hello, Of course you can use TZQuery (even for changing field values) but only for simple queries. In case you have a join or such, Zeos will even throw an exception to tell you that it won't work. Only in those cases you need a TZUpdateSQL to tell Zeos how exactly to assemble your INSERT / UPDATE q...

The real world test is to call GetIndexInfo on a MySQL table that contains both a primary key and also a non-unique index. You should see the NON-UNIQUE column for the non-unique index = false (which is incorrect.) Strange, even in my own home-cooked application I have plenty of tables like this an...

That's odd. I've tested it quite a bit. What do you get if you put this code in that function (at that same line)? Note that the dataset's type for IndexInfoColNonUniqueIndex is a boolean and the existing code tries to set it as a string (and I think the logic of it is incorrect regardless.) Don't ...

@ Mark,

How did you get this error? I'm using Zeos with MySQL on a daily basis and never seen it returning everything as unique.
Do you maybe have a test case?

Cheers!

I support the second option, especially since MSSQL does this the same way (sending the USE command after login).

Which version? Which package? Any error messages? What steps did you do until you got the error?

None of us has a crystal ball. Please try to be more specific.

I have 0 experience with PG; however, the above statement looks like an SQL command.

Did you try ?

The way I am handling these things is: - Have all components on the VLC form. DB aware components are allowed and working well. - Before any background operation, disconnect all DB aware components from their datasources - Show your "loading" screen - Create and execute a thread which only...