Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
CraigPardey
Post subject: SQL Editor broken for # tables (4.1.0 GA)  PostPosted: Feb 09, 2006 - 06:09 PM
Veteran Member
Veteran Member


Joined: Jun 24, 2004
Posts: 6

Hi,

The SQL editor is now unable to compile stored procedures for Sybase that have dynamic temporary tables in them. It fails with a syntax error.

Try compiling this:

create procedure fire.temp_proc
as
begin

create table #temp(id int)

end

Craig
 
 View user's profile Send private message  
Reply with quote Back to top
CraigPardey
Post subject:   PostPosted: Feb 09, 2006 - 06:09 PM
Veteran Member
Veteran Member


Joined: Jun 24, 2004
Posts: 6

you might want to remove the 'fire.' prefix ... that is a local user id.
 
 View user's profile Send private message  
Reply with quote Back to top
support-rkalla
Post subject:   PostPosted: Feb 09, 2006 - 07:39 PM
Registered Member
Registered Member


Joined: Jan 06, 2004
Posts: 23855

Can you please post all the information we request in the Posting Guidelines thread at the top of this forum? That will give us some context so that we can determine if this is an installation issue, a configuration problem, or a bug. Thanks.

_________________
Riyad
MyEclipse Support
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits