subroutine (AREV Specific)
At 29 SEP 1998 06:54:39PM danshane@mail.westco.net wrote:
AREV 3.12,Trying to post records to multiple tables, I understand the
setup that has to be done in paint. The problem is I have relatively
no experience with R/Basic. I learn better by example than I do by
reading a book. If I have an example that relates to what I am trying
to do, I can then compare the example and apply the logic to my scenario. No, Im not trying to get someone to write a freebie subroutine for me, but the examples in the book are mostly meaningless. I need to post data from specific fields in one table to the same name, and type of fields in another table. None of these are multivalued or symbolic fields. The table that I am trying to post to has a three part key, I'm not sure that has anything to do with it or not? If someone could point me in the right direction, ie.. a quick example of the syntax, etc.. If I am also correct the subroutine has to be compiled and cataloged?
Also, if someone could recommend a "very" basic book on BASIC or perhaps PICK, since it appears to be quite the same. Any help would be greatly appreciated, Thanks in advance…
At 30 SEP 1998 02:30AM Curt Putnam wrote:
Dan,
I'm not entirely sure where you are lacking understanding - so I'll try the following outline…
Set up a set of equates for each file with a different prefix for each field. For example, if you have a name field in several files, prefixes could be:
Cus_Name$
Owe_Name$
Ven_Name$
All this does is allow you to use a nice pneumonic instead of
something like OutRec
Your commuter will have some code in it on the order of:
OtherRec=@Record
.
.
.
OtherRec=@Record
Write OtherRec to OtherFileHandle, OtherFileID
If this doesn't make sense, feel free to call me @ 909.944.7468 or email @ cputnam@vividnet.com
Curt
At 01 OCT 1998 09:48AM Aaron Kaplan wrote:
OK, quick lesson.
In ARev, the contents of the window are stored in @RECORD. @RECORD also contains any other portion of the record that might not be displayed. When all the smoke and mirrors and magic is over, writing the record to disk is simply
WRITE @RECORD TO WC_SRC_FILE%, @ID THEN..ELSE…
@ID contains the record key
WC_SRC_FILE% is a common variable that contains the handle to the file. We can go more into window common later.
Assuming you are writing the entire record to a different file then all you need to do is place a post-save routine that has
WRITE @RECORD TO NEWHANDLE, @ID THEN…ELSE…
You'll have to open the new file yourself, but other than that, it's very straight-forward.
If you plan on only putting some fields in the new record, then you will have to write code, like Curt suggested, to pull out the appropriate fields.
If you have to do this, use a different variable than @RECORD for the storage. @RECORD is a special variable and is linked into the window. If you modify that, you modify the results of the data appearing on the screen.
I'm assuming you know where to put all this stuff in on the window, but if you don't know, post and we'll tell you.
akaplan@sprezzatura.com
