Board index » delphi » Creating Paradox tables at run-time

Creating Paradox tables at run-time

This is a multi-part message in MIME format.

------=_NextPart_000_01BC3902.74D70E20
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I have to create some Paradox tables at run-time and sometimes I get the
error message "Table is busy". If you have any suggestions on how to create
the tables and never get that error I would appreciate your help.

Thanks in advance,
Luis Seabra
jmservi...@mail.telepac.pt
------=_NextPart_000_01BC3902.74D70E20
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head></head><BODY bgcolor=3D"#FFFFFF"><p><font size=3D2 =
color=3D"#000000" face=3D"Arial">I have to create some Paradox tables at =
run-time and sometimes I get the error message &quot;Table is =
busy&quot;. If you have any suggestions on how to create the tables and =
never get that error I would appreciate your help.<br><br>Thanks in =
advance,<br>Luis Seabra<br>jmservi...@mail.telepac.pt</p>
</font></body></html>
------=_NextPart_000_01BC3902.74D70E20--

 

Re:Creating Paradox tables at run-time


In article <01bc38fa$1312a620$95024...@host.telepac.pt>, =?ISO-
8859-1?Q?Jos=E9_de_Mello=2C_SGPS?= <nop16...@mail.telepac.pt> writes

Quote
>I have to create some Paradox tables at run-time and sometimes I get the
>error message "Table is busy". If you have any suggestions on how to create
>the tables and never get that error I would appreciate your help.

>Thanks in advance,
>Luis Seabra
>jmservi...@mail.telepac.pt

I too have to create some Paradox tables at run-time but I have never
experienced any error message. With my application I ensure that it is
compiled with the appropriate TTable component inactive (Active :=
False), and to create it I call the Create method with the table in this
inactive state. My (simplified) code looks something like this:

with Table do { Table: TTable }
begin
    try
        Open;    { See if the table exists by trying to open it }
    except
        on on EDatabaseError do
        begin
            { An error occurred opening the table. Assume it
              doesn't exist, create it, then open it }
            CreateTable;
            Open;
        end;

    end; { end try }

end; { end with }

I am using Delphi V1 and WFW 3.11. Hope the above helps.

Steve Turner
Leeds, England

Re:Creating Paradox tables at run-time


Jos de Mello, SGPS wrote:

Quote

> I have to create some Paradox tables at run-time and sometimes I get
> the error message "Table is busy". If you have any suggestions on how
> to create the tables and never get that error I would appreciate your
> help.

> Thanks in advance,
> Luis Seabra
> jmservi...@mail.telepac.pt

If more than one user is using the table name, you might want to create
a unique table name for each instance ie. tables with the user name.  If
you want the same table structure you can use a batch copy to copy the
basic table layout then name it the user name.
 Hope this helps

  John Brush
  jbr...@fix.net

Re:Creating Paradox tables at run-time


John Brush <jbr...@fix.net> a crit dans l'article
<3339336E.3...@fix.net>...

Quote

> If more than one user is using the table name, you might want to create
> a unique table name for each instance ie. tables with the user name.  If
> you want the same table structure you can use a batch copy to copy the
> basic table layout then name it the user name.

I use this method but have a question:
the batch create the new file without problems but... don't create the
password into the new one!

can anybody...?

thanks in advance,
Thierry.

--

ATR
andriamir...@iname.com
http://andria.home.ml.org

Other Threads