Dear Eryk, thank you for your kind replies and knowledge.

Maybe I am not understanding correctly.  Maybe I need to install the SERVER version of
DBISAM on our LinuxRH and then figure out how to get the same data being fed into our
MySQL database FROM same LinuxRH MySQL database INTO the DBISAM Server.

Is this maybe a different approach, or would the one asked and requested advice with Mr.
Lee more practical?

Thank you, both.

Any and all suggestions or threads that you could point me in for clarification or a
solution that someone has already completed would be great.

Cordially,

Jon Alexander




Jon Alexander <jonalexander370@earthlink.net> wrote:

Thank you Jason,

As I understand, an sql statement that exports the data to the server hard drive, in a
format such as XML.

Then can dbisam or some third party component import over the web via IP same data
directly into DBISAM?

Am I on the right track in this thinking?

Please advise.

Thank you.

Cordially,

Jon Alexander





Jason Lee <computerguy@wavecable.com> wrote:

Jon,

Typically, you cannot select records from one database server (e.g.
MySQL) into a destination table of a different database server (e.g.
DBISAM table) all from within an SQL statement or script.

Your solution would involve something like:

a) select MySQL records using SQL in MySQL and save them to an
intermediate format that can then be imported into a DBISAM database

b) select MySQL records using SQL in Delphi (using the MySQL direct
access components or ODBC), then iterate the record set adding the
necessary records to a DBISAM database table (using DBISAM's components)

c) maybe MySQL has a "reverse engineer" feature like DBISAM that can
include the data. the result would be an SQL script that could then be
run in DBISAM to re-create the table(s)

d) combination of all, some, or none of the above

~Jason Lee

Jon Alexander wrote:
> Thank you all for your kind assistance.
>
> I apologize for improperly stating my request.
>
> I have a Dedicated LinuxRH server, and on that LinuxRH server is MySQL installed, and in
> the SQL database are tables of data.
>
> I am requesting help and assistance and any code snippets that may assist me in connecting
> a DBISAM Memory Table to retrieve that same data.
>
> The data would be requested by a Delphi Desktop application, into a DBISAM database memory
> table FROM a server side SQL database on our LinuxRH server.
>
> Attached is a screen shot of the data on the LinuxRH SQL server.
>
> Any and all advice would be most greatly appreciated.
>
> Cordially,
>
> Jon Alexander
> jonalexander370@earthlink.net
>
>
> "J. Lee" <computerguy@wavecable.com> wrote:
>
> Eryk,
>
> Sorry, I was trying to help Jon. I know I am very correct on the
> statements I made, since I have been a very active developer using
> DBISAM since v1
>
> I just switched to Thunderbird and am still getting used to it from the
> horrible OE, so I apologize if it appears I am replying to you.
>
> If I may be presumptuous for a moment, it appears our friend Jon has
> been 'elevated' (no pun intended) to IT person in charge of taking over
> a project using DBISAM. How can I guess this (it is just a mere guess,
> btw)? The nature and content of the questions he asked.
>
> Warmest regards,
>
> Jason Lee
>
>
> Eryk Bottomley wrote:
>
>>J,
>>
>>
>>>1) You can run the DBISAM database server on a Windows or Linux based
>>>computer.
>>
>>
>>Correct. Subject to the Linux distribution in question being one that
>>Borland Kylix V3 supports.
>>
>>
>>>2) The DBISAM database server program contains the DBISAM database engine
>>
>>
>>Correct.
>>
>>
>>>3) The DBISAM database engine reads DBISAM database files (usually
>>>located on the same machine as the running engine)
>>
>>
>>Correct.
>>
>>
>>>4) For purposes of simplicity, the DBISAM database engine is the only
>>>program that can read DBISAM database files
>>
>>
>>Correct, generally speaking.
>>
>>
>>>5) You can compile the DBISAM database engine into your programs so
>>>that they can read DBISAM database files directly (shared-file mode)
>>>or make requests to a DBISAM database server program (client/server),
>>>which processes the request and returns results back to the requesting
>>>program
>>
>>
>>Correct.
>>
>>
>>>6) You can directly view DBISAM database tables using the TDBISAMTable
>>>component or you can issue SQL commands using a TDBISAMQuery component.
>>
>>
>>Correct.
>>
>>
>>>That is for starter....I hope it helps you a little. Come back if you
>>>have more questions.
>>
>>
>>I did not have a question in the first place. 'You' have the question
>>(apparently) and I was attempting to define what it was/is.
>>
>>Eryk
>
>

Jon,

That could be one way, sure (for DBISAM it would be better to replace
the XML with delimited ASCII text). If this were my project I'd need to
know a lot more to make better decisions:

1. Why the need to convert anyway? In other words, is MySQL not meeting
some specific requirement?
2. How frequently the conversion is done. Do we want to automate this
process to the point of being an online feature (MySQL data is converted
in real-time because of some need for instantaneous availability) or
will infrequent batch processes handle the job?
3. Why not use Delphi to write a program that accesses the MySQL data
directly as it is on the Linux server?
4. Is the final objective to end up with a DBISAM based system, which
would be a full conversion or to end up with a hybrid MySQL-DBISAM solution?


Jon Alexander wrote:
> Thank you Jason,
>
> As I understand, an sql statement that exports the data to the server hard drive, in a
> format such as XML.
>
> Then can dbisam or some third party component import over the web via IP same data
> directly into DBISAM?
>
> Am I on the right track in this thinking?
>
> Please advise.
>
> Thank you.
>
> Cordially,
>
> Jon Alexander

Dear Mr. Lee,

I actually would prefer NOT to convert BUT to directly access the same data DIRECTLY from
the LinuxRH server MySQL database INTO a Delphi desktop application.

The data is already being fed and is REAL TIME currency data,  FOREX.

I would love to write a Delphi desktop app that accesses the SQL data directly.

The desired end result is just a Delphi app using a DBISAM memory table to store the data
ONLY while the app is running.


Any ideas would be most greatly appreciated.

Jon Alexander




Jason Lee <computerguy@wavecable.com> wrote:

Jon,

That could be one way, sure (for DBISAM it would be better to replace
the XML with delimited ASCII text). If this were my project I'd need to
know a lot more to make better decisions:

1. Why the need to convert anyway? In other words, is MySQL not meeting
some specific requirement?
2. How frequently the conversion is done. Do we want to automate this
process to the point of being an online feature (MySQL data is converted
in real-time because of some need for instantaneous availability) or
will infrequent batch processes handle the job?
3. Why not use Delphi to write a program that accesses the MySQL data
directly as it is on the Linux server?
4. Is the final objective to end up with a DBISAM based system, which
would be a full conversion or to end up with a hybrid MySQL-DBISAM solution?


Jon Alexander wrote:
> Thank you Jason,
>
> As I understand, an sql statement that exports the data to the server hard drive, in a
> format such as XML.
>
> Then can dbisam or some third party component import over the web via IP same data
> directly into DBISAM?
>
> Am I on the right track in this thinking?
>
> Please advise.
>
> Thank you.
>
> Cordially,
>
> Jon Alexander

Dear Mr. Bottomley,

In reply to your "help":

1)  THERE IS NO SUCH THING AS LINUX SQL
A - I guess you have never heard of MySQL.

2) same answer as 1

3) As mentioned orignally, this is a DELPHI application using the DBISAM VCL, within
Object Pascal,
I am PRETTY sure there is a way to access the MYSQL data directly to bring into a DBISAM
table.

4) The OnTimer Event was suggested to me by Mr. Tim Young, and I was mearly asking for
clarification.

IN ADDITION, all I needed help was, TO JUST BE POINTED in the correct direction from
SOMEONE that
has been able to directly access data stored on a server side SQL database on a LinuxRH,
and I already
have corporate approval for purchase should I be able to demonstrate this using the trial
version of the
DBISAM VCL.

But it seems, that all the responses from YOU, are mearly words of criticism and nothing
HELPFUL in
what way so ever.

Jon


Eryk Bottomley <no@way.com> wrote:

Jon,

> Can someone please help me to connect my dbisam table to a SQL server.

Unfortunately your question is far too vauge to answer. The problems
include:

1) "Linux SQL connectivity to dbisam" - there is no such thing as "Linux
SQL"

2) "...my dbisam table to a SQL server." - WHAT SQL server? The term
"SQL Server" in isolation typically means "Microsoft SQL Server" but
since that doesn't run on Linux that cannot be what you intend here.

3) Database engines, as a general rule, are not designed to access data
in alien formats so it is probable that whatever you mean by "SQL
Server" has no capability to read DBISAM files interactively.

4) TTimers have absolutely nothing to do with database operations per se
so it is impossible to guess why someone may have instructed you to use one.

Eryk

Jon,

> 1)  THERE IS NO SUCH THING AS LINUX SQL
> A - I guess you have never heard of MySQL.

I thing your terminology is not common here try MySQLDAC, google it

> 3) As mentioned orignally, this is a DELPHI application using the DBISAM
> VCL, within
> Object Pascal,
> I am PRETTY sure there is a way to access the MYSQL data directly to bring
> into a DBISAM
> table.

Doable

HTH,


Surjanto

Jon,

My love for DBISAM aside, it appears that all you need are some data
access components for your Delphi to connect directly to the MySQL
server and retrieve data. You don't necessarily have to retrieve that
data into local tables of a different database (e.g. DBISAM memory table).

As Surjanto pointed out, MySQLDAC is one solution that may interest you.
If typical, these components can be placed into your project and would
allow you to create queries of the MySQL database as well as view tables
directly, in a dbgrid for example.

Of course nothing would make me happier if you also bought a DBISAM
license

~Jason Lee


Jon Alexander wrote:
> Dear Mr. Lee,
>
> I actually would prefer NOT to convert BUT to directly access the same data DIRECTLY from
> the LinuxRH server MySQL database INTO a Delphi desktop application.
>
> The data is already being fed and is REAL TIME currency data,  FOREX.
>
> I would love to write a Delphi desktop app that accesses the SQL data directly.
>
> The desired end result is just a Delphi app using a DBISAM memory table to store the data
> ONLY while the app is running.
>
>
> Any ideas would be most greatly appreciated.
>
> Jon Alexander

Jon,

<< The data would be requested by a Delphi Desktop application, into a
DBISAM database memory table FROM a server side SQL database on our LinuxRH
server. >>

Just issue the proper SQL query to the MySQL server using any
TDataSet-descendant query component that can access MySQL, and then copy the
data from the MySQL TDataset-descendant query component using the following
code:

http://www.elevatesoft.com/faqt_22.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Jon,

> 1)  THERE IS NO SUCH THING AS LINUX SQL
> A - I guess you have never heard of MySQL.

Sure I have. Also PostGRES SQL, Oracle, FireBird, InterBase and half a
dozen other SQL compliant database engines that are capable of running
on Linux. There is not, however, any specific product that can be
inferred from the term "Linux SQL".

MySQL is only "Linux SQL" in the same sense as Quake 3 is "Windows Game"
....instructions for winning at Solitaire would not help much in Quake I
think.

> 3) As mentioned orignally, this is a DELPHI application using the DBISAM VCL, within
> Object Pascal,
> I am PRETTY sure there is a way to access the MYSQL data directly to bring into a DBISAM
> table.

Of course there is. ODBC is probably the most common and simplest
approach. We were not discussing MySQL however we were discussing the
mythological "Linux SQL" last time I read this thread.

> 4) The OnTimer Event was suggested to me by Mr. Tim Young, and I was mearly asking for
> clarification.

Clarification of what? How to connect to a "Linux SQL" database using a
TTimer component? I'd like some clarification there myself - I'm damned
if I can get a TTimer to do anything at all besides fire timed events.

> IN ADDITION, all I needed help was, TO JUST BE POINTED in the correct direction from
> SOMEONE that

I genuinely had not the faintest idea what you were trying to do so I
could not 'point' you in any direction other than back to whoever gave
you the assignment for clarification.

> have corporate approval for purchase should I be able to demonstrate this using the trial
> version of the DBISAM VCL.

Fine, however I must concur with the others that it seems from your
sunsequent explanations that you don't actually need DBISAM at all and
could get by with either a MySQL result set, a TClientDataSet or one of
a number of free "TMemoryTable" type components.

> But it seems, that all the responses from YOU, are mearly words of criticism and nothing
> HELPFUL in what way so ever.

Sorry if you have that impression. It seems to me that unless someone
asked you the questions that I did your problem would have remained
impossible to address. For the record, I actually have done almost
exactly what you are trying to do (albeit using InterBase) so I could
and would have given you an exact answer had I been able to determine
what your question was.

Eryk