Re: FileMaker 'create new record @'
Re: FileMaker 'create new record @'
- Subject: Re: FileMaker 'create new record @'
- From: Allen Watson <email@hidden>
- Date: Mon, 30 Oct 2000 10:56:57 -0700
on 10/30/2000 10:24 AM, Goodman, Steve at email@hidden wrote:
>
> The data is being filled in the field creation order and not according to
>
the fields that are actually on this layout.<
>
>
I haven't had alot of scripting experience with FM but.....I have heard that
>
creation order is the only way the data will go in...You may have to
>
re-create the fields in the correct order for your script to work properly.
>
>
Probably not the answer you wanted.....maybe someone else has some type of
>
"workaround" or knows for a fact that what I have told you is true.
>
I can't verify. I've scripted FMP only minimally. I seem to recall that the
data will go in in whatever order you currently have set in the Define
Fields dialog box for the database. I have no idea HOW you can set that
order from a script. But you might want to try setting the order for the
database manually and then experimenting with the script that creates a new
record to see if it follows that field order. If I'm correct, then a simple
convention would be to always leave the fields sorted in alphabetic order;
that way, you'd always know how to order them in the script to create a new
record.
--
Peace be with you!
Allen <email@hidden> XNS Name: =Allen Watson
My web page: <
http://home.earthlink.net/~allenwatson/>