Temp Table Problem

From: D Whaley (dwhaley_at_hs-technologies.com)
Date: 11/26/03

  • Next message: D Whaley: "Re: How can I connect to MySQL using ADO ?" 
    Date: Wed, 26 Nov 2003 08:14:44 -0600

    I have a query that creates a temp table on SQL Server 2K. The code resides
    in a DLL.
    Other queries then use this temp table.

    This was actually a unit in a working program that was converted to a DLL.
    Problem is, now in the DLL, the temp table will not persist. When I try to
    use it in other queries, it is gone. Wierd thing is, If I compile the DLL
    into the directory where the source resides, then it works (When running
    from D7 IDE). If I compile it to a different directory, then it doesn't
    work.

    I have tried using Client and Server side cursors, niether works.

  • Next message: D Whaley: "Re: How can I connect to MySQL using ADO ?"

    Relevant Pages

    • Re: Execution detail of Asp.net
      ... page in another temp dir. ... then loads them. ... > compiles the page to a dll in a temp dir, and loads the page (again a ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Distribution of MFC42.dll
      ... >>putting out for several years as a partial solution to DLL hell. ... in which anyone can write to the Windows directories. ... "temp" and recompiled, leaving this z.dll in my temp directory. ... EXE is in temp, DLL is in temp, DLL is in System32: ...
      (microsoft.public.vc.mfc)
    • Re: Temp Table Problem
      ... >I have a query that creates a temp table on SQL Server 2K. ... >This was actually a unit in a working program that was converted to a DLL. ... SQL server has two kinds of temporary tables. ... local temporary tables visible only to the connection that creates them. ...
      (borland.public.delphi.database.ado)
    • Re: newbie Calling DLL in Server2003
      ... You might want to take a look at the ActiveVFP setup.prg at: ... *general temp dir ... I need the DLL to be run as Administrator. ...
      (microsoft.public.fox.programmer.exchange)
    • Re: Elevated Privileges
      ... I hope that wasn't "temp" as in %Temp%? ... .DLL will work if stored elsewhere (my choice would be in the app's ... >the core software that you can not get rid of, ... holes through which malware can escape limited rights etc. ...
      (microsoft.public.windowsxp.security_admin)