>I have a old appliaction to be update.The program who develop this system think that he need a table can be add more field later, so he create a table like this:
>
>ID n(10), fieldname c(50), fieldvalue c(50)
>
>If there are 2 field now, the table's content will like this:
>

>ID     fieldname       fieldvalue
>__________________________________
>1      field1          value1 of 1
>1      field2          value2 of 1
>2      field1          value1 of 2
>2      field2          value2 of 2
>3      field1          value1 of 3
>3      field2          value2 of 3
>...
>

>
>My question is: How can i use a sql statement to transform this structure into a normal cursor ?
>

>field1         field2
>__________________________
>value1 of 1    value2 of 1
>value1 of 2    value2 of 2
>value1 of 3    value2 of 3
>....

3 SQLs:

1) Select ID, FieldValue as Field1 where FieldName = "Field1" into cursor curField1

2) Select ID, FieldValue as Field2 where FieldName = "Field2" into cursor curField2

3) select curField1.ID, Field1, Field2 from curField1 inner join curField2 on curField1.ID = curField2.ID into cursor curFinal