Re: Problem with delete / update statement and in clause (with join)

Have you tried using Any instead of In? Someone posted that there was a bug that Any and In were showing different results even though they should return the same. Have tried not exists like shown: select count(a.id)

Re: Problem with delete / update statement and in clause (with join)

Have tried not exists like shown: select count(a.id) from bas_agnums a where not exists(select b.ag_id from va_ums b where b.ag_id=a.id group by b.ag_id) When i commit the query i never get a result. Query hangs. Same with "exists" statement. I don't believe what's wrong. Hope for some hints. wit

ODBC, OLE DB Problems

Hi all, I'm developing an application with Visual C#. I have a problem with ODBC access to MaxDB database. My problem occurs when I try to execute the following Quero: SELEC * FROM T_USERS WHERE USER='SYS' AND PASSWORD='SYS' The ODBC driver message error is: ERROR [HY000] [My

Re: Problem with delete / update statement and in clause (with join)

Hi Noah, that was my first idea. But is not working. You can not update a join in MAXDB (Message:Invalid end of SQL Statement). I've seen a post by Elke Zabach with a hint to use "exists clause". I've tried to set a flag with this (NO_UMS='N') to delete the rows without the flag. Thats not working

Re: Problem with delete / update statement and in clause (with join)

Hi Albert, I haven't run into this, and it does look like a problem, but I can suggest a work-around. (I use ms-sql-server here for some databases, so I know all about work-arounds!). I've seen all sorts of problems with the "IN" keyword on different databases. Perhaps it's more difficult to

Problem with delete / update statement and in clause (with join)

hi folks, following problem with actual maxdb release: I have found no way to delete rows from table A without a reference in table B. Table A 138000 rows Table B 38 rows select count(ID) from bas_agnums where id in(select distinct id from bas_agnums,va_ums where bas_agnums.id=va_ums.ag_id(+

Join performance

Hello, I have two tables: CREATE TABLE "ADMIN"."CAR" ( "ID" IntegerNOT NULLDEFAULT SERIAL (1), "TSTAMP" TimestampDEFAULT TIMESTAMP, "PARENT_ID" IntegerDEFAULT -1, "IMAGE_ID" IntegerDEFAULT -1, "NAME"

ireport.py

bonjour, I added a few lines in ireport.py: * uppercases commands (and shortcuts). * a (dirty ?) hack to avoid SQLError Exception when pattern is written with lowercase letters when asking for `table pattern`. ireport then retries with string.upper (pattern) * for Unix users (use readl

Re: ODBC

[EMAIL PROTECTED] wrote: > [ODBC Data Sources] > burak=MaxDB "burakd" here > [burakd] or "burak" here > ServerDB=TST > ServerNode=192.168.1.1 > Description=Test Databas > Driver=MaxDB > tracefilename=/var/log/odbc.log Ciao, Raphael -- carpe diem quam minimum credula postero ... -- MaxDB

ODBC

Hi I try to connect to maxdb. I use php with odbc. If i try to connect ODBC prints: Warning: odbc_connect(): SQL error: [unixODBC][SAP AG][LIBSQLOD SO] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in My odbc.ini file like this: [ODBC Data Sources] bur