Search found 41 matches
- 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...
- 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...
- 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 ...
- 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...
- 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:...
- 20.10.2010, 18:06
- Forum: 6.6 - stable
- Topic: [patch_done] Input parameter count is less then expected
- Replies: 18
- Views: 3176
- 15.10.2010, 15:09
- Forum: 6.6 - stable
- Topic: [patch_done] Input parameter count is less then expected
- Replies: 18
- Views: 3176
- 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)...
- 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:
Tested with several scripts using the delimiters "/ /" and ";": Success!
Thanks!
The first test that I executed was successfully.
Tested with this script:
Code: Select all
SET GLOBAL log_bin_trust_function_creators = 1//
Thanks!
- 23.09.2009, 15:10
- Forum: 6.6 - stable
- Topic: Bug on TZSQLScriptParser.ParseText procedure
- Replies: 5
- Views: 667
- 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 ...