Search found 7 matches

by clebernardelli
06.10.2006, 17:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Clear dataset
Replies: 9
Views: 2027

Memory continues High

OK.

I made the Download of units and functioned the EmptyDataSet. But I continue with a problem, the memory used for the operational system (win XP) for the application is not lowering when the EmptyDataSet is executed.

This is normal?

Thanks.
by clebernardelli
05.10.2006, 12:31
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error With CLOB on ORACLE9i
Replies: 5
Views: 963

Thank you, pol. I found the source of this problem. In unit ZDbcOracleResultSet.pas, the Open procedure: unit ZDbcOracleResultSet.pas procedure TZOracleResultSet.Open; . . case CurrentVar.DataType of . . (Before) SQLT_CLOB: (Only) CurrentVar.ColType := stAsciiStream; (After) SQLT_CLOB: begin Current...
by clebernardelli
04.10.2006, 19:22
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error With CLOB on ORACLE9i
Replies: 5
Views: 963

Error With CLOB on ORACLE9i

When I have a field type CLOB in the Oracle, when opening the DataSet happens an error ORA-00932: inconsistent datatypes

Somebody already passed for this error ?
by clebernardelli
29.09.2006, 12:30
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Clear dataset
Replies: 9
Views: 2027

My problem is the following one: I have one query (ZReadOnlyQuery) that he prossess a command SQL that returns many rows (200000). Then if I to make readings with paging I finish very being slow at certain moment. If not I as the reading happens the program goes consuming CPU resources until the poi...
by clebernardelli
26.09.2006, 20:25
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Clear dataset
Replies: 9
Views: 2027

I´m using ORACLE

I go to try way SQL. But I am using ORACLE and the functions are a little different.

But Thanks.
by clebernardelli
26.09.2006, 18:21
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Clear dataset
Replies: 9
Views: 2027

Clear dataset

Necessary to make with that one result set can be clean without query either closed. That is I have an instruction SQL that has 1000 rows and am reading (query.next). When to reach 100 records I want to continue reading but I want that the 100 read records already are eliminated of resultset. Thanks...
by clebernardelli
21.09.2006, 15:32
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: trouble connecting oracle
Replies: 7
Views: 1926

Hi.

Somebody already tried to connect in the Oracle without having the Oracle client installed?

That is I want to connect using only the necessary libraries (oci.dll,…), informing the IP of the server, user, database...

Somebody ?

Thanks.