Hello Alpha5'ers
I am in need of some assistance. I am new to both Alpha 5 and the basic language. I�ve searched the forum, but didn�t find anything that helped. By the way, everything I am doing in A5 is with the genies. First, I will describe what I am attempting to do and then I�ll describe the issue. I have two A5 tables. I need a subset of records from the Primary table and a subset of records from the transaction table. I need to keep only those records where the primary key exists in both the primary table subset and the transaction table subset. In other words, I need the intersection of the two subsets. The first thing I did was create two Copy Operations to extract the needed records from each table. Then I created a Set with the two new tables. In the link definition, I selected to include records from the primary table only if a matching child record DOES exist. This worked great and I created a browse and report from this set of records. Now the process needs to be menu driven for end users. It is the automation process that has caused my road block. On the code tab using action scripting, I set up actions to run the �copy� operations and open the browse. Running the code generates a message, which says, �The current table cannot be overwritten.� However, running the copy operations manually from the operations tab, the tables are overwritten. Why the difference? I have added zapping and packing actions prior to the copy operation but that did not make a difference. I tried using only one copy operation, where I created a subset of Primary table with a copy operation and linking that to the �transaction� table. I also tired inserting a table.close() command into the script that was created by the genie and couldn�t get that to work at all. I am sure there is a piece of the puzzle that is missing. But I am at a loss as to why the copy operation will not work when called via action scripting. Any assistance is appreciated. Thanks, Sherry.
I am in need of some assistance. I am new to both Alpha 5 and the basic language. I�ve searched the forum, but didn�t find anything that helped. By the way, everything I am doing in A5 is with the genies. First, I will describe what I am attempting to do and then I�ll describe the issue. I have two A5 tables. I need a subset of records from the Primary table and a subset of records from the transaction table. I need to keep only those records where the primary key exists in both the primary table subset and the transaction table subset. In other words, I need the intersection of the two subsets. The first thing I did was create two Copy Operations to extract the needed records from each table. Then I created a Set with the two new tables. In the link definition, I selected to include records from the primary table only if a matching child record DOES exist. This worked great and I created a browse and report from this set of records. Now the process needs to be menu driven for end users. It is the automation process that has caused my road block. On the code tab using action scripting, I set up actions to run the �copy� operations and open the browse. Running the code generates a message, which says, �The current table cannot be overwritten.� However, running the copy operations manually from the operations tab, the tables are overwritten. Why the difference? I have added zapping and packing actions prior to the copy operation but that did not make a difference. I tried using only one copy operation, where I created a subset of Primary table with a copy operation and linking that to the �transaction� table. I also tired inserting a table.close() command into the script that was created by the genie and couldn�t get that to work at all. I am sure there is a piece of the puzzle that is missing. But I am at a loss as to why the copy operation will not work when called via action scripting. Any assistance is appreciated. Thanks, Sherry.
Comment