DarrenWard
IS-IT--Management
I want to copy a table structure then copy selected records from the original table.
I can copy the structure no problems and then replace the fields one by one, but can not see an easy way of copying the entire record.
The reason that I am doing this is because of a problem I am having with a report, the table I am reporting on has sales order info in it, if I want to print one sales order I do;
sele table
set filter to SalesOrderNumber = NumberRequired
do report
set filter
this works fine if the data is towards the end of the table, for some reason the old the sales order the longer it takes to print!!! so I am going to put the data in a temp cursor and print it from there.
Dazz
GuiltyMaggot - The best rock band in the world!
I can copy the structure no problems and then replace the fields one by one, but can not see an easy way of copying the entire record.
The reason that I am doing this is because of a problem I am having with a report, the table I am reporting on has sales order info in it, if I want to print one sales order I do;
sele table
set filter to SalesOrderNumber = NumberRequired
do report
set filter
this works fine if the data is towards the end of the table, for some reason the old the sales order the longer it takes to print!!! so I am going to put the data in a temp cursor and print it from there.
Dazz
GuiltyMaggot - The best rock band in the world!