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 know the statements sent to the kernel in this context, as I do not know the table being part of the statement resulting in that error and as I do not know if this table does have a user-defined primary key or not: You can do a vtrace according to http://sapdb.2scale.net/moin.cgi/VTrace, but change default in 1. and 6. to default order . The search in the resulting file for -4005, look upwards a little bit (to the corresponding part starting with REQUEST:), inspect the SQL, you will find there and then check if the table mentioned has a user-defined primary key (then SYSKEY will NOT exist) or not. If that will not give the idea what happens, send the table definition and the statement resulting in the error to the list. Elke SAP Labs Berlin > Thanks, > Richard Vajsar > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
