BorlandTalk.com

Cengis · Guest

hello,

i'm currently writing an internal software to manage informations about
yours clients like computers / softwares installed, updates planning etc ...

all client informations are linked from another database (from the
software we use for billing etc ...: multidevis) in the access database

clients.mdb mydatabase.mdb

Cengis · Guest

Brian Bushay TeamB wrote:

Andrew · Guest

It can be done, although you will suffer a performance hit. I've written a
simple system that queries an Ingress database, linking some tables from
that into an Access database. I've had to use ADO as MS SQL server doesn't
seem to allow linked tables from an ODBC source (I may be wrong on this, but
couldn't find any documentation)
The whole thing runs as a service on at Network server and typically takes a
few seconds to collect records prior to producing a report (using
ReportBuilder). The users seem to have no hassles with the delay, but it
would be *much* quicker if all the data was in one database.
All you have to do is create a linked table in a "master database" (either
using MS Access, or ADOX calls). Then query it as you would any other table.
Cheers,
Andrew

"Cengis" <cengis.kocaurlu (AT) prodiag (DOT) fr> wrote

Cengis · Guest

it's the method i already use :/

Andrew wrote:

Cengis · Guest

i'll try but i think it will be lot of pain to make all my queries
valid, i use lot of 'jointure' (i don't know the word in english, when
you use ... inner/left/right join ...) and if i add databasename each
time ..
well

is it possible to specify an odbc data link in a query
(querying another odbc datalink or jet ?)
exemple:
odbc -> ClientDB -> my client database pathclient.mdb
odbc -> MyDatabase -> my app database path MyBase.mdb

and the query:
Select * from (ClientDB:clientinfos as ci left join Clients_softwares as
cs on ci.clientcode = cs.clientcode)

ClientDB:clientinfos -> i see somewhere that you can specify an extern
database with a tablename formated like this but don't know if it work
with odbc (or other) link

Best regards
Cengis.

Brian Bushay TeamB wrote:

Cengis · Guest

Brian Bushay TeamB wrote:

Cengis · Guest

I recently heard about ADO Shaping
(http://delphi.about.com/library/weekly/aa071001c.htm at the bottom of
the page ) and i think it might be useful to solve my problem
but i haven't find any beginner friendly documentation, i don't know how
it work, just it can help me to 'JOIN' data from different datasource
(i've think about use a adoconnection for my main database and another
for the client.mdb database)

any idea / tutorial would be appreciated

Cengis.

Brian Bushay TeamB wrote:

Cengis · Guest

ok :(

Brian Bushay TeamB wrote:

Viatcheslav V. Vassiliev · Guest

Shaping is not what you need. Shaping allows to have both master and details
data in one recordset.

I think you need to execute JOIN SQL query and specify db location in query.
Access allow this. For example, you could do:

SELECT * FROM sometable IN "c:db.mdb"

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Cengis" <cengis.kocaurlu (AT) prodiag (DOT) fr> ???????/???????? ? ???????? ?????????:
news:41458bc9$1 (AT) newsgroups (DOT) borland.com...