Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Multi-threaded database on the network

Posted on 1999-06-29
5
Medium Priority
?
133 Views
Last Modified: 2010-04-06
I tried doing a SELECT...UNION to read data from table_1 (in the current app.) and table_2 (table in a different folder), but it's not working.  So I tried doing a query on table_2 (w/ a different session) and then appending it to a temp. table (w/ TBatchMove) in the current app., but I am getting an EDBEngineError:'Attemp to mix objects from different Sessions'.  

Note: The current's app. tables are using the default session and table_2 is accessed using a different session.  

Any ideas/suggestions would be appreciated.
0
Comment
Question by:ocean9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 1385348
hi ocean9,

not checked with the different sessions,
but so is it done

with physically paths
select * from "c:\pd_work\t2.db" union all select * from "c:\pd_work2\ty.db"

or with aliases
select * from ":PD_Worker:t2" union all select * from ":PD_Worker2:ty"

meikl


0
 

Author Comment

by:ocean9
ID: 1385349
Yes, this would work fine on a local machine, but both the applications are on the network, therefore it involves .NET files so this doesn't work.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 1385350
hi ocean9,
you should try to centralize the .NET-file for each application, for each client to a shared network-drive.
meikl
0
 

Expert Comment

by:Byteback
ID: 1385351
I don't know if kretzschmar's solutions works but i though you had to centralize the .net file for all your applications.
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 80 total points
ID: 1385352
preventive lock ;-)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question