Zeoslib Portal

Hi Kirill, i've been testing various ways last days, so sorry for the late answer. Yet i didn't found a way to catch the lcl define except we would create an extra component package for Lazarus only. Also adding -dLCL to the designtime package did not help. Why i use the define: 1. Lazarus wrongly o...

Curious... Wondering about your client-lib versions.. Non of them are the versions for the servers you/we are talking about! My client and server version are on same level, your client version is somewhat newer than the servers you're attaching. And i think the truncaction errors you report are reas...

Hmmmpppff, nice catch! But yet i have no answer how to resolve what you are reporting. Even if i add the define, the code will never be executed. The IDE just visualizes it would do. If i set a breakpoint to the line, you mentioned, i don't get an halt on the line. On my side the debugger always use...

Krill, Both wrong defines fixed. See: https://sourceforge.net/p/zeoslib/code-0/7116/ According the Assert(s): in most cases it's exacly what i want: Do not compile the Asserts in release mode. But some of them need to be revisited, propably! -> happen on Developement.. I'll check then Assert() lines...

Thank you, that's eaxactly what i want to know. I can't believe the truncation errors of Oracle using UTF16 will continue. But i'm waiting for confirmation.
I'm curious about the MySQL and FreeTDS reports.. investigating

Hello Mark, i changed the DBRESULTFLAGENUM to DBRESULTFLAG_DEFAULT as suggested: https://sourceforge.net/p/zeoslib/code-0/7112/ All tests passing fine, thanks for pointing this out! Btw, is the "King regards" in your signature on purpose? An inside joke perhaps? Nope, not a inside joke, ju...

ae i'm a bit puzzled about the reports now because we had not been on same code bandwith iirc.

So could you make a small summary after all the changes, plz?

Now we've loads of tests fails now. However i think you're right.

I'll implement the explicit "START TRANSACTION" syntax.

Mark i never was able to find a problem with the current logic. Can you give me an example where it did fail? -> for the tests

Hello Mark, that makes me curious. Could you debug: ZDbcOleDBMetadata.pas -> TZOleDBDatabaseInfo.InitilizePropertiesFromDBInfo -> DBPROP_MULTIPLERESULTS: fSupportsMultipleResultSets := PropSet.rgProperties^ .vValue <> DBPROPVAL_MR_NOTSUPPORTED; Is there something wrong in my code? OTH can you please...

You don't need to post the project, jabounet. I'm starting from the premisse it's a cross post to https://forum.lazarus.freepascal.org/index.php/topic,51878.0.html , is it, or related? Than: jmst.loadFromStream(CreateBlobStream(FieldByName('DATAS'), bmread)); Errrrrrrrm did you ever (Even if this wa...

Hello Norbert,

please open a ticket for that:
make a create skript, a popullate data skript and a small no gui app (if possible) and i can fix it quickly. Yet my crystal ball doesn't talk to me

@aehimself I followed your advice and use OCI_ATTR_CHAR_SIZE for the character fields instead. Means we determine the Precision field and datasize will be calculated by NormalizeOracleTypeToSQLType. I found this constant in old oracle 8 headers, so it should work for old oracle servers too. See: htt...

@Vodnic First of all: Both ODBC protocols are tested and optimized against SQLServer only. So i can't guarantee if it would work. According your question: IIRC the Informix is a raw Server so ODBC_A would be my choice. Determining the charactersets is a bit different made for OleDB/ODBC: set a custo...

Hello Krill, i fixed a bug: https://sourceforge.net/p/zeoslib/code-0/7088/ and added a TestCase: procedure TZGenericecTransactionTestCase.TestQueryTransaction; var Query: TZQuery; Transaction: TZTransaction; Succeeded: Boolean; begin Query := CreateQuery; Check(Query <> nil); Transaction := CreateTr...

I saw your latest checkin with the character length issue, but the verification for 12.0 seems a bit... unprofessional. True, but you're faster on testing than i've time for the forum. I just wanted to know if it resolve the problem. OCI_ATTR_CHAR_SIZE - Returns the column character length which is...