This is a multi-part message in MIME format.
------=_NextPart_000_007D_01C89A44.1A71AC10
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
Hello,
I would like to use a temp table to store some calculations that i use =
later on.
The problem is that if i create such a table, drop it and then create =
it again during the same session the function is returning error cause =
it still rembers the oid of a first table that was created, it would =
work if i use an execute command , but execute cant be used in FOR =
select loop.
Any ideas?
Michal Kochanowski
------=_NextPart_000_007D_01C89A44.1A71AC10
Content-Type: text/html;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.6000.16609" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I would like to use a temp =
table to store some=20
calculations that i use later on.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>The problem is that if i create =
such a table,=20
drop it and then create it again during the same session =
the function=20
is returning error cause it still rembers the oid of a first table =
that=20
was created, it would work if i use an execute command , but execute =
cant be=20
used in FOR select loop.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any ideas?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Michal Kochanowski</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_007D_01C89A44.1A71AC10--
|
