Hi Pablo,

Is there a naming convention that follow when changing the field names for the cursors?
i.e. SELECT FNAME as C_FNAME

If so, you can use the AFIELDS() function and create the cursor with the CREATE CURSOR ... FROM ARRAY ... command. Or use the FIELD() function in a loop to create the select statement to create the cursor.

HTH,
Arriyel

>I have several free tables- I need to –in runtime- read the info from those tables, process the data, and then create a cursor with the same data but inside a cursor with other field names –because there are tons of reports that uses our old data naming convention-.
>
>
>
>It’s a simple SELECT xxx as yyy ….
>
>
>
>I was wondering if there’s an automated way –tool- to do this job. Because there are many reports and too many fields nad tables.
>
>
>
>I´m developing something like two grids and a drag and drop… then it will builds the sql sentence that will create the cursor that will be used by the Reports. But I would love to hear if anyone has solved a similar problem in a more efficient –fast- way.
>
>
>
>TIA,
>
>
>
>Pablo Sebastian Velazco
>
>Dpto.Sistemas Moretti