Trying to move from MyDac 3.55 to 5.70

Willo · Post by **Willo** » Mon 26 Oct 2009 23:58

We are trying to recompile our Delphi 7 App, using MyDac 5.70; after dealing with lots of "minor" differences, we hit a dead end.

This code was working fine with 3.55...

Code: Select all

function TDM.LocalizaPoliza( xpoliza : string) : boolean;
begin
	if xpoliza  '' then
     begin
          MyQbusca.SQL.Text := 'Select * from polizas where SL_POL = '+quotedstr(xpoliza);
          MyQbusca.Open;

     	Result := (MyQbusca.RecordCount > 0);
     end
     else
     	Result := False;
end;

But on runtime with the app compiled using MyDAC 5.70 that code give us an :

Commands out of sync; You can't run this command now.

We can figure out a solution, can you help us?

Dimon · Post by **Dimon** » Tue 27 Oct 2009 12:57

I can not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.

Willo · Post by **Willo** » Tue 27 Oct 2009 14:01

Ok...

that could be hard to do..

when i run that Select statment alone it works fine; but when it is executed on the system gave us that error, so maybe is a secuence of events that leads to that error.

I know is hard to solve a software problem without reproduce a situation, but please understand, the application was working fine with MyDAC 3.55, and we decided to move to 5.70 because this version solves another problem (connecting to mysql on localhost.. see post http://www.devart.com/forums/viewtopic.php?t=16032)

So we are very disapointed with MyDAC right now.

Dimon · Post by **Dimon** » Wed 28 Oct 2009 09:37

Please, specify if you use the multi-thread application.

Willo · Post by **Willo** » Wed 28 Oct 2009 13:58

Dimon wrote:Please, specify if you use the multi-thread application.

No, it is actually a very simple application, that code is on a datamodule, and is called from other programs.

Dimon · Post by **Dimon** » Wed 28 Oct 2009 14:39

I can not investigate and solve this problem as I can not reproduce it. Therefore I need a sample to demonstrate the problem.

Willo · Post by **Willo** » Wed 28 Oct 2009 19:05

Dimon wrote:I can not investigate and solve this problem as I can not reproduce it. Therefore I need a sample to demonstrate the problem.

Ok DIMON, we'll try to prepare a sample for you, what do you need?... source delphi code?, empty or filled tables?

(we use Delphi 7, MyDAC 5.7, MySQL server 5.39, Windows XP SP 3 and Vista SP2)...

eduardosic · Post by **eduardosic** » Wed 28 Oct 2009 23:29

Willo, try to upgrade for MyDac 5.90.0.52.

Dimon · Post by **Dimon** » Thu 29 Oct 2009 07:45

I need a sample with source code to demonstrate the problem, and a script to create and fill tables.

Willo · Post by **Willo** » Thu 29 Oct 2009 17:20

eduardosic wrote:Willo, try to upgrade for MyDac 5.90.0.52.

Do we have to pay something for the upgrade?

Devart · Post by **Devart** » Fri 30 Oct 2009 15:39

Willo wrote:Do we have to pay something for the upgrade?

Please contact our sales by email and specify your license number.