BrowseDialog with Foreign Keys GUID type...


Author
Message
Robin J Giltner
Robin J Giltner
StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)
Group: Forum Members
Posts: 105, Visits: 650
I have a table with a child table which are linked to by a foreign key field in the parent, to the primary key field in the child table.  While testing this on a test DB, using the ForeignKey ComboBox it worked perfectly, using integer type fields.

Now trying to use this same approach on my production data using GUID type PK's and FK's, the Function ConvertValue in the ObjectConverter is throwing an error, saying that "The input value could not be converted to the output type."  

I looked through this code, and there doesn't seem to be an If statement for a GUID type.  Is this something that is just impossible at this time, or not doable all together, or am I just going about this the wrong way?

Thanks,

Robin Giltner

 

Replies
Robin J Giltner
Robin J Giltner
StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)StrataFrame User (179 reputation)
Group: Forum Members
Posts: 105, Visits: 650
Absolutely.  They will be to you shortly.  The only other change I found I had to tinker with, was the "Clear" button on the browsedialog.  The Strataframe source had set the SelectedValue to -1, to I just changed that to SelectedIndex = 0.

Pressing the Clear fields would clear out the value of the combobox and would return no results unless I changed it to "<Not Used>"

Thanks.

Robin Giltner

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
Thanks for the list, Robin Smile  Say hi to the rest of the guys for me.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Robin J Giltner - 19 Years Ago
StrataFrame Team - 19 Years Ago
Robin J Giltner - 19 Years Ago
StrataFrame Team - 19 Years Ago
Robin J Giltner - 19 Years Ago
                         Yes, the -1 is for the "Not Used". However, you should be able to...
StrataFrame Team - 19 Years Ago
                             Hey Ben. I added the code into the ObjectConverter to check for a "-1"...
Robin J Giltner - 19 Years Ago
                                 Not that I can think of off the top of my head. Would you mind...
StrataFrame Team - 19 Years Ago
                                     Absolutely. They will be to you shortly. The only other change I found...
Robin J Giltner - 19 Years Ago
                                         Thanks for the list, Robin :) Say hi to the rest of the guys for me.
StrataFrame Team - 19 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search