Visual Basic

Re: Select Query from different Databases ?

30-Jul-09 2:44

So we're talking SQL here not VB, but okay.

SELECT T0.*
FROM Employee_Master.dbo.emp_master T0
INNER JOIN Purchase_Master.dbo.mpr_master T1 ON T0.emp_id = T1.emp_ID

SELECT T0.*
FROM Employee_Master.dbo.emp_master T0
WHERE T0.emp_id IN (SELECT T1.emp_id FROM Purchase_Master.dbo.mpr_master)

etc.

My advice is free, and you may get what you paid for.

Hypermommy30-Jul-09 3:05

Hypermommy

30-Jul-09 3:05

Will there always be a record in purchases that corresponds to each employee record? If not you may want to use a LEFT OUTER JOIN (same syntax as above I believe but replace INNER JOIN with LEFT OUTER JOIN).

If you have an employee record that has no purchases records and you use an inner join, that employee record won't show up because there's no purchases to go with it. If you use an outer join the employee record will show up with a null in the purchases field(s).

Hope that helps.

Denise "Hypermommy" Duggan

MDIChild Showdialog

leozampa7430-Jul-09 1:33

leozampa74

30-Jul-09 1:33

Hi to Everybody,
I'm using a MDIContainer with VB2005
From this Form I open a MDIChild1
From this one I need to open a new MDIChild2 Form as MDIChild Form, but I need to show it as modal because I need to do some operation only after that the MDIChild2 is closed

I try to better explain:
I Wrote:
Dim childForm As New frmMain
childForm.Text = GESTIONE_PROGETTO
childForm.MdiParent = MDIParent1
childForm.Show
...
updateGrid()
It works fine, but the Procedure UpdateGrid run even if the childForm is still open...

I Wrote:
frmMain.ShowDialog()
updateGrid()
It works fine, but the frmMain is not contained into the first form

I Wrote:
Dim childForm As New frmMain
childForm.Text = GESTIONE_PROGETTO
childForm.MdiParent = MDIParent1
childForm.ShowDialog()
updateGrid()
It doesn't work because "Form that is not a top-level form cannot be displayed as a modal dialog box. Remove the form from any parent form before calling showDialog."

Do you have some suggestions???

Best regards

Leonardo

DaveyM6930-Jul-09 1:53

DaveyM69

30-Jul-09 1:53

If it's Modal - why would you expect to be able to contain it in your MDIParent?

There are two solutions to this. The first (best) is to subscribe to the FormClosed event of the child, and call UpdateGrid from the event handler.

The other is to force the dialog to be constrained to the client area of the parent. This is a little tricky but possible. I wrote on article on this some time ago. I need to revisit it to clean it up a little, and it's in C#, but it should be obvious enough how I've done it so you can translate. Link[^].

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Dave Kreskowiak30-Jul-09 2:23

Dave Kreskowiak

30-Jul-09 2:23

leozampa74 wrote:
From this one I need to open a new MDIChild2 Form as MDIChild Form, but I need to show it as modal

MDI Child forms cannot be shown modal.

I think you need to rethink your design. I'm wondering why everyone thinks that Multiple DOCUMENT Interface means that they can show MDIChild forms as dialogs. A dialog does not edit a document, so what's the point?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

leozampa7430-Jul-09 2:38

leozampa74

30-Jul-09 2:38

I need 2 MDIChild becasuse the same ChildForm need to access to the same MDIParent Menu.
At the same time i need that the first child Form wait until the second child Form is closed.
For this reason i need MDI and Modal too.

Probably you're right, I need to rethink my design.
For the moment I'm trying to add some instructions to the formClosingevent on the second Form, but I think is not so good.

I'm not a visual basic expert, i use it only 100hours per year. Could you advice me?

VB Webcontrol If Field Exists on form

Dave Kreskowiak30-Jul-09 6:03

Dave Kreskowiak

30-Jul-09 6:03

You're missing point. Multiple DOCUMENT Interface means that each MdiChild form is designed to edit a particular document or set of data, completely independant of other MDIChild forms.

If you have one MDIChild waiting on another MDIChild, you've got a serious design flaw.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Paul Hayman30-Jul-09 0:51

30-Jul-09 0:51

Hi all,

I am very new to VB so please forgive my basic questions.

I have a webcontrol on a form that I use to populate fields on a webpage. The web page has an add another line function that in turn adds more fields to the form.

So basically I need to check if a field exists before setting the value.

WebBrowser2.Document.GetElementsByTagName("input").Item(22).SetAttribute("Value", Value)

Works, but as I stated I need to check if item(22) exists before setting it's value.

Thanks in advance for your help it really is appreciated.

Paul.

Johan Hakkesteegt30-Jul-09 2:52

30-Jul-09 2:52

What happens when you try to retrieve the value from an item that does not exist?

My advice is free, and you may get what you paid for.

Paul Hayman30-Jul-09 2:59

30-Jul-09 2:59

Following error:

System.ArgumentOutOfRangeException was unhandled
Message="Value of '25' is not valid for 'index'. 'index' should be between 0 and 20. Parameter name: index"

Thanks for your response... much appreciated.

Paul.

Johan Hakkesteegt30-Jul-09 3:04

30-Jul-09 3:04

So there is an index with a certain size at any time.

Before you try to set the value of an element, just check that the index number of that element is smaller than the length of the array.

In pseudo code:

If the_index_number_of_the_item_you_want_to_check >= items.Count Then
  'write to the item or not (I am not sure what you are trying to do)
End If

My advice is free, and you may get what you paid for.

Paul Hayman30-Jul-09 3:28

30-Jul-09 3:28

Hi Thanks again,

I think I understand, but please forgive my newbieness.

I dont know how to reference this index, I've tried several ways, but I feel like i'm shooting in the dark.

If WebBrowser2.Document.GetElementsByTagName("input").item(22) >= 1

Gives the following error:

I get an error value is not a member of 'System.Windows.Forms.HtmlElement'

What I thought I could do which also fails is:

If Exists WebBrowser2.Document.GetElementsByTagName("input").item(22) then .....  else ......

Paul.

Johan Hakkesteegt30-Jul-09 3:41

30-Jul-09 3:41

WebBrowser2.Document.GetElementsByTagName("input").Count will give you the number of items at that moment. So that is the number that you can check against.

The question is, where / how / why did you determine to do something with item(22) specifically (22 being the key question here)?

In other words your code should look something like:

If 22 > WebBrowser2.Document.GetElementsByTagName("input").Count Then
  'do something here
End If

Except that instead of 22 it really should be something like:

Dim i As Integer
'The value of i should become 22 due to some logic,
'but for the purpose of the conversation I am
'just going to assign it the value straight out.
i = 22 
If i > WebBrowser2.Document.GetElementsByTagName("input").Count Then
  'Item(i), in other words Item(22), does not exist
  'Now that you know this, do what you want here.
End If

The test you ran earlier tells us that at that exact moment Item(20) was the maximum existing number. So you shouldn't be trying to write to Item(22).

My advice is free, and you may get what you paid for.

Paul Hayman3-Aug-09 1:01