RE: Conversion Varchar BYTE -> Varchar ASCII

2006-08-11 Thread Zabach, Elke
Dusan Kolesar wrote: > Hello Elke, > > It is not working. > When I do > SET msgAscii = ASCII (msgByte); > Error --- > Integrity constraint violation;-8006 POS(6046) Data types must be > compatible > Then please send the following info: installation parameter

Re: devtools: ptoc can't find pgenc

2006-08-11 Thread Robert Klemme
2006/8/10, Christian Bienia <[EMAIL PROTECTED]>: 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 reaso

Re: Subquery with OR-condition error.

2006-08-11 Thread Robert Klemme
2006/8/11, Alexei Novakov <[EMAIL PROTECTED]>: 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

RE: Subquery with OR-condition error.

2006-08-11 Thread Jey Razack
Try this: SELECT T2.ID_MAIN AS ID_1, T1.ID_MAIN AS ID_2, (SELECT IT1.VAL_STR FROM TMP_2 IT1 WHERE IT1.ID_1 = T2.ID_MAIN AND IT1.ID_2 = T1.ID_MAIN) FROM TMP_1 T1, TMP_1 T2, TMP_2 T3 WHERE ( ( T3.ID_1 IN (1, 2, 3, 4, 5) AND T3.VAL_STR LIKE 'aaa-%'

RE: devtools: ptoc can't find pgenc

2006-08-11 Thread Dittmar, Daniel
>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 at the location /usr/lib/pgenc. I have installed my devtools in >a non-standard direc