[muglo] Re: FMP 3.0

On 21-Jun-05, at 4:56 PM, Eric Dunbar wrote:

> If FMP has SQL (I presume it does given that it's a DB):
>

You are presumptuous!  FMP 3 doesn't use an SQL approach to finding 
records.  You basically use the form you are in (if it has the fields 
you'd like to search) and enter your criteria there.  There are a range 
of options including at the end an omit option.  This type of 
search/find goes right to version 7.  The beauty though is that find 
sequences are easily automated using FMP's internal scripting process.  
FMP7 has added the ability to search within a found subset of records, 
something not possible before without going through a lot of hoops.

Most FMP db designers construct a find layout accessible by script only 
(with error control) to allow a user to input a find request.  FMP 
operates very much like the data base in AW  4 thru 6 but, as has been 
discussed in previous missives on MUGLO, since it focuses on db 
functions only and is a much richer and more capable db application a 
key feature being its relational capabilities as compared to AW's flat 
file structure..

I still say as a package AW6 does a great job of providing a number of 
easily accessible pieces (/ / / Easy Pieces for you history buffs!). 
Also I think Paul could accomplish what he is doing in FMP 3 using AW6 
just as easily if not more so (said not having seen the database! ).

> On 6/21/05, Martin Albinger <max@xxxxxx> wrote:
>> =20
>> On 21-Jun-05, at 3:14 PM, Paul Thomas wrote:
>> =20
>>> Hi Martin
>>>
>>> Thanks for your help and I used the first method which worked fine 
>>> for
>>> a part of the file.  Unfortunately some of the records are scattered
>>> about the file.  I tried to import a second group but I found that 
>>> this
>>> wiped out the first lot - I was hoping that the second batch would
>>> merge in but no!!  Is there a way of copying a second group or does 
>>> it
>>> have to be all done in one group? Or could one create a number of 
>>> files
>>> and then merge them?  If so how can one merge them?
>>>
>> =20
>> For the others,  I suggested Paul contact me off list.  Short answer 
>> is
>> you can import any number of times and the imported records replace 
>> the
>> current found set.  The imported records become the found set and the
>> others are now in the omitted set.  Do a Find All and you should see
>> all the records. AS an example say I have a db with 100 records and I
>> import 10.  The 10 become the found set and the other 100 are the
>> omitted set. A ind All gets all 110 records showing.  I usually make
>> sure the imported set is OK before doing a find because you can flip
>> back and forth between sets to check data import.
>> =20
>> Martin
>> =20
>> _________________________________________________
>> =20
>> For information concerning the MUGLO List just click on
>> =20
>>            http://muglo.on.ca/Pages/joinus.html
>> =20
>> Our Archives can be viewed at
>> =20
>>          http://www.freelists.org/archives/muglo
>> =20
>> Don't forget to periodically check our web site at:
>> =20
>>                  http://muglo.on.ca/
>>
> _________________________________________________
>
> For information concerning the MUGLO List just click on
>
>            http://muglo.on.ca/Pages/joinus.html
>
> Our Archives can be viewed at
>
>          http://www.freelists.org/archives/muglo
>
> Don't forget to periodically check our web site at:
>
>                  http://muglo.on.ca/
>

_________________________________________________

For information concerning the MUGLO List just click on

           http://muglo.on.ca/Pages/joinus.html

Our Archives can be viewed at 

         http://www.freelists.org/archives/muglo

Don't forget to periodically check our web site at:

                 http://muglo.on.ca/

Other related posts: