| 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 procedure | rdo mail list address | 31 Jul |
| • Re: [win32] USE statement in procedure | rdo mail list address | 31 Jul |
| • Re: [win32] USE statement in procedure | SGreen | 2 Aug |
| • Re: [win32] USE statement in procedure | rdo mail list address | 2 Aug |
| • Re: [win32] USE statement in procedure | SGreen | 2 Aug |
| • Re: [win32] USE statement in procedure | rdo mail list address | 2 Aug |
| • RE: [win32] USE statement in procedure | PF: MySQL | 2 Aug |
| • RE: [win32] USE statement in procedure | rdo mail list address | 2 Aug |
