SqlCe Database pack - broken with latest patch

lcruiser · Post by **lcruiser** » Sun Aug 26, 2007 12:54 am

Hi,

I just dowloaded the latest patch (SR_2007[1].08.24_R2005). The upgrade works OK but the I'm having problem compiling SqlCe Database pack. Here are the errors:

'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'Database' ...\StiSqlCeDatabase.cs 48 43 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'FormDatabaseEdit' ...\StiSqlCeDatabase.cs 67 62 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'FormDatabaseEdit' ...\StiSqlCeDatabase.cs 68 50 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'Adapters' ...\StiSqlCeAdapterService.cs 49 40 Stimulsoft.Report.SqlCeDatabase
'Stimulsoft.Base.Localization.StiLocalization' does not contain a definition for 'PropertyMain' ...\StiSqlCeSource.cs 107 33 Stimulsoft.Report.SqlCeDatabase

Thanks.

Post by **Vital** » Sun Aug 26, 2007 12:43 pm

Hello,

please get update version of adapter:

www.stimulsoft.com/private/Stimulsoft.R ... tabase.zip

Thank you.

lcruiser · Post by **lcruiser** » Sun Sep 02, 2007 9:16 am

Hi,

I think there is a bug in the updated adapter. I compiled it without error however existing reports connecting directly to SqlCe didn't work any more. I found that in the designer dictionary all tables no longer have any column infomation. The relation seemed to be OK.

I used the following codes to register each table in the database which used to work before the update:

StiSqlCeSource source = new StiSqlCeSource(databaseName, tableName, tableName, "SELECT * FROM " + tableName);
report.Dictionary.DataSources.Add(source);
source.SynchronizeColumns();

Am I missing something?

Thanks.

Post by **Edward** » Tue Sep 04, 2007 2:57 am

Sorry for the delay in answers.

We are working now on the 2007.2 official release version.

Thank you.

lcruiser · Post by **lcruiser** » Sat Sep 08, 2007 7:52 pm

I fixed the problem, just post the answer here in case someone interested.

In StiSqlCeAdapterService.cs method GetColumnsFromData() has the following codes:

foreach (StiDataColumn column in dataColumns)
{
column.Name = StiNameValidator.CorrectName(column.Name);
}

I found that StiNameValidator.CorrectName() replaces space with '_' causing the report to behave incorrectly in some cases. I commented out this codes and it works OK with release version 7.2

Post by **Edward** » Mon Sep 10, 2007 9:45 am

Thank you very much for this explanation.

We will check this behavior once more.

Thank you.

Post by **Vital** » Mon Sep 10, 2007 12:42 pm

We have corrected our code.
Thank you for your help.