[muglo] Re: FMP 3.0

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

try something like:
select table1.* from table1 on table1.field1 eq 'my search parameter'
and table1.field2 ne 'my search parameter' where table1.field3 ne .

You can then save the resulting table (there's also commands to
actually create a new dataset from a search but I only really use SQL
in SAS so I only know its syntax...
proc sql; create table table2 as select...)

Of course, the syntax will vary depending on the DB that you use, but
the basics for SQL are the same.

Eric.

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/

Other related posts: