StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Conversion from type 'Guid' to type 'String' is not valid.

Conversion from type 'Guid' to type 'String' is not valid.

Marcel Heitlager — Wed, 01 Sep 2010 20:57:27 GMT

Hi guys,

I can't figure this one out. But this started after I updated to latest beta, I started getting this problem on my development machine. I noticed that it wasn't happening on the testing server, but then I discovered that I wasn't copying the latest staraframe dll's to the server (so it was still using the old version). The issue is as follows:

I have a table with a GUID primary key.

Then I call any of the following:
[codesnippet]
Me.UCPlansBO.Sort = "pl_NumberOfPmts DESC"
[/codesnippet]

OR

[codesnippet]
Line 197: If Me.MyPlansBO.SeekToPrimaryKey(Me.MyPlanMembersBO.pm_Pl_Key) Then
[/codesnippet]

It throws the following error:
[quote]
Exception Details: System.InvalidCastException: Conversion from type 'Guid' to type 'String' is not valid.
[/quote]

The partial stack trace is as follows:
[quote]
[InvalidCastException: Conversion from type 'Guid' to type 'String' is not valid.]
Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value) +453096
MicroFour.StrataFrame.Business.BusinessLayer.GetIndexOfPrimaryKey(Object[] PrimaryKeyValues) +233
MicroFour.StrataFrame.Business.BusinessLayer.SeekToPrimaryKey(Object[] PrimaryKeyValues) +15
AESWebAccess.EnrollmentWizard.SubmitPlanInfo() in E:\_VS2008Projects\DEV\AES\New_AESWebAccess\AESWebAccess\MyAccount\Applications\EnrollmentWizard.PlanDetail.vb:197

[/quote]

I reverted to the previous build and it worked again. Am I doing something screwy though, or is it a bug (or both?:P)

Marcel

RE: Conversion from type 'Guid' to type 'String' is not valid.

Peter Jones — Wed, 01 Sep 2010 20:57:27 GMT

Hi,

The problem identified above isn't fixed in 1.7.3.1

Cheers, Peter

RE: Conversion from type 'Guid' to type 'String' is not valid.

Trent L. Taylor — Sat, 28 Aug 2010 09:21:11 GMT

Actually we had two threads going on this one. This was actually fixed and is in the build. It was fixed back in March, so if you weren't running the beta build you may not have noticed this. At any rate, it is fixed and in the 1.7.3 build.

[url=http://forum.strataframe.net/Topic26310-10-1.aspx]http://forum.strataframe.net/Topic26310-10-1.aspx[/url]

RE: Conversion from type 'Guid' to type 'String' is not valid.

Greg McGuffey — Tue, 25 May 2010 11:23:34 GMT

Thanks Peter! This one was missed, but is now in the list of issues we'll take a look at it this week and post as soon as the fix is done.

RE: Conversion from type 'Guid' to type 'String' is not valid.

Peter Jones — Mon, 24 May 2010 18:18:59 GMT

Hi Guys,

I just wanted to reactivate this post to make sure it has been seen and the appropriate action taken in the next SF release.

Cheers, Peter

RE: Conversion from type 'Guid' to type 'String' is not valid.

Peter Jones — Wed, 05 May 2010 17:31:24 GMT

Hi Guys,

The problem is in businesslayer.vb in the function GetIndexOfPrimaryKey on lines 2845 to 2850, and relates to the change to resolve the issue of a primary key containing a singlequote.

The code prior to the change used PrimaryKeyValues(lnCnt).ToString() to get the value of that portion of the key

The changed code uses CStr(PrimaryKeyValues(lnCnt)).Replace("'", "''") to get the portion of the key and address the issue of single quotes. The problem with this is that CStr doesn't work on a Guid.

An alternative using PrimaryKeyValues(lnCnt).ToString.Replace("'", "''") appears to fix the issue.

Cheers, Peter

RE: Conversion from type 'Guid' to type 'String' is not valid.

Peter Jones — Wed, 05 May 2010 07:44:49 GMT

Hi Guys,

Bump de Bump....

We are seeing the same issue (all our PK's are GUIDs) and are rolling out a VS2010 version this weekend. We will be looking to change the SF code to get us going so any assistance you could give in terms of what we could/should change would be appreciated.

Cheers, Peter

RE: Conversion from type 'Guid' to type 'String' is not valid.

Marcel Heitlager — Fri, 23 Apr 2010 10:23:17 GMT

Well, I reverted back to the previous update. Rebooted the machine. And now it works again. I'll try again updating later to try to figure out what's going on.