Hello
> -Original Message-
> From: R. Vajsar [mailto:[EMAIL PROTECTED]
> Sent: Freitag, 8. Juli 2005 20:13
> To: Zabach, Elke
> Cc: maxdb@lists.mysql.com
> Subject: Re: AW: Unknown column name:SYSKEY
>
> Not me, MS query did it!
Maybe some information provided
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
R. Vajsar wrote:
>
> 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.
>
I can see the command:
SELECT K_P_VYVOJ.ID, K_P_VYVOJ.SYSKEY FROM APT.K_P_VYVOJ K_P_VYVOJ
And as we saw in a prev
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 4005 ("check if the
R. Vajsar wrote:
>
> Oh yes. I'm only looking for relationship between primary key, SYSKEY
and
> error 4005 ("check if the table mentioned has a user-defined primary
key
> (then SYSKEY will NOT exist) or not"). If a view hasn't index, then
SYSKEY
> doesn't exist and error 4005 in this case is a fe
Oh yes. I'm only looking for relationship between primary key, SYSKEY and error 4005
("check if the table mentioned has a user-defined primary key (then SYSKEY will NOT
exist) or not"). If a view hasn't index, then SYSKEY doesn't exist and error 4005 in
this case is a feature?
The primary probl
R. Vajsar wrote:
>
> The error occures only when creating a query based on VIEW:
> (CREATE VIEW K_P_VYVOJ AS SELECT ID, KLIENT_ID, PRODUKT, SMLOUV_TYP,
ZMENA
> = 1, VALUE(DATUM_OD,'1994-01-01') AS DATUM FROM KLIENT_PRODUKT UNION
> SELECT ID, KLIENT_ID, PRODUKT, SMLOUV_TYP, ZMENA = -1, DATUM_VRAC A
The error occures only when creating a query based on VIEW:
(CREATE VIEW K_P_VYVOJ AS SELECT ID, KLIENT_ID, PRODUKT, SMLOUV_TYP, ZMENA = 1,
VALUE(DATUM_OD,'1994-01-01') AS DATUM FROM KLIENT_PRODUKT UNION SELECT ID,
KLIENT_ID, PRODUKT, SMLOUV_TYP, ZMENA = -1, DATUM_VRAC AS DATUM FROM
KLIENT_PROD
R. Vajsar wrote
>
> 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?
As I do not k
Kolja Kleist wrote:
>
> Hello,
>
> I've got really strange problems with our production database(SAP DB
> 7.4.3.32).
> There is one table with the following columns:
>
> FOREIGN_KEY_TABLE_A,
> FOREIGN_KEY_TABLE_B,
> NUMBER_FIELD,
> TEXT_FIELD
>
> First we had no primary key, but because of the
10 matches
Mail list logo
