Stored Procedures fail with N(VAR)CHAR

[upscene]

Hi,

Version 5.90.0.57

You cannot use a stored procedure with NCHAR parameter.

To reproduce:

1) create a stored procedure like this:

Code: Select all

CREATE PROCEDURE P_nchar_test(test NChar(100))
  READS SQL DATA
begin
end

MySQL happily accepts.

2) drop a TMyConnection on the form, connect it to your database

3) drop a TMyStoredProc on the form, attach it to your connection component

4) set the TMyStoredProc.StoredProcName to the above procedure

Error raised:
----------
Unknown column type "NCHAR" in "test NChar(100)".


Call stack:
----------
[0EB76662]{mydac120.bpl} Myclasses.TMySQLCommand.DescribeParams + $726
[0EB776C0]{mydac120.bpl} Myclasses.TMySQLCommand.CreateProcCall + $B4
[1603956C]{dac120.bpl } Dbaccess.TCustomDASQL.InternalCreateProcCall + $74
[1602E32D]{dac120.bpl } Dbaccess.TCustomDADataSet.InternalCreateProcCall + $21
[0EB9EC23]{mydac120.bpl} Myaccess.TCustomMyStoredProc.PrepareSQL + $1F
[0EB9EBDC]{mydac120.bpl} Myaccess.TCustomMyStoredProc.SetStoredProcName + $74
[5003F6FD]{rtl120.bpl } TypInfo.SetUnicodeStrProp (Line 2127, "TypInfo.pas" + 24) + $5
...



Please send me a fix for this, I need it urgently!


With regards,

Martijn Tonies
Upscene Productions

[Dimon]

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

[upscene]

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Hello Dimon,

Any idea when that build is going to be released?


Thanks.

[Dimon]

The next MyDAC build will be released next week.