Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Third Party Announcements » View Thread |
Messages 1 to 5 of 5 total |
Importing from Paradox |
Mon, Aug 6 2007 3:10 AM | Permanent Link |
"Bob" | 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. |
Tue, Aug 7 2007 4:51 PM | Permanent Link |
"Mike Shkolnik" | 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 |
Thu, Aug 9 2007 7:39 PM | Permanent Link |
"Bob" | 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 > > |
Fri, Aug 10 2007 5:01 AM | Permanent Link |
"Frans van Daalen" | "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 |
Fri, Aug 10 2007 4:01 PM | Permanent Link |
"Mike Shkolnik" | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |