Unknown column name:SYSKEY

2005-06-30 Thread R. Vajsar
Hello, We are using the MaxDB version 7.5.00.19. My application works well, but when I'm using Microsoft Query to import data from view, the error occures: Column not found,-4005 POS(32) Unknown column name:SYSKEY. Has anyone an idea, what can I do? Thanks, Richard Vajsar -- MaxDB Discussion

Re: AW: Unknown column name:SYSKEY

2005-07-01 Thread R. Vajsar
DATUM FROM KLIENT_PRODUKT WHERE DATUM_VRAC IS NOT NULL). SYSKEY not exist probably - I can't create index for this view. What am I doing wrong? R. V. Zabach, Elke wrote: R. Vajsar wrote Hello, We are using the MaxDB version 7.5.00.19. My application works well, but when I'm using Micro

Re: AW: AW: Unknown column name:SYSKEY

2005-07-07 Thread R. Vajsar
is a feature? The primary problem is error: Column not found,-4005 POS(32) Unknown column name:SYSKEY when I want to get data from view through ODBC into MS query. Base table of view has index. I inspect the vtrace file, but I don't see anything useful:-( R.V. Zabach, Elke wrote: R. Vajsar w

Re: AW: AW: AW: Unknown column name:SYSKEY

2005-07-08 Thread R. Vajsar
I had sent vtrace in last but one mail message ("The error occures only when creating a query based on VIEW: .."). Well, once more R.V. Zabach, Elke wrote: R. Vajsar wrote: Oh yes. I'm only looking for relationship between primary key, SYSKEY and error

Re: AW: Unknown column name:SYSKEY

2005-07-10 Thread R. Vajsar
Not me, MS query did it! It is a part of MS Office, a sort of SQL query wizard. It has GUI. User choose a table or VIEW (f.e. K_P_VYVOJ), then choose a displayed field (f.e. ID) and .. Column not found,-4005 POS(32) Unknown column name:SYSKEY. How he thinks out the column SYSKEY? Zabach, E