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
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 table where colA = num1 and col2 = num2 Update
selection set colC = num3
-Original
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
, 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 PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MI-L SQL Query
I have
.
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 PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MI-L SQL Query
I have a table that I
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 is
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 20 records, or to see only 20
records of the 100 records. If yes, how?
Regards
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 you want to see
: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 20 records, or to see only 20
records
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
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 WARD_NO, TENURE_TYPE ORDER BY WARD_NO,
TENURE_TYPE Into RESULTS_TABLE
If you are using
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 -
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 option type:
Select Columns: *
from
-04-2002 03:16 Vedr.: RE: MI-L SQL query to group data
on classifications
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
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
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
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
20 matches
Mail list logo