Retrieve columns problem

[Bolex]

Hello,

we have a problem retrieving columns in data source from #table (temporary table) with last version 2011.1.

SQL Example in Edit data source:

select a.*,b.* into #temp_table from data a left join /..../

select * from #temp_table

drop table #temp_table

When I click view query, i get data table, but then after click on field retrieve columns it throw exception -> Message: Invalid object name #temp_table ; Source: .Net SqlClient Data Provider

This was working without problems in previous versions.

Thanks in advance.

[Bolex]

Any idea? Anyone?

[Alex K.]

Hello,

We are working on the problem. We will let you know when the solution is available.

Thank you.

[Alex K.]

Hello,

We add an option for selecting the method of getting columns.

Code: Select all

StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;

Please check the prerelease build on this week.

Thank you.

[Bolex]

Hi,

tnx for replay, I will test and let you know if working properly.

Thank you, B

[Alex K.]

Hello,

Ok.
Let us know if you need any additional help.

Thank you.

[wangqiang]

Hello,
I got the same problem too.I'm using the Stimulsoft Reports.Net 2011.2.1100.
As the columns are returned by temporary table, after click on "retrieving columns", I got the failed info->"Invalid object name #tmp_table".
But I can't find the option for selecting the method of getting columns which is metioned above. Is it not added to this editon?
Thank you.

[Alex K.]

Hello,

You can set this options from code:

Code: Select all

StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;

Or from OptionsHelper.exe

Thank you.

[VaDRo]

I have the same problem on version 2015.1.
When I'm running OptionsHelper and setting that option for any value -> OptionsHelper fires exception:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at OptionsHelper.StiOptionsHelperForm.SetNewValue(String customPropertyName, Object newValue)
at OptionsHelper.StiOptionsHelperForm.propertyGrid1_PropertyValueChanged(Object s, PropertyValueChangedEventArgs e)
at System.Windows.Forms.PropertyGrid.OnPropertyValueChanged(PropertyValueChangedEventArgs e)
at System.Windows.Forms.PropertyGridInternal.PropertyGridView.CommitValue(GridEntry ipeCur, Object value)
at System.Windows.Forms.PropertyGridInternal.PropertyGridView.OnListClick(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ListBox.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3131.0 built by: NET472REL1LAST
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
OptionsHelper
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Stimulsoft%20Reports.Net%202015.1/Bin/OptionsHelper.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Stimulsoft.Report
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Stimulsoft.Report/v4.0_2015.1.0.0__ebe6666cba19647a/Stimulsoft.Report.dll
----------------------------------------
Stimulsoft.Base
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Stimulsoft.Base/v4.0_2015.1.0.0__ebe6666cba19647a/Stimulsoft.Base.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3110.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Stimulsoft.Editor
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Stimulsoft.Editor/v4.0_2015.1.0.0__ebe6666cba19647a/Stimulsoft.Editor.dll
----------------------------------------
StiAssembly
Assembly Version: 0.0.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Stimulsoft%20Reports.Net%202015.1/Bin/OptionsHelper.exe
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Drawing.Design
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.
Please try to remove the settings folder by the following path:
[C]:\Users\[UserName]\AppData\Local\Stimulsoft\

Also, you can set all options in your project and save it
StiOptions.Save()

Thank you.