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
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
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
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
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