Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How Can I close e a temporal table ?

2 posts in FoxPro Last posting was on 2008-09-25 19:50:51.0Z
Hugo Posted on 2008-09-25 19:06:20.0Z
From: "Hugo" <gomh7172@hotmail.com>
Newsgroups: Advantage.FoxPro
Subject: How Can I close e a temporal table ?
Date: Thu, 25 Sep 2008 14:06:20 -0500
Lines: 26
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16669
NNTP-Posting-Host: 189.169.146.222
Message-ID: <48dbddec@solutions.advantagedatabase.com>
X-Trace: 25 Sep 2008 12:52:28 -0700, 189.169.146.222
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!189.169.146.222
Xref: solutions.advantagedatabase.com Advantage.FoxPro:264
Article PK: 1109620

Hi,

I create a temporal table, like this:

select pa.p_id, mu.status, mu.no_result, pa.contrasena, pa.expediente,
mu.registro, mu.tipo_estud, pa.sucursal as p_sucursal, ' ' as expresion,
pa.p_nombre, pa.p_credenci, pa.urgencia, pa.p_sndx, pa.p_descuent
into #QRY_PAC
from paciente pa
inner join muestras mu on pa.p_id=mu.id
where mu.id >= '20061016'and mu.id <= '20070216'

But, When I try to delete the temporal table with the next instruccion:
delete file QRY_PAC.dbf

I Can't to do that, because is used by ADS, then I need first to close the
temporal table (QRY_PAC)

But I don't know, how can I close the temporal table !!

Somebody Can Tell me, How Can I close a temporal table ADS from VFP?

Thanks
Hugo
Cibernetica de México


Mark Wilkins Posted on 2008-09-25 19:50:51.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.FoxPro
References: <48dbddec@solutions.advantagedatabase.com>
Subject: Re: How Can I close e a temporal table ?
Date: Thu, 25 Sep 2008 13:50:51 -0600
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <48dbea25@solutions.advantagedatabase.com>
X-Trace: 25 Sep 2008 13:44:37 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.FoxPro:265
Article PK: 1109616

Hi,

Execute this SQL statement:

drop table #QRY_PAC;

Mark Wilkins
Advantage R&D

"Hugo" <gomh7172@hotmail.com> wrote in message
news:48dbddec@solutions.advantagedatabase.com...
> Hi,
>
> I create a temporal table, like this:
>
> select pa.p_id, mu.status, mu.no_result, pa.contrasena, pa.expediente,
> mu.registro, mu.tipo_estud, pa.sucursal as p_sucursal, ' ' as expresion,
> pa.p_nombre, pa.p_credenci, pa.urgencia, pa.p_sndx, pa.p_descuent
> into #QRY_PAC
> from paciente pa
> inner join muestras mu on pa.p_id=mu.id
> where mu.id >= '20061016'and mu.id <= '20070216'
>
> But, When I try to delete the temporal table with the next instruccion:
> delete file QRY_PAC.dbf
>
> I Can't to do that, because is used by ADS, then I need first to close the
> temporal table (QRY_PAC)
>
> But I don't know, how can I close the temporal table !!
>
> Somebody Can Tell me, How Can I close a temporal table ADS from VFP?
>
> Thanks
> Hugo
> Cibernetica de México