Query Returning Dodgy Result

In Distress · January 11th, 2007, 06:18 PM

Howdy all, I must be going for a record, 2 posts in 2 days, hopefully this trend doesn't continue....

The short and thick of it. I have a query called 'FindNextCall' that is simply used to find the first row in my table that is blank. The table is called 'Prospect_CallDetails' and the query goes something like:

Code:

SELECT ID 
FROM Prospect_CallDetails
WHERE (No_Answer = 0) AND (Fax_Machine = 0) AND (Not_Interested = 0) AND (Engaged = 0) AND (CallBack = 0) AND (Disconnected = 0) AND (Wrong_Number = 0) AND (Answering_Machine = 0) AND (Suspend = 0) AND (Completed = 0) AND (No_Prospects_Paid = 0) AND (No_Prospects_Unpaid = 0) AND (Allocated_Tickets = 0) AND (Paid_Tickets = 0) AND (CallAttempt = 0)

Now, when I preview the data that the query returns using the 'Preview Data' option in the DataSet1.xsd tab, I get the right result, but when I try using the query I get a totally different result. I want to populate a textbox (called IDTextBox) on a form as I have other fields that have a dependency on the value of the IDTextBox. The way I am trying to populate the textbox with the query result is a follows: (The below snippet lives in the Form1_Load Procedure)

Code:

Me.IDTextBox.Text = Me.Prospect_CallDetailsTableAdapter.FindNextCall(Me.DataSet1.Prospect_CallDetails)

When I execute the project, it's returning a value to the textbox that is completely wrong. Is there a bug or something that I've done wrong? When I set a watch to see what value is being assigned, it's returning a value of say 1 instead of say 5. Have I done something wrong?

Cheers in advance

rodmcleay · January 11th, 2007, 09:44 PM

Hi In Distress,

Your query seems fine and you have proven that with your data preview.
From your previous question I would have expected this assignment to work but as I said before it suprised me that it did at all.
If you could try the assignment again with the full syntax and let me know how that goes.
Me.Prospect_CallDetailsTableAdapter.FindNextCall(M e.DataSet1.Prospect_CallDetails).Tables[0]["ID"].ToString();
Again, I haven't tested the syntax, but should be pretty close, your intellisence should be able to straighten it out if there is any syntax errors
Rod

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

In Distress · January 11th, 2007, 11:21 PM

Hi Rod,

I tried your suggestion but it seemed to be a no go. When I placed a fullstop after "(Me.DataSet1.Prospect_CallDetails)" the intellisense doesn't seem to kick in, almost as though it has recognised that the closed brackets signifies the end of the call. If I continue you to type it irrespective of this, I get a syntax error under the 0 in the "[0]" with an error that says "Identifier expected. There is also a blue squigly line under "Me.Prospects_DetailsTableAdapter.FindNextCall ", with the message "'FindNextCall' is not a member of 'WindowsApplication1.DataSet1TableAdapters.Prospec t_CallDetailsTableAdapter'".

Any thoughts, or am i just so thick that I've missed something obvious?

rodmcleay · January 12th, 2007, 12:55 AM

Hi,
This is a type

Code:

Me.DataSet1.Prospect_CallDetails

and should be used like this to instansiate an instance of it.

Code:

Me.DataSet1.Prospect_CallDetails ds = new Me.DataSet1.Prospect_CallDetails();
Then you use the ds when passing as a paramter.

However, that would pass an empty datatable to that method, which I doubt is your intent, but I may be wrong, I dont know your business needs.

At any rate I would have expected the compiler to complain about the paramter not the method.

So can you confirm that the .FindNextCall method exists and tell me what its parameter type is?

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

rodmcleay · January 12th, 2007, 01:19 AM

Sorry, I've mixed my languages in this, you are using VB.
I cant say for sure wha the VB syntax is off hand but the I think its something like
dim ds as new Me.DataSet1.Prospect_CallDetails

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================