StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Cannot Access some properties on designer

Cannot Access some properties on designer

Fabian R Silva, - — Mon, 10 Sep 2007 10:32:41 GMT

When I try to change some properties that have a link "..." or some controls that have a arrow to access some properties in designer (like the attachment) I got the message like [i]"implicit convert text to nVarChar not allowed. Use the CONVERT function to execute this query"[/i] it seems like a SQL message but I only try to acess to a property :crazy:

I not sure if the attachment is the best example, on a strataframe button say "click to setup solution preferences" when I found other example I post in this thread another message, thanks

Fabian

RE: Cannot Access some properties on designer

Fabian R Silva, - — Mon, 10 Sep 2007 10:32:41 GMT

thanks :)
No problem, I'll export my sql 2000 data to sql 2005 express (I'm installed SF / sql 2005 and deployed the SF on it but need my actual data from sql 2000)

If I can help on the sql 2000 problem contact me when you need.

Thanks!

RE: Cannot Access some properties on designer

StrataFrame Team — Mon, 10 Sep 2007 08:49:46 GMT

Yep, it looks like

[quote]SELECT [pref_pk],[pref_prj_pk],[pref_sproj_pk],[pref_defaultlanguage],[pref_solution],[pref_ApplicationTheme],[pref_CustomThemeFullName],[pref_ShowFullBOName],[pref_created],[pref_Version] FROM [dbo].[DTEPreferences] WHERE pref_solution LIKE @pref_solution [/quote]

is the one causing the problem. The @pref_solution parameter is a VarChar, but SQL Server 2000 allows conversion between Text and VarChar if you use LIKE. Very strange, I'll have to look into this one. The only workaround for now, Fabian, would be to install a SQL Server 2005 Express somewhere and use it as your SF database.

RE: Cannot Access some properties on designer

Fabian R Silva, - — Fri, 07 Sep 2007 13:27:59 GMT

Here it is :)

RE: Cannot Access some properties on designer

StrataFrame Team — Fri, 07 Sep 2007 09:51:23 GMT

Yes, if you swap your SF database over to SQL Server 2005 it will fix that problem. But it should also be working on SQL Server 2000. If you want to get some more information, you can turn on DebugMode for the SF design-time by setting a couple registry keys.

HKEY_LOCAL_MACHINE\Software\MicroFour\VSAddIns\DebugMode - DWORD - any value other than 0

HKEY_LOCAL_MACHINE\Software\MicroFour\VSAddIns\DebugFile - String - Full path to the .html file for output

Then, when you get that exception, copy the .html file immediately, zip it and attach it to the forum. The last command listed will be the one that is causing the problem.

Thanks

RE: Cannot Access some properties on designer

Fabian R Silva, - — Thu, 06 Sep 2007 11:10:45 GMT

I only see that this error happen, but (almost now) its not a urgent/important thing, I using sql 2000 server to test purposes, but on deployment I think that I will use SQL Server 2005 (Express), I try to install sql 2005 to development (i think a good choice [development = deploy] )

@@Version:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: )

RE: Cannot Access some properties on designer

StrataFrame Team — Thu, 06 Sep 2007 09:01:55 GMT

Most likely, you're using SQL Server 2000 to store the SF database. We initially had problems with SQL Server 2000 because NVarChar(MAX) is converted to NText, but I thought we took care of all of those.

Looking at the query, it uses a LIKE, which is legal between NText and NVarChar, so I'm not sure why it's throwing an error. Could you get us the SQL Server version info on the server that's housing your SF database? Thanks.