03-28-2012 03:03 PM - edited 03-28-2012 03:08 PM
I'm trying to read in the data using Act Reader and I'm obtainign a 'Could not open the object' error when trying to read in my custom table (via Plug-in). The error I obtain in Access is "conversion failed when convertiong form a character string to unique identifier.
I'm trying to import directly dbo_PLUGINTABLE (though I can pull in dbo_COMPANY_PLUGINTABLE dbo_CUST_COMPANY_PLUGINTABLE and dbo_CUST_PLUGINTABLE). If it makes a difference, the table is under 'Company'.
Edit: Where PLUGINTABLE is the custom entity descriptor.
03-28-2012 06:12 PM
First you may have a character field you may be relating to a GUID field. You need to convert the character field to a GUID (unique identifier in SQL terminology)
This page may help: http://msdn.microsoft.com/en-us/library/ms187942(v=sql.110).aspx
Also make sure you set a filter to weed out null and empty rows cause the uniqueidentifier conversion will fail on those conditions.
Second, I would not import directly into the table. You should be using an CustomEntityManager to create the new records.
Hope this helps
-- Jim Durkin