BrowseDialog - show data from related table


BrowseDialog - show data from related table
View
Options
Author
Message
Fabian R Silva, -
Fabian R Silva, -
Fabian R Silva, -
posted 18 Years Ago HOT
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
I try to show on a browsedialog a column from a related table (example: Custeomers.IdCountry --> show Country.Description) without sucess, how I can accomplish this? thanks!



- Fabian
Reply Like 0
Replies
Trent Taylor
Trent Taylor
Trent Taylor
posted 18 Years Ago
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
I am a bit unclear on your last post.  Are you indicating that the primary key in the ProvinciasVistaBO1 is zero so when you try to fill the Provincias BO you do not get any records?  Do you have any records in the ProvinciasVista BO at all in the BrowseDialogClosed method?
Reply Like 0
Fabian R Silva, -
Fabian R Silva, -
Fabian R Silva, -
posted 18 Years Ago
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

I test on BRW_closed....
>? Me.ProvinciasVistaBO1.count
result: 7

it have 7 records

sorry, I ommited I have a primary key with seed 0, It appears that the BO "ProvinciasVistaBO1" don´t move from his first record, I test to delete the "id 0" record and the first record have to be the id 1 and when I run another test, this retrieve the 1st record again... (with id 1 this time), If I put on debug Me.ProvinciasVistaBO1.movenext I give the 2nd record viewed on the form....and so on

I made a mistake on something? thanks for you big patience Trent Blush

- Fabian
Reply Like 0
Trent Taylor
Trent Taylor
Trent Taylor
posted 18 Years Ago
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Fabian, no need to apologize for anything! Smile  I am glad that you got it working!
Reply Like 0
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Threaded View
Threaded View
BrowseDialog - show data from related table
Fabian R Silva, - - 18 Years Ago
     This is the entire purpose of an InformationPanel. This allows you to...
Trent L. Taylor - 18 Years Ago
             Thanks for you reply

If I dont like to use the information...
Fabian R Silva, - - 18 Years Ago
                 Yes. You can use a view or an inner join and bring in the data as you...
Trent L. Taylor - 18 Years Ago
                     Thanks for you reply

Can you give me a example of how I can...
Fabian R Silva, - - 18 Years Ago
                         Your English is great.... MUCH better than my Spanish! :) What I...
Trent L. Taylor - 18 Years Ago
                             This alternative sound great, but I don' t know how to create a BO...
Fabian R Silva, - - 18 Years Ago
                                 First, you will need to create your view. If you are using the...
Trent L. Taylor - 18 Years Ago
                                     I followed all the steps it appears to work but I have a problem in...
Fabian R Silva, - - 18 Years Ago
                                         I am a bit unclear on your last post. Are you indicating that the...
Trent L. Taylor - 18 Years Ago
                                             I test on BRW_closed.... >? Me.ProvinciasVistaBO1.count result: 7...
Fabian R Silva, - - 18 Years Ago
                                                 Fabian, no need to apologize for anything! :) I am glad that you got...
Trent L. Taylor - 18 Years Ago

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2025
Execution: 0.000. 3 queries. Compression Enabled.

Login

Explore
Messages
Mentions
Search