Page 1 of 1
Trying to move from MyDac 3.55 to 5.70
Posted: Mon 26 Oct 2009 23:58
by Willo
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?
Posted: Tue 27 Oct 2009 12:57
by Dimon
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.
Posted: Tue 27 Oct 2009 14:01
by Willo
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.
Posted: Wed 28 Oct 2009 09:37
by Dimon
Please, specify if you use the multi-thread application.
Posted: Wed 28 Oct 2009 13:58
by Willo
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.
Posted: Wed 28 Oct 2009 14:39
by Dimon
I can not investigate and solve this problem as I can not reproduce it. Therefore I need a sample to demonstrate the problem.
Posted: Wed 28 Oct 2009 19:05
by Willo
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)...
Posted: Wed 28 Oct 2009 23:29
by eduardosic
Willo, try to upgrade for MyDac 5.90.0.52.
Posted: Thu 29 Oct 2009 07:45
by Dimon
I need a sample with source code to demonstrate the problem, and a script to create and fill tables.
Posted: Thu 29 Oct 2009 17:20
by Willo
eduardosic wrote:Willo, try to upgrade for MyDac 5.90.0.52.
Do we have to pay something for the upgrade?
Posted: Fri 30 Oct 2009 15:39
by Devart
Willo wrote:Do we have to pay something for the upgrade?
Please contact our sales by email and specify your license number.