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

[210 byte] By [RubenPieters] at [2007-12-28]

«« How to generates app.config for Self Host with NetTCP transport?
»» Basic Authentication usage resulting in System.Net.WebException: The request failed with HTT

# 1

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.

MattNeerincx at 2007-9-4 >

top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

# 2

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.

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

Hence query builder is not very useful!

MattNeerincx at 2007-9-4 >

# 3

"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?

RubenPieters at 2007-9-4 >

# 4

little bump :x

RubenPieters at 2007-9-4 >

# 5

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.

MattNeerincx at 2007-9-4 >

# 6

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

sousa06 at 2007-9-4 >

.NET Development Hot Topic

.NET Development New Topic

.NET Development

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech