Page 1 of 1

Datatype diference when calling RetrieveColumns

Posted: Fri Jul 31, 2015 2:08 pm
by João Paulo Melo
Hi Stimulsoft

I'm using version ASP.NET html5 editor (version 2015.1.0, from 24 april 2015), over an MS SQL Server Database.

I realize that when I add a new DataSource, selecting a Table, the foreign key DataType come as int.
When editing this new DataSource, and then removing the field, and then calling RetrieveColumns, the same foreign key come as long.

On SQL Server the DataType of foreign key is "Int".
On .NET we deal as long (System.Int64), so RetrieveColumns bring as long correctly..


The same occurs when I dial whit images: Adding table, came as String, calling RetrieveColumns came as byte[]..

On SQL Server the DataType of image is "VARBINARY(MAX)".
On .NET we deal as byte[], so RetrieveColumns bring as byte[] correctly..

Would you guys could equalize this behavior?



Thanks!

Re: Datatype diference when calling RetrieveColumns

Posted: Tue Aug 04, 2015 8:12 am
by HighAley
Hello.

Sorry, but we couldn't reproduce the issue on our current build
Could you upgrade to the latest prerelease build and check if you have the same issue there.

Thank you.