Alpha Video Training
Results 1 to 6 of 6

Thread: table.external_record_content_get

  1. #1
    Member
    Real Name
    Blake Watson
    Join Date
    Jan 2003
    Posts
    961

    Default table.external_record_content_get

    I'm using: table.external_record_content_get (based on a thread here "Xdialog KeyList Filter Syntax") and maybe I shouldn't be. It's not documented, though it seems pretty straightforward.

    My problem is that it's apparently returning data that is not in the table. Well, two problems, the first being that:


    ?table.external_record_content_get("wprojectselections", "Value")


    Returns data even though the table "wprojectselections" is empty. The data it returns is from deleted records (itself a problem as I don't know how to filter them out) but it does this even though I just compacted the database (which puzzles me as I thought the database compact zapped the tables).

    The other problem, perhaps related, is that the above code returns the exact same data as this:


    ?table.external_record_content_get("wprojectselections", "Value", "", Filter)


    Where "filter" contains a filter that should be eliminating at least some of the records (deleted or no).

    So...I'm not sure how to proceed. Should I give up on this call and use keylist build? (I didn't use it before because I only want the one field and it seemed simpler.) Or do I need further education? :-)

  2. #2
    "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

    Is it possible you have more than one copy of the table somewhere. Try specifying the full path to the table

    table.external_record_content_get("drive:\path\ wprojectselections", "Value")

  3. #3
    Member
    Real Name
    Blake Watson
    Join Date
    Jan 2003
    Posts
    961

    Default RE: table.external_record_content_get

    Is it possible you have more than one copy of the table somewhere.

    At last count, 50 copies. :-)

    Try specifying the full path to the table

    The records are back. I've had this happen before; I can't remember what, if anything, I did about it.

  4. #4
    Member
    Real Name
    Blake Watson
    Join Date
    Jan 2003
    Posts
    961

    Default RE: table.external_record_content_get

    OK, solved both, sort of. Nailed down the behaviors, anyway:

    First, the query I set up in my code sticks. I was filtering out records so they didn't appear to be there even after the code had run. Running a blank query after I'm done with it doesn't seem to help: Once I've set this query it sticks for the entire A5 session

    Second, the filter I had set up in one place was incorrect (per my other message about getting "T" and "F" out). When you give A5 an incorrect filter parameter, you don't get an error message. You also don't get a filter. I had forgotten that behavior.

    Thanks. Any input on clearing the query would be appreciated.

  5. #5
    Member
    Real Name
    Blake Watson
    Join Date
    Jan 2003
    Posts
    961

    Default RE: table.external_record_content_get

    OK, more on this. I'm trying to setup a browser filter (unsuccessfully) and so I was using table.external_record_content_get to check out the values that were in the table.

    But apparently this function doesn't care for LOGICAL fields. If I use this:

    ?lookup("sometable", "somefield='somevalue'", "logfield")

    I'll get back a .T. or an .F., but if I want to see all the values in "logfield":

    ?table.external_record_content_get("sometable", "logfield")

    this returns "".

  6. #6
    "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

    The .QUERY_DETACH_ALL() method detaches all temporary queries from a table.

    temporary as in not an index.

Similar Threads

  1. detach filter in SET.EXTERNAL_RECORD_CONTENT_GET()
    By T Sayers in forum Alpha Five Version 6
    Replies: 4
    Last Post: 05-27-2005, 05:01 PM
  2. Confusion with set.external_record_content_get()
    By michaelklein in forum Alpha Five Version 5
    Replies: 4
    Last Post: 04-13-2004, 05:02 AM
  3. external_record_content_get()
    By Stan Mathews in forum Alpha Five Version 5
    Replies: 2
    Last Post: 05-29-2003, 05:57 AM
  4. table.external_record_content_get - filter?
    By Daniel Weiss in forum Alpha Five Version 5
    Replies: 3
    Last Post: 05-04-2003, 12:39 PM
  5. Scrolling Screen query table and update table
    By mpierce in forum Alpha Five Version 4
    Replies: 2
    Last Post: 09-21-2000, 08:38 AM

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
  •