Query that will change Lightswitch 2011

Question

0.00/5 (No votes)

See more:

I am new to Lightswitch 2011.

All I want to do is run a query that will show text message if results are returned and another text message if false.. I can do this , but when the query does not change, the message does not appear.

I know it is because I used the Procedure SelectionChanged below. What else could I possibly used.

VB

Private Sub Query1_SelectionChanged()
            Dim TotalCount As Integer

            TotalCount = Me.Query1.Count

            If TotalCount = 1 Then
                Me.ShowMessageBox("This is a Bostik Part. Please check batch card again")


            End If

            If TotalCount = 0 Then
                Me.ShowMessageBox("Please Press Enter to continue")
            End If


        End Sub

Look forward to hearing from you

Posted 1-Aug-12 12:35pm

Member 9328877

Updated 1-Aug-12 12:36pm

Kenneth Haugland

v2

Add a Solution

Comments

Kenneth Haugland 2-Aug-12 11:41am

I dont completely understand what you are getting at here. so the query count dosent change, but the items might. Is that waht you want the trigger to see?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kenneth Haugland · Answer 1 · 2012-08-02T15:17:00

Solution 2

You should get the TextChange event and check for e.Key = Enter.

Posted 2-Aug-12 15:17pm

Kenneth Haugland

Comments

Member 9328877 2-Aug-12 21:24pm

Hi Kenneth,

Thanks for the info.
I also need to display a message if the text does not change. Fo r exmplae if the text is 3 then a message box appears "Warning"
After closing Message box and user enters 3 again, the message box does not appear.

Do you know how to resolve this?

Look forward to hearing from you.

Thanks

Kenneth Haugland 2-Aug-12 23:32pm

Well, you need to check an oldlist against a new list to see if they are equal.