I have used the Data Shape commands successuflly in the past, but am confused by this error. I am trying to create a parent/child/grandchild relationship for a report I am writing. Initially I used the same temp table names for #Hours & #Days, but changed the temp table names when I first received the error. I now have #Hours, #Hours1, and #Hours2...same for #Days. Here is the error

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Invalid object name '#hours1'.
/dtreference/inquiry/bah-byshift.asp, line 27

PLEASE HELP!!!!


Sincerely,

BAHill
[email protected]

Are you trying to work with temp tables thru a standard asp DB connection and making several calls? I don't believe you can do that. That may explain why it says the object is invalid.

If you are doing some complex data operations it would seem to be advantageous to wrap it up inside of a stored procedure and make a single call to it from ASP. I haven't worked with Data Shape commands so I may be wrong with this suggestion.

Peter
------------------------------------------------------
Work smarter, not harder.

Typically I use 2-3 stored procedures to call the data I require. Each level of the report will be more detailed, starting with a general overview then progressing down to hourly details. Because of the nature of the query, I must use the temp table in each of the 3 queries. Each query is a parent/child/grandchild query...

Thanks,

BAHill