The schema returned by the new query differs from the base query.

Well I'm trying to make a query but everytime I hit the 'ok' button when I'm done in the Query Builder it says the message that is in my title.

What am I doing wrong :(

Thanks in advance

.NET Development15

I checked our internal bug database and this appears to be by design, you cannot add or remove columns from the query builder. Seems a bit odd, but there you have it.

From bug:

Repro steps:
1. Create a VB Windows Application
2. Add a database connection to server poutine, database Northwind, ...
3. Add a new DataSource to the project, includ Customers table
4. Drag and drop Customers from DataSources window on to Form1
5. Data -> Add Query...
6. Remove one of the columns from the default query, Click OK

Result:
---------------------------
Search Criteria Builder
---------------------------
The schema returned by the new query differs from the base query.
---------------------------
OK
---------------------------

This is considered by design that you get this error message.

Hence query builder is not very useful!

"Add a database connection to server poutine, database Northwind, ..."

And how do I do this

"Hence query builder is not very useful!"

Is there another way to make query or querylike things then

little bump :x

I really don't understand what you are trying to do perhaps if you give me a step by step way to reproduce the problem I will understand where things are going wrong. In general you don't need to use the query builder if you are using the data controls, you just drag and drop your table from the server explorer and you're done.

Hi all,

I have this msg too and need some help.

I did a add query.

The origina sql statement :

SELECT PassengerID, MobileNumber, NRICNumber, FirstName, LastName, Address, ScheduleNumber FROM Passenger

After editing:

SELECT Passenger.PassengerID, Passenger.MobileNumber, Passenger.NRICNumber, Passenger.FirstName, Passenger.LastName, Passenger.Address,
Passenger.ScheduleNumber, Subscription.Service
FROM (Passenger INNER JOIN
Subscription ON Passenger.PassengerID = Subscription.PassengerID)
WHERE (Passenger.MobileNumber = )

I am able to view it inside query builder but when i click 'OK' in search criteria builder, it returns 'The schema returned by the new query differs from the base query. Please Help.

Thanks in advance

sousa06