Hi Im using access 2000. and I have a strange problem.
when I execute a query on TABLE_A (TABLE_A contains 2 colums: "id"
INTEGER and "name" MEMO)
Query1:
"select id, name from TABLE_A ORDER BY name" . I get my results OK
:-)
when I extend the query and make a join with TABLE_B (conatins 2
coulmd "ref_to_tab leA" INTEGER and "value" INTEGER)
Query2:
"select id, name from TABLE_A, TABLE_B where ref_to_tableA=i d ORDER BY
name"
I get the same results but nor ordered!!! it looks like the data is
ordered in 'CHUNKS'. for example I get
id name
---- -----
1 d
4 d1
5 d2
3 a
2 aa
6 c
7 c1
TABLE_A has somthing about 35K records.
TABLE_B has somthing about 2M records.
when I get the bad results from Query2 and try to resort it by right
click on the 'name' column and choose sort, It doest work either.
another point (dont know if it is important) the 'name' columns is
unix-file-name so its values are /usr/bin/.....
any help will be appriciated.
10x
Yonatan
4  3754 
Yonatan Maman previously wrote: Hi Im using access 2000. and I have a strange problem.
when I execute a query on TABLE_A (TABLE_A contains 2 colums: "id"
INTEGER and "name" MEMO)
Query1:
"select id, name from TABLE_A ORDER BY name" . I get my results OK
:-)
As I understand it, Jet SQL does not support sorting on memo fields. So
the real question is why it worked at all.
Looks like you'll have to find/create a different sort field.
Regards
Peter Russell pr******@russel lscott.co.uk (Peter Russell) wrote in message news:<me******* *************** @russellscott.b tinternet.com>. .. Yonatan Maman previously wrote:
Hi Im using access 2000. and I have a strange problem.
when I execute a query on TABLE_A (TABLE_A contains 2 colums: "id"
INTEGER and "name" MEMO)
Query1:
"select id, name from TABLE_A ORDER BY name" . I get my results OK
:-)
As I understand it, Jet SQL does not support sorting on memo fields. So
the real question is why it worked at all.
Looks like you'll have to find/create a different sort field.
Regards
Peter Russell
10x for the answer (I didnt know that) - but any wy I need to store
String values (longer than 255 chars) - what are my options?
Yonatan
Yonatan Maman previously wrote: pr******@russel lscott.co.uk (Peter Russell) wrote in message
news:<me******* *************** @russellscott.b tinternet.com>. .. Yonatan Maman previously wrote:
Hi Im using access 2000. and I have a strange problem.
when I execute a query on TABLE_A (TABLE_A contains 2 colums: "id"
INTEGER and "name" MEMO)
Query1:
"select id, name from TABLE_A ORDER BY name" . I get my results OK
:-)
As I understand it, Jet SQL does not support sorting on memo fields.
So the real question is why it worked at all.
Looks like you'll have to find/create a different sort field.
Regards
Peter Russell
10x for the answer (I didnt know that) - but any wy I need to store
String values (longer than 255 chars) - what are my options?
Yonatan
You can store whatever you want, obviously.
But are you saying you really need to SORT on more than 255 characters?
I would just create an extra field in my query containing the first 'n'
characters from the memo field, and sort on that.
Regards
Peter Russell pr******@russel lscott.co.uk (Peter Russell) wrote in message news:<me******* *************** @russellscott.b tinternet.com>. .. Yonatan Maman previously wrote:
pr******@russel lscott.co.uk (Peter Russell) wrote in message
news:<me******* *************** @russellscott.b tinternet.com>. .. Yonatan Maman previously wrote:
> Hi Im using access 2000. and I have a strange problem.
>
> when I execute a query on TABLE_A (TABLE_A contains 2 colums: "id"
> INTEGER and "name" MEMO)
> Query1:
> "select id, name from TABLE_A ORDER BY name" . I get my results OK
> :-)
>
As I understand it, Jet SQL does not support sorting on memo fields.
So the real question is why it worked at all.
Looks like you'll have to find/create a different sort field.
Regards
Peter Russell
10x for the answer (I didnt know that) - but any wy I need to store
String values (longer than 255 chars) - what are my options?
Yonatan
You can store whatever you want, obviously.
But are you saying you really need to SORT on more than 255 characters?
I would just create an extra field in my query containing the first 'n'
characters from the memo field, and sort on that.
Regards
Peter Russell
10x, but I still cant understand why it works without the join?
I also check that if I remove some of the records ( both tables with
1K records) it work OK even with join - how come ???
Yonatan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Xenophobe |
last post by:
I have successfully converted the ASP code included in the following article
to PHP:
http://www.4guysfromrolla.com/webtech/040100-1.shtml
As described the high and low latitudes and longitudes are pre-calculated
and passed to the query.
SELECT *
FROM Locations
|
by: Scott |
last post by:
I have a view that contains the following SQL1 and it takes about 500ms
to run with Explain Plan EXP1. However, if I add an order by
clause(e.g. select * from view1 order by ID desc), it will then take
about 3 mins to return. The explain plan for the query with the order
by clause is as follows (EXP2).
The explain plan 2 shows that there is no changes to the index
selection except adding the "Sort Order by" step. The total number of...
|
by: peter pilsl |
last post by:
postgres 7.3.2
I store unicode-data in postgresql. The data is retrieved via webinterfaces,
processed with perl and then stored in postgresql (and viceversa).
All is going nice with one problem. If performing a "select * order by
field"-query the result is not what I expected.
German umlauts (ie: Ö) are stored as doublechars ("Ö" is "Ö") and only the
first char seems to be taken into account when sorting.
|
by: Hohn Upshew |
last post by:
I need some help to build a report enumerating the products in
descending order depending on the sum of liters.
In this way i can view the top products sold for a given period.But i
fail to do it.
In my query i have build a total as follows
SELECT products.Productid, products.grade, products.size, Sum(.liters)
AS SumOfliters, orders.invoicedate
FROM products INNER JOIN ((affiliates INNER JOIN Customers ON
|
by: Mike MacSween |
last post by:
I have a report based on:
PARAMETERS Forms!frmProductions!ProdID Long;
SELECT Sum(qryRoleEvent.Fee) AS SumOfFee, First(qryMusician.LastName) AS
LastName, First(qryMusician.FirstName) AS FirstName
FROM (qryEvent INNER JOIN qryRoleEvent ON qryEvent.EventID =
qryRoleEvent.EventID) INNER JOIN qryMusician ON qryRoleEvent.MusoID =
qryMusician.MusoID
WHERE (((qryEvent.ProdID)=!!))
GROUP BY qryMusician.MusoID
| | |
by: Geert Elias |
last post by:
Hello all,
When making a new table by running a make table query based on a
table,
the field I added a descending sort, is not always sorted correct.
When I run the query 10 times, almost 7 times it's sorted correct and
3 times incorrect.
Anyone who can help me with this 'bug' ??
|
by: dtwalter |
last post by:
Is it possible to ORDER BY a SubSelect? I don't see why it wouldn't
be, but I'm having some trouble. Hopefully it's just a simple error in
syntax and somebody can tell me. Here's what I'm trying to do...
I've got two tables:
Table1:
TestData Filename
Bird FileB
Blue FileA
Circle FileC
|
by: phillip.s.powell |
last post by:
Ok, you have three tables. You're supposed to be able to not only sort
(ORDER BY) according to a_name, no problem, but you must also have the
ability to sort (ORDER BY) the relationship between table_a and
table_b, that is, say you have this:
Here is where the problem lies. I am required to be able to sort by
'Phil', no problem:
|
by: padmaneha |
last post by:
Select distinct b.contributor, blogaddress,count(b.contentid) RecipeCount,isnull(c.cnt,0) Other
from weblogs.dbo.blogentries b left outer join (select contributor , count(*) cnt from weblogs.dbo.blogentries where category='food' and subcategory = 'others' group by contributor) c
on b.contributor = c.contributor
where category='food' and subcategory<>'others' and destid>0
group by b.contributor,blogaddress,cnt
When I execute the above...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: 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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
