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