Hi Peter
- add the new column as float
- run table / update column and specifiy "colxx-771.49"
Mit freundlichem Gruss / Best Regards
Flavio Hendry
TYDAC NEWS http://www.tydac.ch/german/index.php?menu=News_actual
---
Sergi
Select blah from blah where blah into selection (or into csrMyQuery)
Select blah from selection (or from csrMyQuery) where ...
Terry
-Original Message-
From: Gamiz Ribelles, Sergi (Regsa) [mailto:[EMAIL PROTECTED]
Sent: 20 July 2004 14:55
To: Mapinfo-list (E-mail)
Subject: MI-L sq
Thanks to those who answered my simple query.
Answer is you can't do this directly in the update command. Just
perform the required selection and update from that!, as from Martin
Higham:
Select * from where = num1 and = num2 Update
selection set = num3
-Original Message-
From:
om: Norman Mabunda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 15, 2004 8:45 AM
> To: Peter Horsbøll Møller; [EMAIL PROTECTED]
> Subject: RE: MI-L SQL Query
>
>
> Thanx Peter
>
> Another question: Is't possible 1000 records count to see
> only a certail numb
Very much answered. Thanks a mil.
>>> "Uffe Kousgaard" <[EMAIL PROTECTED]> 01/15/04 09:59AM >>>
To do that, you will have to add a field called "ID", update it to contain
rowid (i.e. 1, 2, 3,) and then include a where clause in your SQL:
where rowid<=20
or
where rowid>=20 and rowid<=100
If y
2004 8:45 AM
> To: Peter Horsbøll Møller; [EMAIL PROTECTED]
> Subject: RE: MI-L SQL Query
>
>
> Thanx Peter
>
> Another question: Is't possible 1000 records count to see
> only a certail number of records. For instance, of the 100
> records count, to see the 1st
To do that, you will have to add a field called "ID", update it to contain
rowid (i.e. 1, 2, 3,) and then include a where clause in your SQL:
where rowid<=20
or
where rowid>=20 and rowid<=100
If you want to see only the top 20 records in the output (i.e. after the
group by), then the answer i
n & IT moved from Rugaardsvej 55, 5000
Odense C to Odensevej 95, 5260 Odense S.
Please note our new telephone, direct and telefax numbers.
> -Original Message-
> From: Norman Mabunda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 15, 2004 8:14 AM
> To: [EMAIL P
ardsvej 55, 5000
Odense C to Odensevej 95, 5260 Odense S.
Please note our new telephone, direct and telefax numbers.
> -Original Message-
> From: Norman Mabunda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 15, 2004 8:14 AM
> To: [EMAIL PROTECTED];
> [EMAIL PROTE
I have a table that I wanted to do a similiar thing to what Andrew Tracey wanted to do.
Please see the attachment to see what I did:
Select Columns: Province, Type, Count(Sub_Type) "5"
>From Tables:National_Health_Facility_List_
Where Condition:
Group By Columns: Sub_Type
O
t: Wednesday, January 14, 2004 7:38 PM
> To: [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: MI-L SQL Query
>
>
> Yes, the query would go something like this:
>
> Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) "How_Many"
> From MY_TABLE GROUP BY
Yes, the query would go something like this:
Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) "How_Many"
>From MY_TABLE
GROUP BY WARD_NO, TENURE_TYPE
ORDER BY WARD_NO, TENURE_TYPE
Into RESULTS_TABLE
If you are using the SQL select dialog, the first line above is the
'Select Columns', the second
Rich,
Assuming your points and regions are in the same table (called "Data") which
contains a unique ID column (Called "ID"), try the following series of
queries, in the given order:
**
SELECT ID, Obj FROM Data INTO TPoi
Str$(obj) = "text" is much simpler
-Original Message-
From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 26 June 2002 4:55 PM
To: 'Andrew Tracey'; '[EMAIL PROTECTED]'
Subject: RE: MI-L SQL Query
Andrew,
>From the Query, SQL Select opt
Andrew,
>From the Query, SQL Select option type:
Select Columns: *
from Tables: your_table_name
Where: str$(objectinfo(obj,1)) = "n"
with n representing one of the following numbers:
1 - arc
2 - ellipse/circle
3 - line
4 - polyline
5 - point
6 - layout window frame
7 - region
8 - recta
"DPC"
,
tzero.net> <[EMAIL PROTECTED]>
cc:
09-04-2002 0
Seems like you have 90% of it figured out. I'll assume your
table is called MyTable and the field where you are storing
your group sums is MyField [as a Char(4)]. If you take your
last expression (where you get "TFFF" for up to 1,000,
"TTFF" for 1,000 to 5,000, "TTTF" for 5,000 to 10,000, and
"T
The only way I can think of is to add a column, say "GroupPos", populate it,
and query where GroupPos <= 3. If your table is large you can populate it
quickly be writing a short MabBasic application. I'd be glad to help with
this if you need.
Michael Hanna
-Original Message-
From: Ron
Hi,
Thought to just comment on the "don't know how you'd join all three =
tables within a single SQL".
Joining 3 tables in a single SQL proves to be powerful, time saving and =
does not clutter your disk with unecessary temporary files. The way to =
do this requires a syntax rule which I will
Hi Jacqui,
I don't know how you'd join all three tables within a single SQL, but
the following query should help calculating the overlap without doing
the cookie-cutter thing. You'll just have to run it twice - once for
hard veg and once for soft.
set area units "hectare"
select
Matt,
I think its a question of syntax. I just tried a similar statement with no
trouble:
ie
Str$(objectinfo(obj,2))="Pen(1,2,65280)"
should be written:
Str$(objectinfo(obj,2)) like "Pen (1, 2, 65280)"
note the use of "like" and the spaces between the word Pen and the "(" and
also after the comma
Matt,
A simple precision first: objectinfo(obj,2) is not the object type (value is
1, not 2).
What you get with 2 is the symbol, text font or pen style of the object,
dependent on its type. The way the result is displayed is the printable
translation of the style contents. In fact the contents a
22 matches
Mail list logo