Post subject: SQL Editor broken for # tables (4.1.0 GA) Posted: Feb 09, 2006 - 06:09 PM
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
CraigPardey
Post subject:Posted: Feb 09, 2006 - 06:09 PM
Veteran Member
Joined: Jun 24, 2004
Posts: 6
you might want to remove the 'fire.' prefix ... that is a local user id.
support-rkalla
Post subject:Posted: Feb 09, 2006 - 07:39 PM
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.