I need to create a Version 11 XBASIC script to summarize, update, then post data from one of my tables to a destination table. Since I'm lousy at V11's XBASIC I figured I would try to use the Control Panel's Operation feature. My intent was to define the operation without using its Genii because the screens are indentical to those I've used in Version 1. Well, it's not being very accommodating.
I selected my table name, gave it the name of my results table and began entering. First I entered a field "cust_sn" with a summarization of "Group By" and then "inv_date" with "max". I took a peek at the Xbasic it's generating and it looked great, lots of summarization syntax. Then I entered my 3rd field which is really an expression. I used the down arrow to select "expression" and the Expression Builder dialogue opened up and I entered my expression.
I then took a look at the Xbasic it was generating and it was blank. No Xbasic at all. I remove the expression and the previous Xbasic has returned. This is a very hostile thing to do to a newbie! :>) So my first question is why won't it let me enter expressions?
Assuming I get past this obstacle, the Summarization I want will require 2 user input variables. This software appears to be "variable friendly" so I clicked "var" and entered my first variable and variable type. This dialogue closes and there's no variable anywhere. I tried to RUN to see if I would be prompted and received an error.
Please don't ask me to use Alpha's Help facility. I did and it totally stunk. Instead of leading me through this from A to Z, it stopped at B. Doesn't even mention variables let alone guide me through entering them.
Well I'm stuck and unhappy. Are there any kind souls out there who can steer me through this?
Thanks ... Sam
I selected my table name, gave it the name of my results table and began entering. First I entered a field "cust_sn" with a summarization of "Group By" and then "inv_date" with "max". I took a peek at the Xbasic it's generating and it looked great, lots of summarization syntax. Then I entered my 3rd field which is really an expression. I used the down arrow to select "expression" and the Expression Builder dialogue opened up and I entered my expression.
I then took a look at the Xbasic it was generating and it was blank. No Xbasic at all. I remove the expression and the previous Xbasic has returned. This is a very hostile thing to do to a newbie! :>) So my first question is why won't it let me enter expressions?
Assuming I get past this obstacle, the Summarization I want will require 2 user input variables. This software appears to be "variable friendly" so I clicked "var" and entered my first variable and variable type. This dialogue closes and there's no variable anywhere. I tried to RUN to see if I would be prompted and received an error.
Please don't ask me to use Alpha's Help facility. I did and it totally stunk. Instead of leading me through this from A to Z, it stopped at B. Doesn't even mention variables let alone guide me through entering them.
Well I'm stuck and unhappy. Are there any kind souls out there who can steer me through this?
Thanks ... Sam
Comment