Page 1 of 1
Dropping Parameters
Posted: Tue 27 Sep 2005 12:34
by Jammerj2000
On the MySQLDirectMobile, I can configure MySQL Data Adapters just fine. I can add the parameters just fine. However, if I switch to a different solution, then come back to this one, the Parameters are gone from the Configure Data Adapter tool. The app also will not run at that point, giving me missing mapping errors. I can re-add the parameters and it will then run.
I am using the parameter format @NAME Is this not valid for MySQL?
Posted: Tue 27 Sep 2005 16:09
by Jammerj2000
Experimenting further...
I have found that If you use the :NAME paramter format, the utilities will ask you to regenereate the Parameters. But it is still dropping them if you switch to another solution.
I have found that if you use the short form of the Parameter Add...
Me.GetGiftItems.Parameters.Add("AccountID", CoreLab.MySql.MySqlType.Int, 0, "AccountID")
The utility will read the parameters into the utility windows. If you use the automatically generated long form...
Me.GetGiftItems.Parameters.Add(New CoreLab.MySql.MySqlParameter("AccountID", CoreLab.MySql.MySqlType.Int, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "AccountID", System.Data.DataRowVersion.Current, Nothing))
The utility will not read the paramters into the utility window.
Posted: Wed 28 Sep 2005 08:55
by Serious
We have fixedd this problem for MySQLDirect .NET.
Look forward for the next build.