RE: [aus-dotnet] Codesmith Issue

[Josip Turcic]

Mukesh,

Thank you for your help. I have tried moving the temporary table to local
scope (i.e single # instead of ##) and I get the same error.

Many thanx
Josip


-----Original Message-----
From: Mukesh R Bhakta [mailto:mbhakta@xxxxxxxxxxxxx] 
Sent: Thursday, 24 March 2005 10:04 AM
To: dotnet@xxxxxxxxxxx
Subject: RE: [aus-dotnet] Codesmith Issue

Josip,

Apologise for having -100% knowledge on Codesmith.

But my 2cents worth of MSSQL knowledge - It appears as if the temp table is
going out of context/deleted when connection is closed/terminated. Also have
you tried using a single # instead of ##'s. This moves the table to your
local scope rather than global scope.


-----Original Message-----
From: dotnet-owner@xxxxxxxxxxx [mailto:dotnet-owner@xxxxxxxxxxx]On
Behalf Of Josip Turcic
Sent: Thursday, March 24, 2005 9:23 AM
To: 'dotnet@xxxxxxxxxxx'
Subject: RE: [aus-dotnet] Codesmith Issue


Hi and Good Morning Everybody,

Just having an issue with Codesmith while generating code for stored
procedures that contain temporary tables. When I try to generate code for
these stored procedures I get the following error:

SQL Error: System.Data.SqlClient.SqlException: Invalid object name
'##WhatEverMyTemporaryTableIsCalled'.

I was wondering if anyone knows a way of generating code for these stored
procedures using Codesmith.

Thanks in Advance,
Josip

PS Keep up the good work


"Legal Notice - confidentiality, viruses and opinions - This email and any
files transmitted with it are confidential and solely for the intended
recipient. If you are not the intended recipient please notify the sender
immediately; delete this email from your system; and do not read,
distribute, print, store or copy this email or take any action in reliance
on its contents. KAZ Group Limited ACN 002 124 405 and its related bodies
corporate KAZ Technology Services accept no liability for any damage caused
by any virus transmitted with this email.  Any views or opinions contained
in this email are solely those of the author and do not represent those of
KAZ unless expressly otherwise stated."

---
[This E-mail scanned for viruses by Declude]

_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send "subscribe
dotnet Your Name" in the body of the email to: imailsrv@xxxxxxxxxxx
List managed by: http://www.stanski.com

---
[This E-mail scanned for viruses by Declude]

_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send "subscribe
dotnet Your Name" in the body of the email to: imailsrv@xxxxxxxxxxx
List managed by: http://www.stanski.com
---
[This E-mail scanned for viruses by Declude]

_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send "subscribe dotnet Your Name" in the body of the email to: imailsrv@xxxxxxxxxxx
List managed by: http://www.stanski.com