I've attached a file that is a derivative of the Alpha Sports app that contains a subset of the tables and files - the ones that I'm having a problem with. Here's a list of the problems:
1) When the Main Menu form opens for the first time, the title text and first button text is oversized. This goes away the 2nd and subsequent times you open it, but returns every time you exit Alpha 5 and start it again. I've tried changing the font, the style, and anything else I could think of, to no avail.
2) When I run the ShipListExport operation, it's imbedded query finds the right 3 records from customersales.set for the 3 items that need to be shipped to the one customer, but then exports nothing from the customer table (should export name and shipping address).
3) In attempting to create an Action Scripting operation based on the customersales.set (with customer as parent, invoice_header as child, and invoice_items as invoice_header's child) to export only those customers who need to have something shipped (Invoice_header->Allpaid=.t. .and. Invoice_items->Ship=.t. except I left out the .t.s), if I select by expression, then the only table I can choose fields from is Customer, if I drill down through the expression builder.
4) When I try to create an Action Script to Run the ShipListExport operation and designate the query as part of the script, I encounter what seems at best confusing results in trying to build the query using the various means offered - specifically the Genie and the Expression Builder. Sometimes multiple tables are offered (which is good) - sometimes only customer is offered. In any case, the query doesn't yield the desired results.
5) On the full data file, when I browse the set, the last record (the same customer who needs the shipment), has five records, not three. I can delete the first of the five records while in the set, but not the last. I've tried packing, re-indexing, and everything else I can think of, but I just can't get rid of that superfluous record, which has no Invoice_ID, and doesn't show up as a blank record in any of the three tables.
Any suggestions anyone can offer on any of the 5 problems would be much appreciated!
Many thanks,
Dave Whittle
1) When the Main Menu form opens for the first time, the title text and first button text is oversized. This goes away the 2nd and subsequent times you open it, but returns every time you exit Alpha 5 and start it again. I've tried changing the font, the style, and anything else I could think of, to no avail.
2) When I run the ShipListExport operation, it's imbedded query finds the right 3 records from customersales.set for the 3 items that need to be shipped to the one customer, but then exports nothing from the customer table (should export name and shipping address).
3) In attempting to create an Action Scripting operation based on the customersales.set (with customer as parent, invoice_header as child, and invoice_items as invoice_header's child) to export only those customers who need to have something shipped (Invoice_header->Allpaid=.t. .and. Invoice_items->Ship=.t. except I left out the .t.s), if I select by expression, then the only table I can choose fields from is Customer, if I drill down through the expression builder.
4) When I try to create an Action Script to Run the ShipListExport operation and designate the query as part of the script, I encounter what seems at best confusing results in trying to build the query using the various means offered - specifically the Genie and the Expression Builder. Sometimes multiple tables are offered (which is good) - sometimes only customer is offered. In any case, the query doesn't yield the desired results.
5) On the full data file, when I browse the set, the last record (the same customer who needs the shipment), has five records, not three. I can delete the first of the five records while in the set, but not the last. I've tried packing, re-indexing, and everything else I can think of, but I just can't get rid of that superfluous record, which has no Invoice_ID, and doesn't show up as a blank record in any of the three tables.
Any suggestions anyone can offer on any of the 5 problems would be much appreciated!
Many thanks,
Dave Whittle
Comment