Rownum

Hi folks,
SELECT * FROM mytable
100 rows returned.
Can i get a rownum column for each record; i.e. if 100 records returned; rownum order 1,2,3....100 along with the each record position.
is it possible without using cursor?
Howdy!see http://www.dbforums.com/t1058224.html|||Assuming that you have atleast one primary key or at least a unique constraint:

Select Count(RowTable.UniqueField) as RowNumber, Mytable.Fields
from Mytable
inner join Mytable RowTable on Mytable.UniqueField >= RowTable.UniqueField

Even I had the Same problem. Thanks To Blindman for his help regarding the query.|||Thanx to r937 and blindman! :)|||Assuming that you have atleast one primary key or at least a unique constraint
Also: NULL values won't be counted. In the other thread the values were used as columnnames, so NULL is quite unlikely. Not sure about myTable.sql

Rotate fields

Hi folks,
Is there a way to rotate a field 90 degrees?
Thank's in advance,
Staffanyes check out the properties of the field there ll b a property like
DIRECTION (exactly name is not remebered) but that property helps
adjusting direction of the text in the textbox like left to right,right
to left, top to bottom etc check it ou|||Is there any documentation on the syntax for this?
I only see two options:
lr-tb
tb-lr
It seems that I am rotating the text Ok, but I just need it to be turned
180% degree the other way. Are there any docs on this? I've scoured the
forum but can't find any topics already on this.
Thank!
"** Spirits **" wrote:
> yes check out the properties of the field there ll b a property like
> DIRECTION (exactly name is not remebered) but that property helps
> adjusting direction of the text in the textbox like left to right,right
> to left, top to bottom etc check it ou
>|||as per my knowledge only these two possibilities lr-tb n tb-lr r
possible if u get anything else plz let me know as well