the query fetches only 6 fields

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
PHC

the query fetches only 6 fields

Post by PHC » Fri 03 Dec 2004 11:37

Hi,

I have a kylix software running under linux connected to a mysql db.
I use the libsqlmda driver to access to the db (libsqlmda.so.2.10) I downloaded then trial version.

The problem is that when I run a query via a TSQLDataset, it fetches only the first 6 fields. The same problem appears when I run the demo program (ClientDataSet.dpr) from kylix.

What is the problem ??

Thank you for your help.
PHC

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: the query fetches only 6 fields

Post by Ikar » Fri 03 Dec 2004 12:00

Linux Trial version of the driver is limited by number of the returned table columns. DbxMda trial version returns cursors with maximum 6 columns. Extra select-list columns are truncated.

Guest

Post by Guest » Fri 03 Dec 2004 13:50

so how to compare performance between your driver and the dbexpress driver if I can not do the same queries on complete tables ?
Isn't it possible to get a fully functionnal version to run a test under linux ?

Thanks
PHC

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 07 Dec 2004 10:07

We sent you trial version with time limitation by email.

joncmora

Post by joncmora » Wed 22 Dec 2004 06:15

>We sent you trial version with time limitation by email.

Can you send me a fully functional but time limited version too? I find the dowloadable trial no use in my case. Please extend it until January since we can't fully test it by this time (everybody is on vacation!!!). We are planning on buying 5 licenses if it meets our requirements.

Please send it to [email protected].

I want to try it on my Attendance Monitoring System running 24/7. The default driver included in Delphi 7 limits 1 DBX component (xDataset) for each TSQLConnection. And this is causing a problem on the idle components, the connection gets dropped.

Thanks in advance.

Another question. Will your MySQL driver work on DBX for Delphi 7/2005 and MySQL 4.1? We are planning on upgrading by next year.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 22 Dec 2004 09:45

If you use Delphi, the last trial versions available for download from our site have time trial restriction (two weeks from the day of installation).

> Will your MySQL driver work on DBX for Delphi 7/2005 and MySQL 4.1?

Yes, we have already supported MySQL 4.1, support of Delphi 2005 needs some insignificant modifications in design-time.

Guest

Send me too

Post by Guest » Fri 18 Mar 2005 02:16

Hi

please send me too !

im using kylix3 for development
the '6 field' limitation doesnt allow me to fully test my system !

my email is [email protected]

thanks in advance

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 18 Mar 2005 15:09

Next week we are planning to release a new build of DbxMda. We'll send you time-limited version by email.

bayufa

Post by bayufa » Tue 29 Mar 2005 02:02

hi ..

please send me the time limited library ..
i need it to test my system . So far your library works fine
with my system . But i need to test it further so i can decide
to buy a license from crlab .

if your not busy...please send to [email protected]

thanks in advance
bayufa

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 29 Mar 2005 07:22

What OS do you use?

Post Reply