Hi,

I have a memory table called mem1, DBISAM v4, Delphi 6. I want to
empty the memory table mem1.

All the following code is behind a button.

 with mem1 do
 begin
  if mem1.Exists then
   begin
    Close;
    EmptyTable;
    Active:=True;
   end;
 end;
 mem1.Refresh;

 mem1.edit;  // just to see if still exists
 mem1.post;

 with qryDelete do
 begin
  qryDelete.Close;
  SQL.Clear;
  sql.Add('DELETE FROM MEMORY "mem1.dat"');
  qryDelete.ExecSQL;
  qryDelete.Close;
 end;  

The with... code works OK, but the Query stops with
- Error# 11010 table or backup file 'MEMORY' does not exist

The Query is based on working code from DBISAM v3.

I am stumped as to why the with....  code can find the table but the
Query immediately following cannot.

Regards,
Pat

Pat,

The correct SQL syntax for memory tables is:

   DELETE FROM "MEMORY\mem1"


Best regards
--
Fernando Dias
Easygate, Lda

Thanks Fernando

>The correct SQL syntax for memory tables is:
>   DELETE FROM "MEMORY\mem1"

things must have changed from the v3
> DELETE FROM MEMORY "mem1.dat"

while I am here, anybody else have trouble navigating the
elevatesoft.com website? It takes me maybe 2 minutes to load the main
page and the same time for any of the links on the site.

How can I test if its the website itself or some intermediate step?

Regards,
Pat

"Pat" <pat@downunder.com> wrote in message
news:6k0lq3h637ljdv3fbod02n2gp28o1b28kg@4ax.com...
> Thanks Fernando
>
> How can I test if its the website itself or some intermediate step?
>

Hi Pat the sites fine from here in the UK mate. I just heard on sky telly
that yet another underwater fibre optic cable was taken out over in
the Pacific this time, so I guess all the re-routing is hitting you.

The 1st one was near the Suez at the Med end the other was over the
Pacific side. Conspiracy peeps reckon its Arab's knocking out links
to the west. I reckon its peeps who's jobs have gone to India myself.
Rita

Rita,

<< The 1st one was near the Suez at the Med end the other was over the
Pacific side. Conspiracy peeps reckon its Arab's knocking out links to the
west. I reckon its peeps who's jobs have gone to India myself. >>

http://en.wikipedia.org/wiki/Hanlon's_razor

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:6185A962-FCB9-433C-BA91-06736658DC8A@news.elevatesoft.com...
> Rita,
> http://en.wikipedia.org/wiki/Hanlon's_razor
>

Grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
Rita