Article View: adobe.scripting.indesign
Article #14600Re: Database ->> ID Tables -- Best method? (AS)
From: Olivier_Berquin
Date: Fri, 23 Jan 2004 10:00
Date: Fri, 23 Jan 2004 10:00
36 lines
1628 bytes
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!webxReferences:
<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