i have a "roads" geodatabase in access. there is a table "nodes" which has fields ID(auto number), Shape(OLE Object) , Position_X(numb er) Position_Y(numb er) and node_number(num ber). Field node_number has duplicated values. i want to make a new table so that my field node_number do not have duplicate values. when i do it does not allow me. here is query.
SELECT distinct node_number, POINT_X, POINT_Y, Shape FROM nodes;
error message is that i can't have shape with unique value. when i remove distinct it does. i.e following query works.
SELECT node_number, POINT_X, POINT_Y, Shape FROM nodes;
how to solve this problem.....
regards
@rtist
2 1281 NeoPa 32,568
Recognized Expert Moderator MVP
I'm not sure you can get around it - that's what the err msg is trying to say.
Grouping on all those fields may work - just an idea.
MMcCarthy 14,534
Recognized Expert Moderator MVP
i have a "roads" geodatabase in access. there is a table "nodes" which has fields ID(auto number), Shape(OLE Object) , Position_X(numb er) Position_Y(numb er) and node_number(num ber). Field node_number has duplicated values. i want to make a new table so that my field node_number do not have duplicate values. when i do it does not allow me. here is query.
SELECT distinct node_number, POINT_X, POINT_Y, Shape FROM nodes;
error message is that i can't have shape with unique value. when i remove distinct it does. i.e following query works.
SELECT node_number, POINT_X, POINT_Y, Shape FROM nodes;
how to solve this problem.....
regards
@rtist
Because Shape is an OLE Object it is probably causing problems.
As NeoPa says try a GROUP BY first including shape in the group by then excluding it. -
-
SELECT node_number, POINT_X, POINT_Y, Shape FROM nodes
-
GROUP BY node_number, POINT_X, POINT_Y, Shape;
-
or -
-
SELECT node_number, POINT_X, POINT_Y, Shape FROM nodes
-
GROUP BY node_number, POINT_X, POINT_Y;
-
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: sridevi |
last post by:
Hello
How to export data from ms-access database to excel worksheet using ASP.
mainly i need to export data to multiple worksheets. it is very urgent to
us.
i have a sample code which works only exporting to single worksheet. but i
need to export data to multiple worksheets.
it is very urgent to us. so please help me in code.
|
by: gary.scott |
last post by:
Aaaaaarrgghh ! (that's better)
I am trying to convert a field within my Oracle 9i Database that is of
type BLOB (but this BLOB may contain a combination of clobs/varchars or
images such as gif images, jpg images) to Microsoft SQL Server 2000
using Microsoft DTS.
On trying to perform this simple conversion I recieved the error "Need
to run the object to perform the operation - Exception Access
Violation" from Microsoft DTS and my table...
|
by: TrvlOrm |
last post by:
I am having great difficulty in these asp scripts, using VBscript and
JavaScript.
I have 4 files that all need to be linked together.
The first file "Books.html" - needs to search for a Book title, author
or ISBN number from a Access database called "Books.mdb". When the
user clicks Submit from the "Books.html" file (after inputting info in
a text box and clicking the required box to define Title, Author or
ISBN), the information is...
|
by: Jucius |
last post by:
After a common use of Access with a Delphi Application, I restart the
application an it does not succeed in accessing the database. (after 3
months of use, nothing special was done !)
I try to use it with access and I have a problem opening a table (Database
Format Not Known !). The other tables are OK.
When I try to compact the database, it simply delete the table that is
concerned and indicate an error -1206 ?
The problem happened 3...
|
by: ral amo |
last post by:
We've a project for which we are using MS Access as the back end and VB
as front end. there are three terminals fromn whichusers access the
system. The table has 17 rows. When the number of records reach 12000
the system hangs.
Does anybody know what's the reason for this?Is table size or database
size is a limitation of MS ACeess. Pls help. It's very urgent.
| |
by: Xeijin |
last post by:
URGENT
I have an assignment to hand in tomorrow, I need to know how to perform
numeric calculations in access, I dont know very much about databases
so consider this a beginner's query!
Well basically this is what I'm aiming at, its nothing too complicated
really.
I have a table called RESOURCES which keeps track of all of the stock
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
|
by: TexCube |
last post by:
Hello everyone,
I have an urgent question. Can data be pulled from an access database table to create a directory that can be printed out and bound together?
I need to have each row of a database populate a preset page that will be used as a classmate directory. Each page will have info pertinent to an individual classmate. (one page per classmate) I don't want to input the data into a form since it's already been done into an Excel...
|
by: =?Utf-8?B?TUNN?= |
last post by:
I'm sure the answer to my question varies depending on the situation, but I
am looking for a general "best practice".
If I have an asp.net application and I load certain data from a database,
should I use ViewState to store and reload the data, or should I load the
data from the database on each postback?
Assume for the sake of this question that I only care about performance, I
don't care about ease of programming.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |