Subquery with OR-condition error.

2006-08-10 Thread Alexei Novakov
Hi all, Neerly a year ago I wrote this message to this list: I ran into weird problem (MaxDB 7.5.0.30 on Windows). My query with correlated subquery in select gives me wrong results. Here is the testcase (very simplified). DDL: CREATE TABLE TMP_1 (ID_MAIN FIXED(19) NOT NULL PRIMARY KEY) CREA

devtools: ptoc can't find pgenc

2006-08-10 Thread Christian Bienia
Hi, when I try to build maxdb with the self-compiled devtools, I get the following error: Error while executing "[...]/pgm/ptoc -qn -e -DDYNAHASH vpr01.p" message: No such file or directory at [...]/bin/comppc.pl line 147 It turns out the reason is that ptoc tries to use pgenc, which it expects

Re: KB stack overflow - again. :/

2006-08-10 Thread Kristian Rink
Hi Elke, Lars, @world; Zabach, Elke schrieb: >> some time ago I was suffering from Error -1104 "Too complicated SQL >> statement", which, after reading through the mailing list, I >> resolved by >> drastically increasing _PACKET_SIZE. So far, so good. >> >> Anyhow, now the problem is there again

RE: Conversion Varchar BYTE -> Varchar ASCII

2006-08-10 Thread Zabach, Elke
Dusan Kolesar wrote: > > Hello, > I'm using MaxDb 7.6.0.16 on WinXp HE + SP2. > > Last time I asked you how to convert Varchar ASCII variabl > into Varchar > BYTE > Your answer was: HEXTORAW (HEX ()). > > Now I need to convert Varchar BYTE variabl into Varchar ASCII > inside stored procedure

RE: KB stack overflow - again. :/

2006-08-10 Thread Zabach, Elke
Kristian Rink wrote: > > > Hi all; > > some time ago I was suffering from Error -1104 "Too complicated SQL > statement", which, after reading through the mailing list, I > resolved by > drastically increasing _PACKET_SIZE. So far, so good. > > Anyhow, now the problem is there again. _PACKET_S