Cannot Access some properties on designer


Author
Message
Fabian R Silva, -
Fabian R Silva, -
StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)
Group: StrataFrame Users
Posts: 153, Visits: 1.2K
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 "implicit convert text to nVarChar not allowed. Use the CONVERT function to execute this query" 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



Attachments
textTonVarchar.jpg (99 views, 124.00 KB)
Replies
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Yep, it looks like

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

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.

Fabian R Silva, -
Fabian R Silva, -
StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)StrataFrame User (317 reputation)
Group: StrataFrame Users
Posts: 153, Visits: 1.2K
thanks Smile

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!



GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Fabian R Silva, - - 18 Years Ago
StrataFrame Team - 18 Years Ago
Fabian R Silva, - - 18 Years Ago
StrataFrame Team - 18 Years Ago
                     Here it is :)
Fabian R Silva, - - 18 Years Ago
                         Yep, it looks like [quote]SELECT...
StrataFrame Team - 18 Years Ago
                             thanks :)
No problem, I'll export my sql 2000 data to sql 2005...
Fabian R Silva, - - 18 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search