Search found 5 matches

by ckempe
22.08.2006, 20:26
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Calculated Fields cause an error...
Replies: 2
Views: 707

You are probably right, that the way I took is not 100% correct. But it worked.
I tried .refresh, but there´s no difference to close and open.
I´m just wondering why manupilating if the calculated field works ok within OnCalcFields and not outside...
by ckempe
21.08.2006, 10:31
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Calculated Fields cause an error...
Replies: 2
Views: 707

Calculated Fields cause an error...

Following Situation: I have a column containing a boolean value (it´s an integer: zero for false, anything else means true). To display it properly I´ve added a calculated field "_Mark" to the TZReadOnlyQuery. It displays an "X" when column "Mark" is not zero or a blank...
by ckempe
12.07.2006, 14:43
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with ZSQLProcessor using oracle-Protocl
Replies: 4
Views: 803

Mark,

please try exactly the same connecting to the Oracle Database using ADO. You will see, that it works fine.
So I think the problem is somewhere where the scripts are checked or so.

Concerning the error: I would prefer to keep the exception appearing.

Claudius
by ckempe
11.07.2006, 15:01
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with ZSQLProcessor using oracle-Protocl
Replies: 4
Views: 803

Hello! No, that was not the problem. The trigger is created, but marked as incorrect (see screenshot: http://www1.spdata.net/ora01.bmp ). If I put the cursor after the final "end;" and hit enter and then click on "kompilieren" = "compile" it works. The problem seems to ...
by ckempe
11.07.2006, 11:36
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with ZSQLProcessor using oracle-Protocl
Replies: 4
Views: 803

Problem with ZSQLProcessor using oracle-Protocl

Hello! I want to do the following: create or replace trigger INC_buchungen before insert on buchungen for each row begin if :new.Nummer is null then select GEN_buchungen.nextval into :new.Nummer from dual; end if; end; GO The SQL-Processor Delimiter-Type is set to dtGO. Here´s the output generated b...