dbTalk Databases Forums  

Change in temporary tables from 9.01 to 9.02?

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Change in temporary tables from 9.01 to 9.02? in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mark Shapiro
 
Posts: n/a

Default Change in temporary tables from 9.01 to 9.02? - 04-27-2006 , 04:50 PM






The following code has been used in ASA 9.01.1751 without problem. It
leads to another code section that references the temporary table
#Temp:

SELECT hot_id, internal_id INTO #Temp1 FROM Hotline
WHERE call_date >= ' 2006-1-1' AND call_date < '2006-3-31'
AND h_agy_id = 4;
SELECT MAX(hot_id) as hot_id INTO #Temp FROM #Temp1
WHERE internal_id IS NOT NULL
GROUP BY internal_id;

In ASA 9.02.3044, this routine throws an error that #Temp cannot be
found. Is this a change in behavior from 9.01 to 9.02 or is it a bug
that requires a more up-to-date EBF patch? Any advice would be
appreciated.

Mark Shapiro

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.