I have one form that collects data for two tables (linked by customer_no). These tables get really large and slow the whole system down and so I want to move the data into a storage table(s) based on the date that the data was entered.This is an operation that will need to be carried out from time to time and I do not want to over write any existing storage data when I carry out future operations.
For the records that were created in the table FLIGHTS I have created a form that allows the user to input a variable to select a date to compare against two posible dates that may exist in each record(VAR-"Start_Date). I then have a button that when activated opens another form with a browse in to display the resulting records. The button on the first form is set onPush to carry out the following:
if((Flights-"Depart_date "= Var-"Start_Date
.AND.
Flights-"Return_date={})
.or.
(Flights-"Depart_date "= Var-"Start_Date .AND.Flights-"Return_date "= Var-"Start_Date),.T.,.F.)
this filters the records that I want and seems to work just fine.
Next using "Select Action from Form Menu" I have set a button on this form(MOVE RECORDS) onPush to carry out two actions: 1)select all, and 2) move the records... I am then able to select the table to move it to. In theory it should move the records to the target table that I select and delete the originals from the original table
However, I am getting an error message:SCRIPT UI_MODELESS_DLG_BOX::storage_selection@:Move Records line :86 generate_xbasic(vl) sfn not found. I have no idea what it is telling me!
I am hoping that someone can tell me in simple layman's terms what I need to do to be able to move records from two tables as may be required from time to time into either one or two storage tables that can be accessible in future... Because I am initially using two tables to collect the data in(these tables would be equivalent in nature to customer and products) I imagine that I would need to put them into two corresponding "storage" tables or can I use the customer_no to create one storage table to put all the data into?
Keeping my fingers crossed,
Angie
For the records that were created in the table FLIGHTS I have created a form that allows the user to input a variable to select a date to compare against two posible dates that may exist in each record(VAR-"Start_Date). I then have a button that when activated opens another form with a browse in to display the resulting records. The button on the first form is set onPush to carry out the following:
if((Flights-"Depart_date "= Var-"Start_Date
.AND.
Flights-"Return_date={})
.or.
(Flights-"Depart_date "= Var-"Start_Date .AND.Flights-"Return_date "= Var-"Start_Date),.T.,.F.)
this filters the records that I want and seems to work just fine.
Next using "Select Action from Form Menu" I have set a button on this form(MOVE RECORDS) onPush to carry out two actions: 1)select all, and 2) move the records... I am then able to select the table to move it to. In theory it should move the records to the target table that I select and delete the originals from the original table
However, I am getting an error message:SCRIPT UI_MODELESS_DLG_BOX::storage_selection@:Move Records line :86 generate_xbasic(vl) sfn not found. I have no idea what it is telling me!
I am hoping that someone can tell me in simple layman's terms what I need to do to be able to move records from two tables as may be required from time to time into either one or two storage tables that can be accessible in future... Because I am initially using two tables to collect the data in(these tables would be equivalent in nature to customer and products) I imagine that I would need to put them into two corresponding "storage" tables or can I use the customer_no to create one storage table to put all the data into?
Keeping my fingers crossed,
Angie
Comment