Trigger

THEN. It is not posible to use this statement in the trigger, or what I do incorrect? -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail: [EMAIL PROTECTED] ICQ#:160507472 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com

Limit result, Delphi 7

1 2. I want to connect to SAP DB using Delphi 7. Is there any dbExpress driver for SAP aviable, or if somebody heve some experience whith Delphi 7 vs. SAP. Some examples, tutorials? Best regards, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail: [EMAIL PROTECTED] ICQ

Re: AW: Calling stored procedere

poc (inparam1, inparam2, ?) At least it works for me. If you have [var]char as parameter don't forget to put them in ' '. Hope that helps Peter -Ursprngliche Nachricht- Von: Dusan Kolesar [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 19. Dezember 2003 10:24 An: SAP DB mailing list Betreff

Performance diference

, PRIMARY KEY (ID) ) When I insert row with image bigger than 50kB it takes more than 1 minute. When I insert smaller image then it takes aprox. 1 second. What can be reason of this performance diference? Thank you very much for your advice. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice

Re: Performance diference

I use Delphi7 with ODBC connection. On Mon, 12 Jan 2004 15:01:47 +0100, Schroeder, Alexander [EMAIL PROTECTED] wrote: How do you insert the image (I.e. what client you are using?) Alexander Schrder SAP DB, SAP Labs Berlin -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED

Re: Performance diference

/VTrace) bring a little bit light in the darkness. Kind regards, Holger -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Dienstag, 13. Januar 2004 08:41 To: Becker, Holger Subject: Re: Performance diference On Mon, 12 Jan 2004 17:03:26 +0100, Becker, Holger [EMAIL PROTECTED

Re: Performance diference

directly into DB and make similar query everyting works quick. Even though, thank you very much for all your advices. Dusan On Tue, 13 Jan 2004 10:42:49 +0100, Koetter, Thomas Theodor [EMAIL PROTECTED] wrote: Hi Dusan -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent

Trigger, decode

Hello I have two tables: CREATE TABLE ADMIN.HWMSG ( ID IntegerNOT NULLDEFAULT SERIAL (1), TSTAMP Timestamp, MSGLEN Integer, MSG Varchar (1024) BYTE, MSGTYPE Integer,

Order by and RowNo

obtained an error: Missing delimiter: )and there was ORDER highlighted. Thanks for any idea, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe

Re: Order by and RowNo

Dusan, Will this work for you: SELECT * FROM table WHERE primary-key-column = (select max(primary-key-column) from table) If you use min, you will get the row with the lowest value. best regards, Rick van der Lans -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED

Re: Log

On Tue, 3 Feb 2004 10:40:21 +0100, Heinrich, Tilo [EMAIL PROTECTED] wrote: What database version and which administration tool are you using? Best Regards, Tilo Heinrich SAP Labs Berlin -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 3:04

Re: Order by and RowNo

, Rick van der Lans Thank you, this is very interesting and useful qeury. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com

Insert into more tables

: INSERT [INTO] table_name ... table_name ::= [owner.]identifier There is nothing like table name can be a variabe. Thank you very much. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http

Memory leak on Serv.exe

and then SOAP connection, Used memory on process serv.exe (SAP DB - Communication server) is raising (aprox. 150KB/min (dependent on traffic)) Are there any parameters or configurations settings for Serv.exe ? Or where can be the problem ? regards, Dusan -- Dusan Kolesar Helsinska 19 040 13

Re: Phantom instance? How to remove?

service.exe -r -s fleet service.exe -r -q fleet I have the same result. Dausn -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL

Insert returns Id

in MySql LAST_INSERT_ID () makes this. Thank you for advice. Regards, Dusan. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com

Re: Insert returns Id

On Mon, 08 Mar 2004 17:07:24 +0100, Uwe Schneider [EMAIL PROTECTED] wrote: Hi Dusan, Dusan Kolesar schrieb: Hello, I have one master table: CREATE TABLE LOGFILE ( ID IntegerNOT NULL DEFAULT SERIAL (1), DESCRVarchar (255) ASCII DEFAULT '', PRIMARY KEY

Trigger problem - database crash

Hello, I have one problematic trigger. When I insert into LEVEL table, all database instance crash down. When there is the same trigger but without 2 lines: line 16 and 31 is EXECUTE insertstmt; everything is running and in the debug table TEST I can see all correct insert statemants. Trigger is

Re: Trigger problem - database crash

On Wed, 10 Mar 2004 11:17:11 +0100, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello, I have one problematic trigger. When I insert into LEVEL table, all database instance crash down. When there is the same trigger but without 2 lines: line 16 and 31 is EXECUTE insertstmt

Re: Trigger problem - database crash

to 7.4.03.17. Best Regards Thomas -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. Mrz 2004 14:03 To: Zabach, Elke Cc: SAP DB mailing list Subject: Re: Trigger problem - database crash On Wed, 10 Mar 2004 11:17:11 +0100, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan

Problem with LONG BYTE

Hello, I'm using SapDB 7.4.3 BUILD 031-123-060-910 WinXp. I'm using LONG BYTE column for storing .jpg images in my database. But when I unload LONG values back into the file, the new file is sometimes different like original. When the file size is under about 132k my images are OK. Bu When it is

Update columns with not NULL

Hello, Is it posible to make : update tab1 (col1, col2) values (:myvar1, :myvar2) where id=1; But I want to update only columns where myvarX is not NULL, when the value is NULL I want to let previous value of column. I know when I divide my query : if (myvar1 NULL) then update tab1 (col1)

Varchar BYTE concatenation problem

Hello, I have a problem with Varchar BYTE concatenation. CREATE TABLE ADMIN.TEST ( VC Varchar (50) BYTE ) // CREATE DBPROC TESTVC AS VAR msgVarchar(100) BYTE; byteDistLo Varchar(1) BYTE; byteDistHi Varchar(1) BYTE; BEGIN SET byteDistLo = x'00'; SET byteDistHi =

Re: Varchar BYTE concatenation problem

Thanks a lot, It works. Dusan On Thu, 15 Apr 2004 18:40:40 +0200, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello, I have a problem with Varchar BYTE concatenation. CREATE TABLE ADMIN.TEST ( VC Varchar (50) BYTE ) // CREATE DBPROC TESTVC AS VAR msgVarchar

Re: Autostart MAXDB

Hello, When you set service STARTUP type = automatic, DB instance will be running on Windows startup, but Autolog feature will bee OFF. So my solution is: Using regedit.exe add following key into registry database: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run] SapDb=dbmcli

Sort tree data Preorder

Hello, This is more SQL problem then SAP DB problem but may bee somebody can help me. Or sombody knows links where solved this problem. I have a table ADDRESS. Data represent tree structure. PARENT_ID points into record of the same table. CREATE TABLE ADDRESS ( ID Integer NOT

Re: [SPAM] - cant remove failed instance - Found word(s) remove list in the Text body.

: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http

Re: Again ignore trigger after update

Hello, I think that statement inside trigger tr_upd_atab_1 is incorrect: update dba.atab_2 set t2 = t2 + :val2, t3 = t3 + :val3 where t1 = 40 ignore trigger; I have searched for it in documentation but I didn't found ignore trigger statement. I think there is no way how to ignore trigger just

Re: Again ignore trigger after update

Inside your trigger: First get the flag value from control_table If flag = 0 then . trigger body... End if; ... so, if flag 0, trigger is fired, but nothing will happen... Just by 2c. Hope this help Andy -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED

Re: Sort tree data Preorder

Hello Elke, Thank you very much, for your advice. It is working very nice for me. Dusan On Fri, 21 May 2004 09:13:10 +0200, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello, This is more SQL problem then SAP DB problem but may bee somebody can help me. Or sombody knows links

Re: AW: Combine cursors

On Thu, 27 May 2004 15:50:58 +0200, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello Elke, When I try: DECLARE C1 CURSOR FOR SELECT * FROM ADDRESS FOR REUSE // DECLARE C2 CURSOR FOR WITH RECURSIVE PX2 (ID, PARENT_ID, NAME, FOLGE, TREELEVEL) AS ( SELECT ID, PARENT_ID

Re: AW: AW: AW: AW: AW: Combine cursors

-nos Y X can be found in the odd level-nos can be seen. One level will add 2 additional records, the other level will add 14. Therefore the check should be not too hard. Elke SAP Labs Berlin -Ursprngliche Nachricht- Von: Dusan Kolesar [mailto:[EMAIL PROTECTED] Gesendet

Re: AW: AW: AW: AW: AW: AW: Combine cursors

2004 09:23:02 +0200, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello Elke, you are absolutly right. There is a endless loop. But I don't see eny reason for it. My result is OK into correct treelevel (I have nodes in levels 1,2,3). And then there is added level 4 the same as level 2

Linux installation problem

-- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolovan antivrovm programom NOD32 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cursor and dynamic statement

. Regards Dusan. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolovan antivrovm programom NOD32 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Linux installation problem

Thank you very much, it works. Regards Dusan. On Mon, 21 Jun 2004 14:22:57 +0200, Timo Denis [EMAIL PROTECTED] wrote: Try export LD_ASSUME_KERNEL=2.2.5 and afterwards x_server start and dbmcli stuff! Regads, Timo Dusan Kolesar wrote: Hello, I'm running SapDb 7.4.3.32 under WinXp. Next I want

Trouble with calling dbproc in the trigger

() FROM ADMIN.DUAL; /* some insert, update, delete, select statement */ ) and when I execute my insert again everything is OK. Is it bug, or am I doing something wrong? Thank for your help and support. Regards, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED

Dynamic statemant and Fetch cursor

ROWNO = 1'; EXECUTE stmt; FETCH INTO :id; INSERT TEST SET ID=:id; END; But I get an error : Unknown result table on the fetch command. Don't you know any solution for my problem ? Thank you for help. Regards, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL

Re: AW: Timestamp Trigger

Hello Tobias, Try this: CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE EXECUTE ( IF (OLD.DATUM NEW.DATUM) THEN RETURN; UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE TEST.ID=:NEW.ID; ) and when you make UPDATE don't update tstamp coluumn. Regards, Dusan. On Tue, 13 Jul 2004 09:45:06

Port configuration

Hello, I have one SAP DB 7.4.3 installation my computer. Is it posible to configure 2 (or more) DB instances, to listen on 2 (or more) TCP/IP ports? I'm using Windows OS and I'm connecting via ODBC. If there is no such possibility, how can I recognise which TCP/IP packet belongs to which DB

Re: AW: Join performance

if this would help. The syntax is select /*+ordered */ logfile.*, car.name from logfile outer join car on logfile.car_id = car.id Kind regards Holger -Ursprngliche Nachricht- Von: Dusan Kolesar [mailto:[EMAIL PROTECTED] Gesendet: Montag, 19. Juli 2004 16:21 An: SAP DB mailing list

Automatic DB start

. Is any way to start DB witout publishing DB name and password and Autosave Log set ON? Thank you very much. Regards, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -=x=- Skontrolovan antivrovm programom NOD32 -- MaxDB Discussion Mailing

Re: AW: Daylight Saving Time

problem is, that my client program inserts into my table values directly from GPS device and this data includes UTC time. So I need to correct it into normal (kitchenclock) time. Even thought thank you for your response. Dusan Kolesar -=x=- Skontrolovan antivrovm programom NOD32 -- MaxDB Discussion

Recovery problem

instance after restoring an error occurs. The restoring function works only when I create a new DB instance and in the Install Wizard (last installation step) I choose install instance for recovery. What am I doing bad ?? Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL

Re: show tables / describe table

to MAXDB and want to know is there any function in MAXDB like MySQL to show all tables in a database and describe table in a database. Mysql show tables; Mysql describe table. Thanks in Advance. MAXDB PHP -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ

Query sometimes works and sometimes not.

, same conditions, same database schema everything runs OK. Can you help me please, what is reason for this error. Thank you very much. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http

Generate result in the range

, Desc1 Is it posible to generate numbers between some values? Thank you for your support. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http

General error;-9205

, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Change column order

Hello list, is it posible to change column order in the table ? I want to add some column into the table, but not to the end. Is it posible in SapDb, or I must drop table firs and recreate it with correct order? Thank you, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail

Error -9205

so they can trace and rectify the error. I know, this example is not very usefull, but my real DB schema is much more complicated. So I need such a chema: 2 tables with ref.integrity with triggers and stored procedure call. How to aviod this error? Is it some bug? Thank you, Dusan. -- Dusan

SQL studio problem

Hello list, I'm using MaxDb 7.6.0.16 on WinXP Home vith SP2. I have installed GUI SQL Studio (maxdb-sqlstudio-setup-7_6_00-106556.exe). Before I installed new version I uninstalled my old SQL studio 7.4 first. My installation was succesfull (no error occured). When I start SQL Studio and when I

Re: SQL studio problem

On Wed, 30 Nov 2005 11:12:31 +0100, Koetter, Thomas Theodor [EMAIL PROTECTED] wrote: Hello Dusan -Original Message- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. November 2005 10:45 To: SAP DB mailing list Subject: SQL studio problem Hello list, I'm using MaxDb

INFO_STATE table does not exist

Hello list MaxDB: W32/INTEL 7.6.00 Build 016-123-109-428 OS: WinXP Home, SP2 Where is DOMAIN.INFO_STATE table? I have used version 7.4.3.32 before and there was such a table. Or is any other way how to read this informations using ODBC? Now the only way I have found to obtain these

Re: AW: INFO_STATE table does not exist

, Command Monitoring AS CMND_MON, Kernel Trace AS KERNEL_TRACE FROM INFO_STATE Can you help me where to find them? Dusan On Thu, 05 Jan 2006 09:09:33 +0100, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello list MaxDB: W32/INTEL 7.6.00 Build 016-123-109-428 OS: WinXP Home

Re: AW: INFO_STATE table does not exist

, MONITOR_TIME, MONITOR_SELECTIVITY, MONITOR_ROWNO parameters but none seems to be right Database Trace: Off SYSINFO.ACTIVECONFIGURATION (Parameter TRACE_*) - there are 79 such params Dusan On Thu, 05 Jan 2006 11:45:44 +0100, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote

Trigger fireing

Hello list, I'm using MaxDb 7.6.00.16 on WinXP Home, SP2. I find that UPDATE trigger fires always when I call UPDATE, even though no value is changed. In version SapDb 7.4.3.32 (I heve used before) when UPDATE statement didn't change any value then no update trigger fired. Is it a new feature

How to define 2 FK into 1 table

) Referential constraint not allowed Table Address has 2 foreign keys referencing into 1 table (delete rule is SET NULL). I don't understand reason why I can't define such FK. It is posible only with delete rule is RESTRICT. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL

How to define 2 FK into 1 table

Hello I want to define folowing DB structure: CREATE TABLE SYSUSER ( ID Integer NOT NULL DEFAULT SERIAL, TSTAMP Timestamp NOT NULL DEFAULT TIMESTAMP, NAME Varchar(30) ASCII NOT NULL, PASSWORD Varchar(30) ASCII NOT NULL, PRIMARY KEY (ID) ) //

Database freezing MaxDb7.6

of different options to trace, so I'm confused what to trace. Or should I switch on all? The important think is, that before we have migrated from SapDb v7.4.6.32 on WinXp, no such freezing occured. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail

Re: Data Volume Size

where this message has been displayed or from any network to which such computer is connected. Any use or disclosure of this message or its contents/attachments by anyone other than the intended recipient(s) is expressly prohibited and could result in civil or criminal liability. -- Dusan

Re: Database freezing MaxDb7.6

Hello Markus So, the database is waiting for a lock release. But what can cause this datatbase state ? Can you advice me some DB parameters to change ? Are there some parameters to unlock tables automaticly ? Or should I change something in my procedure and trigger code ? Dusan Kolesar Helsinska

Re: AW: Database freezing MaxDb7.6

you for your support. Regards, Dusan Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 On Wed, 15 Mar 2006 13:16:57 +0100, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello Markus So

Re: AW: Database freezing MaxDb7.6

mode ? Transaction ends when select / insert statement ends, or when whole procedure / trigger ends ? Thannks for help -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 On Mon, 20 Mar 2006 08:50:05 +0100

Re: Recovery problem

This will recover and initialize the DB. Greetz, -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http

Conversion Varchar ASCII - Varchar BYTE

Hello, I'm using MaxDb 7.6.0.16 on WinXp HE + SP2. I need to convert Varchar ASCII variabl into Varchar BYTE inside stored procedure. Can you advice how to do this ?? Thanks, Dusan -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:

Re: Conversion Varchar ASCII - Varchar BYTE

Hello Elke, thank you very much, it works. Dusan On Fri, 09 Jun 2006 08:17:19 +0200, Zabach, Elke [EMAIL PROTECTED] wrote: Dusan Kolesar wrote: Hello, I'm using MaxDb 7.6.0.16 on WinXp HE + SP2. I need to convert Varchar ASCII variabl into Varchar BYTE inside stored procedure. Can you

Conversion Varchar BYTE - Varchar ASCII

this ?? -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Conversion Varchar BYTE - Varchar ASCII

On Fri, 11 Aug 2006 10:56:18 +0200, Zabach, Elke [EMAIL PROTECTED] wrote: My database parameters are: _UNICODE NO DEFAULT_CODE ASCII Dusan Kolesar wrote: Hello Elke, It is not working. When I do SET msgAscii = ASCII (msgByte); Error --- Integrity

Database migration 7.6.00.34 to 7.6.00.16

Hello, I'm using MaxDb 7.6.00.16 and 7.6.00.34 on WindowsXp HE SP2. I need to migrate database instance from 7.6.00.32 to 7.6.00.16 BackUp in 7.6.00.32 and restore database in 7.6.00.16 doesn't work. Any suggestions ? Thanks Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail

Dinamic statement in trigger

in trigger code ? Thank you for your support, Dusan. -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe

Re: Dinamic statement in trigger

On Mon, 15 Jan 2007 08:27:22 +0100, Anhaus, Thomas [EMAIL PROTECTED] wrote: Dusan Kolesar wrote : Hello, is it possible to access trigger variables in dinamic sql statement: CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE ( VAR EVENTTABLEID FIXED(10); COLNAME

Re: Dinamic statement in trigger

On Mon, 15 Jan 2007 14:53:14 +0100, Anhaus, Thomas [EMAIL PROTECTED] wrote: Dusan Kolesar wrote : Hello, is it possible to access trigger variables in dinamic sql statement: CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE ( VAR EVENTTABLEID FIXED(10

Database hangs, deadlock detection

for support Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL

String to number conversion

Hello, I want to convert Varchar ASCII column to Integer data type. When I'm using NUM () function and my string column contains characters that cannot be interpreted as a numeric value statement returns me an error. Is it possible to convert chracters to numbers, while entries that cannot

Re: String to number conversion

Hello, thank you very much. It is working correctly. Nice solution. Dusan On Tue, 19 Jun 2007 20:03:06 +0200, Lukasz Misztal [EMAIL PROTECTED] wrote: Dusan, try to create own function, for basic example: CREATE FUNCTION GETASNUMERIC (s1 VARCHAR) RETURNS NUMERIC AS IF UPPER(s1) = LOWER(s1)

Row too long (-2000)

you very much for support. Regards, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http

Re: Row too long (-2000)

Hello Elke, You're right, on 7.6.0.37 it works correctly. Thank you, Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 On Tue, 24 Jul 2007 11:53:55 +0200, Zietlow, Elke [EMAIL PROTECTED

INSERT .. UPDATE DUPLICATES - no trigger is fired

in the LOG table (with text insert). Thank you for support. Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail primary : [EMAIL PROTECTED] e-mail alternative : [EMAIL PROTECTED] ICQ# : 160507424 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb