Alpha Video Training
Results 1 to 2 of 2

Thread: table.external_record_content_get slow!

  1. #1
    Member
    Real Name
    Perry Williams
    Join Date
    Sep 2006
    Location
    San Diego
    Posts
    44

    Default table.external_record_content_get slow!

    Help! I am trying to create list of addresses for google maps to route. I need list for specific tech, specific date. It works great when I enter the values, but runs several minutes when I use variables..

    variables:
    techtoroute="31"
    datetoroute={10/16/2008}

    (database is indexed on technician field and datedone field)


    This runs in less than a second: (Note Datedone = {10/16/2008}
    callrouteurl = table.external_record_content_get("R:\data\bak.dbf","words(address+zip)+' to:'","",
    "datedone={10/16/2008}.and.technician='"+techtoroute+"'")

    This takes about a minute to run! (Note Datedone = ctod('10/16/2008')
    callrouteurl = table.external_record_content_get("R:\data\bak.dbf","words(address+zip)+' to:'","",
    "datedone=ctod('10/16/2008').and.technician='"+techtoroute+"'")


    This takes 10-15 minutes, and pulls up all dates:

    callrouteurl = table.external_record_content_get("R:\data\bak.dbf","words(address+zip)+' to:'","",
    "datedone='"+datetoroute+"'.and.technician='"+techtoroute+"'")

    Any Idea what I am doing wrong???

  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 slow!

    callrouteurl = table.external_record_content_get("R:\data\bak.dbf","words(address+zip)+' to:'","",
    "datedone='"+datetoroute+"'.and.technician='"+techtoroute+"'")

    Should be

    callrouteurl = table.external_record_content_get("R:\data\bak.dbf","words(address+zip)+' to:'","",
    "datedone="{+dtoc(datetoroute)+"}.and.technician='"+techtoroute+"'")

    Whatever you put in the filter has to be evaluated for each record in the table.
    Last edited by Stan Mathews; 10-17-2008 at 12:48 PM.

Similar Threads

  1. bug with table.external_record_content_get()
    By Mike Wilson in forum Alpha Five Version 9 - Desktop Applications
    Replies: 5
    Last Post: 06-19-2008, 10:01 PM
  2. TABLE.EXTERNAL_RECORD_CONTENT_GET() problem
    By brett s in forum Alpha Five Version 7
    Replies: 3
    Last Post: 11-25-2006, 09:25 PM
  3. 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
  4. table.external_record_content_get
    By Blake in forum Alpha Five Version 5
    Replies: 5
    Last Post: 08-18-2003, 06:15 PM
  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
  •