Hello,
I have made a view in SQL Server, that consists of a join with another
view and a table. That other view
In Access, I have linked the view as a linked table. When I view the
result there, the result is not the same as in SQL Server. The problem
is that in some cases one of the joins returns two exact the same
records in stead of two different ones.
An now, the really weird part is, that when I set the Recordsource
property of the form to a select statement from the view, the form
returns the correct records, although when I run the select statement
in the Recordsource property as a query, again the wrong results are
returned.
Is there anybody who has a clue of what can be the problem here?
Thanks in advance,
Sandra
2  1516 
Sandra,
When you link your view, make sure you correctly identify the fields
constituting uniqueness.
"Sandra Setz" <ss***@wxs.nl > wrote in message
news:74******** *************** **@posting.goog le.com... Hello,
I have made a view in SQL Server, that consists of a join with another
view and a table. That other view
In Access, I have linked the view as a linked table. When I view the
result there, the result is not the same as in SQL Server. The problem
is that in some cases one of the joins returns two exact the same
records in stead of two different ones.
An now, the really weird part is, that when I set the Recordsource
property of the form to a select statement from the view, the form
returns the correct records, although when I run the select statement
in the Recordsource property as a query, again the wrong results are
returned.
Is there anybody who has a clue of what can be the problem here?
Thanks in advance,
Sandra
It sounds like, when linking the view, when you were asked to indicate which
fields uniquely identify a row, you gave a combination of fields that does not
completely define a unique row in the view output.
On 11 Dec 2003 04:51:42 -0800, ss***@wxs.nl (Sandra Setz) wrote: Hello,
I have made a view in SQL Server, that consists of a join with another
view and a table. That other view
In Access, I have linked the view as a linked table. When I view the
result there, the result is not the same as in SQL Server. The problem
is that in some cases one of the joins returns two exact the same
records in stead of two different ones.
An now, the really weird part is, that when I set the Recordsource
property of the form to a select statement from the view, the form
returns the correct records, although when I run the select statement
in the Recordsource property as a query, again the wrong results are
returned.
Is there anybody who has a clue of what can be the problem here?
Thanks in advance,
Sandra This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: sci |
last post by:
Could someone help me by answering the questions below?
What's a cursor?
What's difference between Query and View?
Is a RecordSet just part of a table? Can it be part of a query of view?
If the content in a table changed, is it necessary for a old recordset to
renew itself by do "Requery()"?
Thanks for your help!
|
by: ScottyBaby |
last post by:
Hi,
I've run into a curious problem with MS SQL Server 8.0. Using sp_help and
SQL Query Analyzer's object browser to view the columns returned by a view,
I find that sp_help is reporting stale information.
In a recent schema change, for example, someone lengthened a varchar column
from 15 to 50 characters. If we use sp_help to find out...
|
by: YURYSSG |
last post by:
I migrated a DB from Access 2000 to SQLserver 2000.
The tables are OK, but I see the old Access views... as TABLE in
SQLserver!!
Any suggestions?
--
|
by: jc |
last post by:
Hi.
A question I have is with regard to the use of views with SQL2000. If
I have a view called "A_view" and used in the following manner;
----------------
SELECT ...
FROM A_View
WHERE ....
UNION
|
by: stacdab |
last post by:
We have a partitioned view with 4 underlying tables. The view and each
of the underlying tables are in seperate databases on the same server.
Inserts and deletes on the view work fine. We then add insert and
delete triggers to each of the underlying tables. The triggers modify
a different set of tables in the same database as the view...
| | |
by: Paolo Pignatelli |
last post by:
I have an aspx code behind page that goes something like this in the HTML
view:
<asp:HyperLink id=HyperLink1 runat="server"
NavigateUrl='<%#"mailto:" &
DataBinder.Eval(Container.DataItem,"StoreEmail") & "&Subject=" &
DataBinder.Eval(Container.DataItem,"ProductName")
....
|
by: Beowulf |
last post by:
I have the view below and if I use vwRouteReference as the rowsource
for a combo box in an MS Access form or run "SELECT * FROM
vwRouteReference" in SQL Query Analyzer, the rows don't come through
sorted by Numb.
Everything I've read on the web suggests that including the TOP
directive should enable ORDERY BY in views. Does someone have an...
|
by: Andrew Lias |
last post by:
I've been given a task that I believe is, basically, impossible, but
I'd like to see if there's a way to do it.
What my boss wants me to do is to create a view, in SQL Server 2000,
that will provide not only a row number field of some sort, but that
will produce sequential ordering for arbitrary selects and orderings.
So, if my data is a...
|
by: Doug |
last post by:
Hi,
I learned a little about the model view presenter pattern at a
conference this last week and am experimenting with it. It's working
pretty well but I have a question.
I am trying to use it to reset info in a combo box. Below is some
sample code for my view interface and the presenter:
public interface IDevToolView
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
