Alpha Video Training
Results 1 to 4 of 4

Thread: TABLE.EXTERNAL_RECORD_CONTENT_GET() problem

  1. #1
    Member
    Real Name
    brett sinclair
    Join Date
    Aug 2002
    Location
    Wellington, New Zealand
    Posts
    858

    Default TABLE.EXTERNAL_RECORD_CONTENT_GET() problem

    I have reproduced below the A5 documentation on the "TABLE.EXTERNAL_RECORD_CONTENT_GET()" method. It refers to the related "<TBL>.RECORD_CONTENT_GET()" method which is quicker running and can be used when a pointer to the table concerned is already available.

    The problem I have is that on trying to use the latter method I get an error message "... method not found".

    The link to documentation on this method is broken, so I can't locate its details. But presumably the parameter syntax is slightly different because why would a table name need to be specified if there is a pointer to it already available? (That's a rhetorical question).

    So what I would really like to know is this:

    Q1: Does the method <TBL>.RECORD_CONTENT_GET() exist?

    Q2: What is the correct parameter list syntax?

    Hopefully then, the good folk at Alpha Software will be able to fix the documentation error.

    The documentation I am using is the full .chm file dated 20 October 2006, the one that's about 37 MB in size.

    Many thanks.

    TABLE.EXTERNAL_RECORD_CONTENT_GET()

    Syntax
    ------
    String as C = TABLE.EXTERNAL_RECORD_CONTENT_GET( Table_Name as C, Content_Expn as C [, Order_Expn as C [, Filter_Expn as C ]] )

    Argument
    Description

    Table_Name
    The table that contains the records you wish to retrieve.

    Content_Expn
    An expression that processes the records that are selected and returns a character value.

    Order_Expn
    Optional. Default = "" (record number order). A character order expression that sorts selected records.

    Filter_Expn
    Optional. Default = All records. A character filter expression that evaluates to a logical value. Selects records from the table.


    Description
    -----------
    The TABLE.EXTERNAL_RECORD_CONTENT_GET() method creates a CR-LF delimited string of values from a table. The values in the string are obtained by evaluating the Content_Expn for each record in the table that satisfies the Filter_Expn. The order of the values in the string is specified by the Order_Expn.

    This method is very useful if you have to populate an array with values from a table.

    Note : When working with a table that is already open, <TBL>.RECORD_CONTENT_GET() is faster.

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: TABLE.EXTERNAL_RECORD_CONTENT_GET() problem

    Brett, I think <tbl>.record_content_get() is a vers 8 method, but cannot explain why it's referenced in the current help file. -- tom

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: TABLE.EXTERNAL_RECORD_CONTENT_GET() problem

    Quote Originally Posted by brett s View Post
    I have reproduced below the A5 documentation on the "TABLE.EXTERNAL_RECORD_CONTENT_GET()" method. It refers to the related "<TBL>.RECORD_CONTENT_GET()" method which is quicker running and can be used when a pointer to the table concerned is already available.

    The problem I have is that on trying to use the latter method I get an error message "... method not found".

    The link to documentation on this method is broken, so I can't locate its details. But presumably the parameter syntax is slightly different because why would a table name need to be specified if there is a pointer to it already available? (That's a rhetorical question).

    So what I would really like to know is this:

    Q1: Does the method <TBL>.RECORD_CONTENT_GET() exist?

    Q2: What is the correct parameter list syntax?

    Hopefully then, the good folk at Alpha Software will be able to fix the documentation error.

    The documentation I am using is the full .chm file dated 20 October 2006, the one that's about 37 MB in size.

    Many thanks.
    You can easily discover whether this is a documentation error, or unavailable for the currently open version, by typing the following in the interactive editor.

    tbl = table.open("somevalidtablename")
    ? tbl.

    at which point the autocomplete feature should offer you some choices.

    Since your posted syntax is not indicated in the "What's new in Version 8", I would assume this is a "to be developed" feature or an error.

  4. #4
    Member
    Real Name
    brett sinclair
    Join Date
    Aug 2002
    Location
    Wellington, New Zealand
    Posts
    858

    Default Re: TABLE.EXTERNAL_RECORD_CONTENT_GET() problem

    Ahhh..., of course. There's some v8 stuff in the current documentation and I had overlooked this possibility. I went back to my April documentation to check and yes, no reference there to <TBL>.RECORD_CONTENT_GET() . So you must be right. Many thanks, Tom.

Similar Threads

  1. table.external_record_content_get truncated
    By Peter.Greulich in forum Alpha Five Version 7
    Replies: 3
    Last Post: 08-15-2006, 07:58 PM
  2. Confusion with set.external_record_content_get()
    By michaelklein in forum Alpha Five Version 5
    Replies: 4
    Last Post: 04-13-2004, 06:02 AM
  3. table.external_record_content_get
    By Blake in forum Alpha Five Version 5
    Replies: 5
    Last Post: 08-18-2003, 06:15 PM
  4. external_record_content_get()
    By Stan Mathews in forum Alpha Five Version 5
    Replies: 2
    Last Post: 05-29-2003, 06:57 AM
  5. table.external_record_content_get - filter?
    By Daniel Weiss in forum Alpha Five Version 5
    Replies: 3
    Last Post: 05-04-2003, 01:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •