Find recods in database

General support questions.
PostPosted: Fri Jan 27, 2006 3:49 am
Sorry my english but I go to try to place my problem.

I want find in database the records that i have in a dbf table. I only want to find the records. I do not want to modify the records in the database.

DBF table with 25 records (the number of records can change):
Field: 2; 5; 22; 30;......45

these fields exist in the database (with 500 records)

How can i make this? Can i make this using one script?

any suggestion is welcome
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Jan 27, 2006 5:44 am
< I"ve moved this from the Custom Functions Forum to this General Support Forum. Sorry for the inconvenience. >

I'm not quite sure what you're trying to say here: "Field: 2; 5; 22; 30;......45 " but I'd recommend looking in FileMaker's built in help, searching for "Find" and reading the section called "Finding Records."

Write back if that doesn't help.
John Sindelar
SeedCode
PostPosted: Fri Jan 27, 2006 9:21 am
see image please
http://www.uac.pt/~geografia/transporte ... ecords.pdf
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Jan 27, 2006 1:59 pm
Thanks. That helps a bit, though I'm still not sure why you need to introduce all the values... here are some thoughts:

Entering "*" into any field will find all records with any value in that field. (If the fields are numbers, you can also enter ">0" as your find request.

You can find ranges of numbers like "2...268".

Does that help?
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: