update of long

Hi, how can I update a column of type Long. I only need unlimited text-comments to be updated, no files - within a Visual Basic.net application. I can't find any hint in the MaxDB documentation. I'm looking forward to your answer. Best, Michael Details: CREATE TABLE mytable ( id Integer

Re: update of long

Berlin -Original Message- From: Michael P. [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 1:48 PM To: List Subject: update of long Hi, how can I update a column of type Long. I only need unlimited text-comments to be updated, no files - within a Visual Basic.net application. I

Re: how to choose char (..) unicode in SQL Studio 7.5

in advance. Michael Auer, Wolfgang schrieb: Hi Michael, when your database is an unicode database the 'unicode' item should be displayed. Regards Wolfgang -Original Message- From: Michael P. [mailto:[EMAIL PROTECTED] Sent: Montag, 25. April 2005 15:27 To: List Subject: how to choose char

Re: [MaxDB] How to move a DB-instance from one server to an other?

Hi Jean-Michel, thanks a lot. That's exactly what I was looking for. I can copy a db from the windows testing system to the linux system without any problems now. Best Michael Jean-Michel OLTRA schrieb: bonjour, Le jeudi 28 avril 2005, Michael P. a écrit... dbmcli -d DB1 -u DBM,DBM

how to create a schema

Hi, the example for 'simple hotel db' see http://dev.mysql.com/doc/maxdb/en/eb/327440ba6e701de1000a1550b0/content.htm suggests to create a schema by the sql command CREATE SCHEMA hotel Unfortunately I get the error message Error --- Auto Commit: On, SQL Mode:

Re: order by: 'a, ä, b, c, .., z' instead of 'a, b, c, .., z, ä'?

... thanx a lot. SELECT id, surname, MAPCHAR(LOWER(surname)) AS sort FROM people ORDER BY sort works fine for German 'ä' etc. and 'ß' -- Best -- Michael Marcin P schrieb: Take a look into the Docs and search for MAPCHAR. I use it for sorting with Polish (a,e,c etc.)special letters and everything

Re: ERROR sql command too long

I misinterpreted the error completely. Sorry. It rather referred to a problem with MAPCHAR which has been part of the long sql command (details see next email). Best Michael Michael P. schrieb: Dear group, I receive the error message when I try to apply a certain sql select command

mapchar seems to exceed the available field size

Dear group, how can I solve the following MAPCHAR problem? CREATE TABLE prods ( id Integer NOT NULL DEFAULT SERIAL (1), prod_code Char (10) ASCII, PRIMARY KEY (ID) ) INSERT INTO prods SET id = 1, prod_code = 'ö12345678' INSERT INTO prods SET id = 2, prod_code = 'ö123456789' SELECT

ERROR sql command too long

Dear group, I receive the error message when I try to apply a certain sql select command which is a bit long ERROR General error;-2010 POS(1) Assignment impossible, char value too long When I shorten the sql select command the error vanishes. The max. amount von chars in a sql command seems

MaxDB 7.5.26 + Win98

Hi group, I have following setting: MaxDB 7.5.26 on a linux server and a Win-App on Win98. The odbc driver 'MAXDB_ODBC_SETUP_7_5_00_26.EXE' leads to the following problem. If I configure the system-DSN the ok button is not enabled. Is there any chance to solve the problem, e.g. with an

reading a field of type long

Hi group, I read the contents (e.g. the short text banana) from a field of type long in a vb.net app. I do this by Dim resultL as String resultL = odbcDataReader.GetString(iColL) Strikingly, the debugger shows banana instead of banana (i.e. the closing quote is missing) and resultL.Length

Re: update long + nested Sql Cmd = -8: Execution failed, parse again

to e.oCommandM.Prepare() If this doesn't help please post a zipped ODBC trace. To produce the trace have a look to http://sapdb.2scale.net/moin.cgi/ODBCTrace Regards, Burkhard -Original Message- From: Michael P. [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 13. Juli 2005 04:24 To: List

Re: update long + nested Sql Cmd = -8: Execution failed, parse again

Michael Regards, Burkhard From: Michael P. [mailto:[EMAIL PROTECTED] Sent: Freitag, 15. Juli 2005 17:56 To: Diesing, Burkhard Cc: List Subject: Re: update long + nested Sql Cmd = -8: Execution failed

Re: maxdb and vista?

Dittmar, Daniel schrieb: I have one simple question: is MaxDB (and its components) supported by Windows Vista? MaxDB on Microsoft (tm) Windows (tm) Vista (tm) isn't officially supported yet. You can probably run current MaxDB releases in an XP (tm) -like environment

MaxDB newletter available?

Hi group, is there a MaxDB newsletter available like the MySql newsletter (www.mysql.com/news-and-events/newsletter). The MySql newsletter almost exclusively covers the db MySql and not MaxDB? Cannot find it. -- If not, is there another way to get infos about new features and important bug

book 'MaxDB Admin' by Dr. Ralf Czekalla

Hi Ralf, I was happy to read about your upcoming book MaxDB Admin a few month ago. I found it on the web page http://www.sap-press.de/katalog/buecher/titel/gp/titelID-1127 including the hint that it shall be issued in Nov. 2006. Now I can't find it any more on www.sap-press.de, however,

Re: Error -24987: Paket size too small for answer

Hi, thanks to Bernd for his hint (to use medium_delete) he gave in Oct 2005 :-). It helped me as well. I created too many mediums and got the error Error -24987: Paket size too small for answer. Then I deleted a few mediums with the DBMServer command medium_delete and the error disappeared.

Re: .. WHERE id IN (..1340 ids..) = error

it. Max size allowed is 131072 bytes. Alexei. - Original Message From: Michael P [EMAIL PROTECTED] To: List maxdb@lists.mysql.com Sent: Thursday, September 27, 2007 3:07:34 PM Subject: .. WHERE id IN (..1340 ids..) = error Hi, I use 1340 ids in the IN condition. The result is the error

Re: .. WHERE id IN (..1340 ids..) = error

Becker, Holger schrieb: Michael P wrote: Hi, I use 1340 ids in the IN condition. The result is the error message: #Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed # General error;-1103 POS(1) Too complicated SQL statement Is the number of ids or the length of the sql cmd