List:MySQL on Win32« Previous MessageNext Message »
From:rdo mail list address Date:August 2 2004 3:02pm
Subject:Re: [win32] USE statement in procedure
View as plain text  
At 10:45 AM 8/2/2004 -0400, SGreen@stripped wrote:
>Thank you for finding that in the docs for me. I still believe your 
>problem resides in the fact that you are creating a link to a table in one 
>context then changing to another context within the same procedure. I 
>would suggest you try moving the USE statement to the top of the procedure 
>or avoid using it completely by using fully qualified table names.

I think the best course is, as you suggest, to not have the USE statement
at all in a stored procedure, and instead reference the fully qualified
table names.

rdo
Thread
[win32] USE statement in procedurerdo mail list address31 Jul
  • Re: [win32] USE statement in procedurerdo mail list address31 Jul
  • Re: [win32] USE statement in procedureSGreen2 Aug
  • Re: [win32] USE statement in procedurerdo mail list address2 Aug
    • Re: [win32] USE statement in procedureSGreen2 Aug
    • Re: [win32] USE statement in procedurerdo mail list address2 Aug
RE: [win32] USE statement in procedurePF: MySQL2 Aug
  • RE: [win32] USE statement in procedurerdo mail list address2 Aug