Looking at the SMImport suite.

We need to do the following
1.  Import using SQL on paradox without the BDE.
2.  Work concurrently with the BDE when reading paradox tables.

Can SMImport do this?

Kind Regards,

Robert.

Bob,

> Looking at the SMImport suite.
Thanks for your interest but better to ask in our newsgroup or mailing
list

> We need to do the following
> 1.  Import using SQL on paradox without the BDE.
You may read records from Paradox without BDE. But you can't execute
queries. Only open the table to read records (and filter if you need)

> 2.  Work concurrently with the BDE when reading paradox tables.
SMImport opens the Paradox table in readonly mode and another applications
can write to table in same time without any limitations. Only if another
application will open the file in exclusive mode (to pack for example), then
any other tool (including SMImport) will not open the file to read records

> Can SMImport do this?
See my answers above
--
With best regards, Mike Shkolnik
Scalabium Software
http://www.scalabium.com
mshkolnik@scalabium.com

Hi Mike.

1. Can't find the newsgroup for this suite of components.
2. We do need to run SQL on the paradox tables so I think we are a bit lost
here.

Kind Regards,

Robert.

"Mike Shkolnik" <mshkolnik@scalabium.com> wrote in message
news:6C3CB330-9754-4BCB-8478-01683A0C72A0@news.elevatesoft.com...
> Bob,
>
>> Looking at the SMImport suite.
> Thanks for your interest but better to ask in our newsgroup or mailing
> list
>
>> We need to do the following
>> 1.  Import using SQL on paradox without the BDE.
> You may read records from Paradox without BDE. But you can't execute
> queries. Only open the table to read records (and filter if you need)
>
>> 2.  Work concurrently with the BDE when reading paradox tables.
> SMImport opens the Paradox table in readonly mode and another applications
> can write to table in same time without any limitations. Only if another
> application will open the file in exclusive mode (to pack for example),
> then
> any other tool (including SMImport) will not open the file to read records
>
>> Can SMImport do this?
> See my answers above
> --
> With best regards, Mike Shkolnik
> Scalabium Software
> http://www.scalabium.com
> mshkolnik@scalabium.com
>
>

"Bob" <Bob@Bob.com> wrote in message
news:132B045D-DBD3-45F3-9F7D-68939C419956@news.elevatesoft.com...
> Hi Mike.
>
> 1. Can't find the newsgroup for this suite of components.
> 2. We do need to run SQL on the paradox tables so I think we are a bit
> lost here.
>
> Kind Regards,
>
> Robert.
>

news://news.scalabium.com

Hello,

> 1. Can't find the newsgroup for this suite of components.
news://news.scalabium.com

Or use mailing list:
http://groups.yahoo.com/group/SMComponents

> 2. We do need to run SQL on the paradox tables so I think we are a bit
lost
> here.
You have the next options:
- work with ODBC driver. But please note that only Paradox tables v4 don't
require the installed BDE. The Paradox v7 (for example), require the BDE too
to work via ODBC
- you may load the Paradox table into another format (temporary table in
DBISAM, dBase etc) and execute the sql-query on this new engine
- as I remember, TxQuery product allow to execute the queries on any
TDataset. So you may load the Paradox table in any memory TDataset and query
via TxQuery. But personally I never used the TxQuery...
--
With best regards, Mike Shkolnik
Scalabium Software
http://www.scalabium.com
mshkolnik@scalabium.com