🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.scripting.indesign
Article #14600

Re: Database ->> ID Tables -- Best method? (AS)

#14600
From: Olivier_Berquin
Date: Fri, 23 Jan 2004 10:00
36 lines
1628 bytes
> but is very slow. It steps through each cell of the table and 1) gets data
> from several FileMaker databases, 2) sets the contents of the cell


Pete,

To accelerate your process: you must works with only *ONE* database, and
read a complete record like this:

--
    set myRecord to records (17)
--

Or (very faster):
--
    (*
    read 50 records and "put" them in a list
    *)
    set myList to records 1 thru 50 as list
    set MyRec to (item 2 of myList &tab & �
������ item 3 of myList &tab & �
������ item 4 of myList &tab & �
������ item 5 of myList & " " & �
������ item 6 of myList &tab & �
������ item 7 of myList &tab & �
������ item 8 of myList &tab & �
������ item 9 of myList )
--

Read only every cell of a record of a db is *very* slower than read a
complete record at once.


HTH

Oli.
Technical Details
Message-ID: <BC36AF4F.42CC%olb@microscript.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!webx
References: <2ccf86e6.-1@webx.la2eafNXanI>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: f939a,a184049de20316c5
X-Google-Attributes: gidf939a,public
X-Google-ArrivalTime: 2004-01-23 02:07:40 PST
From: Olivier_Berquin@adobeforums.com
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!webx
Newsgroups: adobe.scripting.indesign
Subject: Re: Database ->> ID Tables -- Best method? (AS)
Message-ID: <BC36AF4F.42CC%olb@microscript.com>
Date: Fri, 23 Jan 2004 02:00:31 -0800
References: <2ccf86e6.-1@webx.la2eafNXanI>
Lines: 39
User-Agent: Microsoft-Entourage/10.0.0.1309
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit