>Hey All,
>
>The replace command is a linear type of scripting language to move around,
>correct your records, create new
>records based on your information gathered. My only beef is that it appears
>to only be accessable when importing
>a new database.
The analogy I usually use is "Fill Down" in Excel. Enter data in a
field of one record and you can REPLACE the values of the other
records in the found set with this value (or a serial number, or a
calculated value, which is the example you have noted below. It is a
very powerful technique. It's available anywhere from browse mode, if
you have FileMaker and use the master level password. It's a menu
item under the Records menu. Ebase has a script built in to call this
function for those using the runtime.
>
>If you imagine a grid system with 4 columns and 4 records.
>If you wanted the fourth column to be created from the first
>and second column you would:
>
>1.click on the fourth column
>2.hit replace
>3.specific replace
>4.column 1 is named firstname. column 2 is named secondname.
>5.TYPE: firstname & secondname
>6.for 'Each' record on the fourth column new data will be comprised from
>column 1 + 2 for each record.
>
>IE:
>
> column1 column2 column3 column 4
>record1 hi all hiall
>record2 hiyall too hiyalltoo
>record3 moo rew moorew
>record4 fiom reew fiomreew
>
>
>
>Walter Beardwood
>Database Administrator
>The Exploration Place
>
>
>------------------
>Reminder to each recipient: To change your list account preferences, go to
>http://email.sparklist.com/scripts/lyris.pl?enter=support and enter
>the email address you used to subscribe to the ebase support list::
>[EMAIL PROTECTED]
>
>To unsubscribe send a blank email to [EMAIL PROTECTED]
>---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>---------------------------------------------------------------------
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
