RE: [aus-dotnet] Codesmith Issue

[tuslerd]

Best option is not to use temporary tables for this. Create a dummy table
and use that instead.

Technical explanation provided in another forum:
"The DataAdapter Configuration Wizard is calling
DataAdapter.FillSchema under the covers to retrieve schema
information about the procedure without actually executing it.  
However, since the temporary table does not exist without
executing the stored procedure, the call throws the error you
described.
[snip]
David Sceppa
Microsoft"

Regards,

Dylan Tusler.

-----Original Message-----
From: Josip Turcic [mailto:Josip.Turcic@xxxxxxxxxxxxx]
Sent: Thursday, 24 March 2005 8: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


 



===================================================
If you would like to find out the latest news from Maroochy Shire
Council, why not visit our media releases web page at 
http://www.maroochy.qld.gov.au/projects/media.cfm . 
To receive the latest Council news at your desktop,
you can subscribe, for free, to Maroochy e-News.
Just visit our website at www.maroochy.qld.gov.au to find out how.
===================================================
This email and any files transmitted with it are intended solely for
the use of the individual or entity to whom they are addressed. 
Maroochy Shire Council is a government organisation and is subject
to Freedom of Information legislation. You must assume that any
material sent to Maroochy Shire Council may be accessible by
persons other than the intended recipient.
The contents of this message may express views and opinions
not necessarily shared by Maroochy Shire Council.
===================================================
mscmail4.3

---
[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