|
Percy,
Unfortunately you can't select the ROWID
"column". You have to update a column with the ROWID value and then use this static
column instead.
You can however use the ROWID to select certain records, by adding the
condition to the where clause
Peter Horsbøll Møller
GIS Developer, MTM
Geographical
Information & IT
COWI A/S
Odensevej
95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
"For enden af
regnbuen..." - hvordan kommer man dertil og er
det overhovedet muligt?
Læs mere om årets MapInfo konference på
www.cowi.dk/mapinfokonference
Guys,
I may be showing my
ignorance but I cant seem to include RowID in an SQL
query.
EG:
Select Col1, Col2,
Col3, ROWID RowIdentifier from
I dug up an old
post:
|
[MI-L] Returning RowID in the Select Statement
(SQ |
|
Author: Ben
A
Greenberg (207.250.113.---)
Date: 03-25-2006
08:17
I am querying a large dataset and would like the select
query to return the RowID as a temporary column.
Can this be
done.
When i run the following query: |
|
But couldnt find and
answer.
Can anybody
help?
Cheers
Percy
Percy
Bell
Research Statistics and
Technology Branch
Phone: (02) 6271
1463
Mob:
(0415) 260 805
Fax: (02) 6271 1144
Department of
Communications,
Information Technology and the Arts
GPO Box 2154,
Canberra ACT 2601 Australia
URL:http://www.dcita.gov.au
Email: [EMAIL PROTECTED]
_______________________________________________________________________________________________________
The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material.
Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties.
If you have received this e-mail in error please notify the Security Advisor of the Department of Communications, Information Technology and the Arts, telephone (02) 6271-1880 and delete all copies of this transmission together with any attachments.
For all other enquiries please ring (02) 6271-1000.
_______________________________________________________________________________________________________
|
|
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
