Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Help me with Browse Table: Error 5073.....

3 posts in Trigger Last posting was on 2004-07-07 16:11:39.0Z
Goran Rakić Posted on 2004-07-01 13:48:10.0Z
From: =?iso-8859-2?Q?Goran_Raki=E6?= <gossa@eltosan.co.yu>
Newsgroups: Advantage.Trigger
Subject: Help me with Browse Table: Error 5073.....
Date: Thu, 1 Jul 2004 15:48:10 +0200
Lines: 629
Organization: ELTOSAN doo
MIME-Version: 1.0
Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_0027_01C45F82.CF9B1190"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2096
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2096
NNTP-Posting-Host: 212.200.133.19
Message-ID: <40e4183d@solutions.advantagedatabase.com>
X-Trace: 1 Jul 2004 07:57:17 -0700, 212.200.133.19
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!212.200.133.19
Xref: solutions.advantagedatabase.com Advantage.Trigger:79
Article PK: 1136149

Hi
Please help me with my first trigger . If you look at next picture you will see simple SQL query which I run from ARC and get OK result
But When I implemented in way in next picture
 
 
 
I get the following error on next picture
 
 
 
Where I made mistake Please help me
 P.S.- I also try example which I downloaded from site and get same error !
 
Goran Rakic
gossa@diskomerc.co.yu
 
 
 

Kako je setovan.gif
Greshka.gif

Jeremy D. Mullin Posted on 2004-07-07 15:11:15.0Z
From: Jeremy D. Mullin <no@email.com>
Newsgroups: Advantage.Trigger
Subject: Re: Help me with Browse Table: Error 5073.....
Date: Wed, 7 Jul 2004 09:11:15 -0600
Message-ID: <MPG.1b55c07ac836123989cf2@solutions.advantagedatabase.com>
References: <40e4183d@solutions.advantagedatabase.com>
Organization: ESI
X-Newsreader: MicroPlanet Gravity v2.30
NNTP-Posting-Host: 198.102.102.187
X-Trace: 7 Jul 2004 09:18:47 -0700, 198.102.102.187
Lines: 38
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.187
Xref: solutions.advantagedatabase.com Advantage.Trigger:80
Article PK: 1136145

Have you tried the trigger tutorial? Does it work for you?

I didn't spend a lot of time inspecting your query, but it looks like
your query doesn't use the __new table, so I'm not sure what you're
trying to accomplish.

If you want to send your database and tables in to
advantage@extendsys.com (attn JD) I could take a closer look.

J.D. Mullin
Advantage R&D

In article <40e4183d@solutions.advantagedatabase.com>,
gossa@eltosan.co.yu says...

> Hi
> Please help me with my first trigger . If you look at next picture you will see simple SQL query which I run from ARC and get OK result
> But When I implemented in way in next picture
>
>
>
>
> I get the following error on next picture
>
>
>
>
> Where I made mistake Please help me
> P.S.- I also try example which I downloaded from site and get same error !
>
> Goran Rakic
> gossa@diskomerc.co.yu
>
>
>
> [image/gif]
>
> [image/gif]
>


francois Posted on 2004-07-07 16:11:39.0Z
Reply-To: "francois" <fransh_@westnet.com.au>
From: "francois" <fransh_@westnet.com.au>
Newsgroups: Advantage.Trigger
References: <40e4183d@solutions.advantagedatabase.com>
Subject: Re: Help me with Browse Table: Error 5073.....
Date: Thu, 8 Jul 2004 00:11:39 +0800
Lines: 694
MIME-Version: 1.0
Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_0023_01C46480.23BFA450"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 202.72.164.126
Message-ID: <40ec227a@solutions.advantagedatabase.com>
X-Trace: 7 Jul 2004 10:19:06 -0700, 202.72.164.126
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!202.72.164.126
Xref: solutions.advantagedatabase.com Advantage.Trigger:81
Article PK: 1136150

Hi Goran
I don't think this query can run in the SQL window.
 
Update PromArt                           // OK
Set field1=a, field2=b                // OK
from Rob_Prom                        // cannot be right, delete this line, use __new as prefix for filedname
where somecondition                // OK
 
also if rpDug relates to the current table Rob_Prom you should refer to __new.rpDug to get its latest value
 
Lastly I do not think that the name of the trigger should have <> characters imbedded.
 
HTH
Francois
"Goran Rakić" <gossa@eltosan.co.yu> wrote in message news:40e4183d@solutions.advantagedatabase.com...
Hi
Please help me with my first trigger . If you look at next picture you will see simple SQL query which I run from ARC and get OK result
But When I implemented in way in next picture
 
 
 
I get the following error on next picture
 
 
 
Where I made mistake Please help me
 P.S.- I also try example which I downloaded from site and get same error !
 
Goran Rakic
gossa@diskomerc.co.yu
 
 
 

Kako je setovan.gif
Greshka.gif