Hi, I think the difference between SQLStudio and sqlcli is that sqlcli uses prepared statements per default to handle dbprocedures. You can prevent sqlcli from doing it with the option -r. Since the error comes from the database kernel a kernel trace (http://sapdb.2scale.net/moin.cgi/VTrace) would be interesting.
Regards, Marco > -----Original Message----- > From: Robert Klemme [mailto:[EMAIL PROTECTED] > Sent: Montag, 17. Oktober 2005 12:10 > To: Döhr, Markus ICC-H > Cc: maxdb > Subject: Re: DELETE fails from sqlcli but not from SQL Studio > > Any updates / ideas on this issue? View and tables exist and SQL > Studio doesn't complain. Thanks a lot! > > Kind regards > > robert > > 2005/10/7, Robert Klemme <[EMAIL PROTECTED]>: > > 2005/10/7, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]>: > > > > * -4008: Unknown user name/password combination SQLSTATE: > > > > 08004 sqlcli=> > > > > > > Did you just start sqlcli or did you also logon as you > did in SQLStudio? > > > > LOL > > > > I'm sorry, this was a copy and paste error. Here's the > "correct" error message: > > > > sqlcli=> DELETE FROM cr_admin.ag_url > > > WHERE NOT EXISTS ( > > > SELECT urlid > > > FROM cr_admin.url_cleanup > > > WHERE cr_admin.url_cleanup.urlid = cr_admin.ag_url.urlid > > > ) > > > \g > > * -108: Table or index dropped or content deleted SQLSTATE: I0108 > > sqlcli cr=> select count(*) from url_cleanup > > > \g > > * -108: Table or index dropped or content deleted SQLSTATE: I0108 > > sqlcli cr=> select count(*) from URL_CLEANUP > > > \g > > * -108: Table or index dropped or content deleted SQLSTATE: I0108 > > sqlcli cr=> select count(*) from "URL_CLEANUP" > > > \g > > * -108: Table or index dropped or content deleted SQLSTATE: I0108 > > > > SQL Studio tells me there are 738237 records in that view... > > > > Sorry for any inconvenience > > > > Kind regards > > > > robert > > > > -- > 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]
