Thanks Peter,
I have been getting around it by calling
the RowID from the temporary table Commandinfo(CMD_INFO_ROWID) when I need it
for my variable but it would be nice to be able to simply select the RowID into
the query as a column. But it looks like it can’t be done without
creating a table and updating a column.
Cheers
Percy
From:
Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]
Sent: 02 August 2006 15:40
To: Bell,
Percy; [email protected]
Subject: RE: [MI-L] RowID question
[SEC=UNCLASSIFIED]
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
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of Bell,
Percy
Sent: Wednesday, August 02, 2006
4:49 AM
To:
[email protected]
Subject: [MI-L] RowID question
[SEC=UNCLASSIFIED]
Guys,
I may be showing my
ignorance but I can’t 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 couldn’t 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.
_______________________________________________________________________________________________________
|
