General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Moving data into another cursor
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only