Zeoslib Portal

Just as a follow up : stored proc support should be improved significantly in the recent beta release. Thanks to everybody who did the necessary changes!

Mark

Beta has just been released. See announcement on front page of the portal.

Michael included the source yesterday to the egonhugeist branch. I just did some cleanup and I'm merging the new version to testing branch right now.

Mark

OK, whithout the quoutes then... Did you try to see what query is sent to the database exactly by using a TZSQLMonitor? (Add to your project somewhere and let it write to a log file. That way we can verify what query gives this problem. It might very well not be your query, but a metadata fetching q...

What 'all the other documentations' are you talking about exactly?
Apart from the knowledge base and the source documentation that's packaged when a release is made there's not that much available as far as I know...

Someone once sent me a manual with the ZExpression functionality that's also used for Filters:

amarildolacerda,
You're ambitous! Certainly more than I am.
If you get TNestedDatasets working, that would be extremely nice. But even a utility function to get a dbc resultset instance from a refcursor would be nice!
I'm hopefully waiting for the result of your experiments!

Mark

As far as I understand there's not a real generic way you can develop to handle the data returned. You could do so when you're sure the procedure only returns one variable, which is the refcursor variable. This isn't really something you easily do with a 'one resultset at a time' architecture as zeo...

Looks like a great framework, but I'm afraid this is to complex to add into zeoslib natively. Why not start a separate project, using zeoslib source code (eg using a svn-external to copy in zeoslib's most recent code where you need it?

Michael, what's your idea about that?

Mark

Sorien , When changing ZGenericSqlToken.pas you mainly change the behaviour of the filter feature of the datasets. And those should respond to system settings. The database specific Tokenizers decide themselves if they use the generic (system dependent) behaviour or not. So maybe we better provide ...

Please try if entering double quotes around the database same helps. Mssql apparently uses double quotes for identifier quoting (so special characters can be used for identifier names).

Mark

mmvisual , Michael already added a new functionality to testing branch to do exactly what you need. It's not an ideal solution, but it does what you need. As this feature isn't really ready, I'm not going to explain you how it works. If you can find out what happens in SVN rev. 1183/1184, then you'...

Not sure if that fixes your problem, but you should use Open instead of Execsql to get a resultset. Execsql is made for executing updates, deletes, inserts or alters. Not for returning resultsets.

Mark

Yes, but we're talking about the 6.6-patches branch here... Is it applicable there too?

Mark

Ðerek wildstar , Seems you're using the 6.6 version. I don't know why these lines are there. I tried to remove them and they did not have any impact on when testing with firebird, sqlite and mysql. Failed to test with oracle and postgres for some strange problem on this computer at the moment. This...