Search found 41 matches

by josimarz
03.12.2010, 18:05
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ExecSQL + Oracle + OCI_SUCCESS_WITH_INFO
Replies: 12
Views: 21813

Hello mdaems! I applied the changes in ZDbcOracleUtils unit. But, my SQL Query don't return results. After, I make the following change: procedure CheckOracleError(PlainDriver: IZOraclePlainDriver; ErrorHandle: POCIError; Status: Integer; LogCategory: TZLoggingCategory; LogMessage: string); {...} ca...
by josimarz
08.11.2010, 22:28
Forum: 6.6 - stable
Topic: Problem with Oracle CLOB field
Replies: 8
Views: 1433

Good news! I kicked a code that solved the problem. Theoretically, this change seems to have no effect. But in practice it worked. The change was in the ZDbcOracleResultSet unit, the GetBlob method of the TZOracleResultSet class. Soon after creating the object TZOracleBlob , run with a call to ReadB...
by josimarz
08.11.2010, 17:21
Forum: 6.6 - stable
Topic: Problem with Oracle CLOB field
Replies: 8
Views: 1433

Hello! I'm debugging and will be found some news. In the unit ZDbcOracleResultSet , TZOracleResultSet.GetBlob mthod create the pointer to the CLOB field content: GetSQLVarHolder(ColumnIndex); CurrentVar := @FOutVars.Variables[ColumnIndex]; if CurrentVar.TypeCode in [SQLT_BLOB, SQLT_CLOB] then begin ...
by josimarz
04.11.2010, 20:19
Forum: 6.6 - stable
Topic: Problem with Oracle CLOB field
Replies: 8
Views: 1433

Hello, I have the same problem. I identified that the fields whose value is null don't reads the value of the last record. I imagine the problem lies in defining the pointer. In ZDbcOracleResultSet unit, in TZOracleResultSet.GetBlob method. I'm trying to identify the source of the problem. Any break...
by josimarz
20.10.2010, 19:17
Forum: 6.6 - stable
Topic: [patch_done] Input parameter count is less then expected
Replies: 18
Views: 3176

Hello! I faked the error. Attached the sample project. Change the connection information in the component ZConnection . The script example.sql installs the database and records. After generating the error, change the FixedChar property of field AC_COUNTRY to False in the qryPersons TZQuery . Delphi:...
by josimarz
20.10.2010, 18:06
Forum: 6.6 - stable
Topic: [patch_done] Input parameter count is less then expected
Replies: 18
Views: 3176

Hello!

To solve the problem temporarily, in the field DS_ESTADO of the TZQuery qryPessoas, changed the property FixedChar to false.

I will create a project and submit to exemplify the problem.

Josimar
by josimarz
15.10.2010, 15:09
Forum: 6.6 - stable
Topic: [patch_done] Input parameter count is less then expected
Replies: 18
Views: 3176

Hello,

I could not identify which version was introduced the ftFixedChar data type.

I'm using Delphi 2006 version.

Josimar
by josimarz
29.09.2010, 15:02
Forum: 6.6 - stable
Topic: [patch_done] Input parameter count is less then expected
Replies: 18
Views: 3176

[patch_done] Input parameter count is less then expected

Hello! I founded a error using TZQuery components: Input parameter count is less then expected In a Delphi Form , have two TZQuery components. The first component is named qryPessoas , with SQL property: SELECT * FROM PESSOAS The PESSOAS table have the follows simplified structure: CD_PESSOA INT(11)...
by josimarz
28.09.2009, 15:21
Forum: 6.6 - stable
Topic: Bug on TZSQLScriptParser.ParseText procedure
Replies: 5
Views: 667

Hello!

The first test that I executed was successfully.

Tested with this script:

Code: Select all

SET GLOBAL log_bin_trust_function_creators = 1// 
Tested with several scripts using the delimiters "/ /" and ";": Success!

Thanks!
by josimarz
23.09.2009, 15:10
Forum: 6.6 - stable
Topic: Bug on TZSQLScriptParser.ParseText procedure
Replies: 5
Views: 667

Sorry!

I posted the bug on http://zeosbugs.firmos.at/

Thanks.
by josimarz
14.09.2009, 18:07
Forum: 6.6 - stable
Topic: Bug on TZSQLScriptParser.ParseText procedure
Replies: 5
Views: 667

Bug on TZSQLScriptParser.ParseText procedure

Hello! I founded a bug on ParseText method of TZSQLScriptParser class: I founded a error where the lenght of delimiter of statement is less then the last token of the statement. Example: SET GLOBAL log_bin_trust_function_creators = 1// The method concat the delimiter ("//") with the token ...