Devart Forums

it's a nightmare !
every time there is a new build i know it will take my team wasting 1-2 days to overcome the license issues.
we have also MySQL comp for Delphi and it works like a charms , .Net comp are very hard to upgrade and work with.

Lior

Alexey,
i sent you email with DB and solution,
waiting for your reply

Lior,

hi,
im using MySQLDataTable and execute stored procedure that return a table from a join.
one of the fields in this query is coming from a table that heis there a Unique.
Now in the Query result i get a list of fields and i have muiltple values
when i execute the SP
i got the exception :
Column 'MasterID' is constrained to be unique. Value '1710' is already present.

why this component don't let me load a result set that one of the fileds are not unique ?
BTW, in Delphi, all is working right
what i'm doing wrong ?

Lior

NO,
nothing help
i did everything.
more than that i installed it on new computer ( i mean new with everything)

back to 4.20.18 version

guys you need to locate it and fix it

Guys,
don;t know what you did but this version is not good.
the VS don't recognize MySqlConnection and MySqlConnectionStringBuilder classes
i add all the refs.... nothing
i found out that
Corelab.data
Corelab.data.design
Corelab.Data.vs
had version 4.20.15
( don't know if it OK or not)
the rest is 4.20.19

more than that, add MySQLCOnnection to the form cause an error of 'The path is not legal form

i removed it and install version 4.20.18 and all works fine
(beside the other bugs already in this version)

Please fix it ASAP

I Have the same problem,
no matter what i did, still have the problem,
Guys, you need to find it and fix it

More info:
1. it happens in Windows 2003,
2. it happens when two applications ( the same code) is running in parallel.
3. seems to be the problem with the locking mechanizm.

1. TmyQuery is not support locking and this is what i need- correct me if i wrong.
2. this problem not happening all the time. the actual code is running as a procedure in a loop in 500 ms interval. try to to run it like that and you will see.

GUys,
There is a bug in MyDAC 5.0.1.7
My code looks like that:

tableMain:=TMyTable.Create(nil);
tableMain.TableName:='signalsrelay';

try
tableMain.Connection:=mainMySQLServer ;
tableMain.Open;
if tableMain.RecordCount > 0 then
begin
tableMain.LockTable(ltWrite);
tableMain.SQL.Text:='Select * From signalsrelay';
tableMain.Execute;
for i := 1 to tableMain.RecordCount do
begin
tableMain.RecNo:=i;
new (rec);
rec.from:=tableMain.FieldByName('Provider').AsString;
rec.subject:=tableMain.FieldByName('Subject').AsString;
rec.content:=tableMain.FieldByName('Content').AsString;
commandsList.Add(rec);
end;
tableMain.SQL.Text:='Delete From signalsrelay';
tableMain.Execute;
tableMain.UnLockTable;

end;

except on E: Exception do
begin
AddError(error,'(ReadCommands) Exception - '+E.Message);
tableMain.UnLockTable;
end;
end;


In some time suddenly i get execption

FUpdateQuery = nil. StatementTypes = 128 (D:\Projects\Delphi\Dac\Source\DBAccess.pas, line 5168)

and then all the time this exception:

Not enough timers available
Not enough timers available

all the time.


this is not happening in 5.0.4 version.

Did the new Build that you released solving this problem ?

Any Chance for an Answer ?

Hi,
When i'm using Disconnect Mode On and Pooling = True when i'm try to run Stored procedure i got Assertion Failure in MyAccess.pas line 3701.
when i'm disable the disconnect mode or the pooling it's work fine.
Why ?


Lior,

Duke wrote:We are working over this problem.

Thanks,
Please post back when there is a solution.

None of the above application / expert are loaded. the Delphi 2007 is clean install with MyDAC 5.
when i uninstall the developer tools all working fine.
please let me know what i need to do in order to show you that it comes from Developer tools.
another exception
=========================
Exception Information
=========================
Message: Access violation at address 21EC0E19 in module 'dotnetcoreide100.bpl'. Read of address 00000000
Source:
TargetSite: Borland.Studio.ToolsAPI.IOTAMenuItem AddMenuItem(System.String, Borland.Studio.ToolsAPI.OTAMenuItemLocation, System.String, System.String, IntPtr)
HelpLink:
Type: System.Runtime.InteropServices.COMException
Stack:
at Borland.Studio.ToolsAPI.IOTAMainMenuService.AddMenuItem(String referenceItemName, OTAMenuItemLocation newLocation, String newName, String newText, IntPtr bitmapHandle)
at agx.a(IOTAMainMenuService A_0, String A_1, Int32 A_2, String A_3, String A_4, IntPtr A_5)
at agx.a()
at a7.a()
at CoreLab.DbTools.Bds.Connect.b()

I'm using MyDAC 5
i downloaded the Developer Tools and when i start Delphi i get Error msg.

=========================
Exception Information
=========================
Message: Access violation at address 21EC0E19 in module 'dotnetcoreide100.bpl'. Read of address 00000000
Source:
TargetSite: Borland.Studio.ToolsAPI.IOTAMenuItem AddMenuItem(System.String, Borland.Studio.ToolsAPI.OTAMenuItemLocation, System.String, System.String, IntPtr)
HelpLink:
Type: System.Runtime.InteropServices.COMException
Stack:
at Borland.Studio.ToolsAPI.IOTAMainMenuService.AddMenuItem(String referenceItemName, OTAMenuItemLocation newLocation, String newName, String newText, IntPtr bitmapHandle)
at agx.a(IOTAMainMenuService A_0, String A_1, Int32 A_2, String A_3, String A_4, IntPtr A_5)
at agx.a()
at a7.a()
at CoreLab.DbTools.Bds.Connect.b()

=========================

More info has been sent to you by email.