Lately it is impossible to query the "Cases" table with dotConnect for Sugar in Visual Studio. For each query it returns "Object 'Cases' does not have field 'first_response_user_id'."
The same error is returned when the SYS_COLUMNS table is queried, even if the table "Cases" is excluded in the WHERE clause. It is worth noting that this used to work before with the same program.
Turns out that this are new fields that have been created when the separation in the new Sugar modules was made. Is there anything to be done in order to be able to query this table again? Has anyone made that experience?
Sugar CRM Connector - trouble with new fields?
Re: Sugar CRM Connector - trouble with new fields?
Thank you for your report. We have reproduced the issue and notify you when it is fixed.
Re: Sugar CRM Connector - trouble with new fields?
The bug with retrieving metadata from the Cases table is fixed in v1.9.1181. Please upgrade.
Re: Sugar CRM Connector - trouble with new fields?
Hi Shalex,
have updated to the new version, but there is still an error:
The sql was simply "select * from Cases". Any thoughts?
Thanks,
Leo
have updated to the new version, but there is still an error:
The sql was simply "select * from Cases". Any thoughts?
Thanks,
Leo
Re: Sugar CRM Connector - trouble with new fields?
The following code works with v1.9.1181 in our environment:
Run your code in the debug mode, navigate to Debug > Windows > Modules and make sure that the new versions of Devart.* assemblies are used:
* Devart.Data.dll v5.0.2458.0
* Devart.Data.SqlShim.dll v1.9.1181.0
* Devart.Data.Sugar.dll v1.9.1181.0
Code: Select all
var cmd = conn.CreateCommand();
cmd.CommandText = "select * from Cases";
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var values = new object[reader.FieldCount];
reader.GetValues(values);
}
* Devart.Data.dll v5.0.2458.0
* Devart.Data.SqlShim.dll v1.9.1181.0
* Devart.Data.Sugar.dll v1.9.1181.0