How do I update a bunch of records at once?

#1

I have a bunch of customer records and I want to reset all of their
discount levels to "1". In SQL it would be something like:

UPDATE customers SET discount_level=1;

What's the preferred way to do this in FileMaker Pro 8.5?

Regards,
Nate

#2

See "Replacing the contents of a field" in Help

Matt

On 01/25/2007 17:53:03 nate+google (AT) northwe (DOT) st wrote:

Quote:

I have a bunch of customer records and I want to reset all of their
discount levels to "1". In SQL it would be something like:

UPDATE customers SET discount_level=1;

What's the preferred way to do this in FileMaker Pro 8.5?

Regards, Nate

#3

On Jan 25, 3:00 pm, Matt Wills <I... (AT) witz (DOT) end> wrote:

Quote:

See "Replacing the contents of a field" in Help

Well that was easy. Thanks!

I promise I really did search help before posting to the list. :-) I
looked for "update" and "SQL" instead of "replace".

Regards,
Nate

Quote:

Matt

On 01/25/2007 17:53:03 nate+goo... (AT) northwe (DOT) st wrote:

I have a bunch of customer records and I want to reset all of their
discount levels to "1". In SQL it would be something like:
UPDATE customers SET discount_level=1;
What's the preferred way to do this in FileMaker Pro 8.5?
Regards, Nate

#4

No prob. Help is pretty informative, but only if you know what they call stuff. Sometimes it seems like you need to know the answer in order to ask the question, like a perverted game of Jeopardy.

Matt

On 01/25/2007 18:06:46 "Nate Silva" <nate+google (AT) northwe (DOT) st> wrote:

Quote:

On Jan 25, 3:00 pm, Matt Wills <I... (AT) witz (DOT) end> wrote:

See "Replacing the contents of a field" in Help

Well that was easy. Thanks!

I promise I really did search help before posting to the list. :-) I
looked for "update" and "SQL" instead of "replace".

Regards, Nate

Matt

On 01/25/2007 17:53:03 nate+goo... (AT) northwe (DOT) st wrote:

I have a bunch of customer records and I want to reset all of their
discount levels to "1". In SQL it would be something like: UPDATE
customers SET discount_level=1; What's the preferred way to do this in
FileMaker Pro 8.5? Regards, Nate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I update a bunch of records at once?

comp.databases.filemaker comp.databases.filemaker

How do I update a bunch of records at once? - 01-25-2007 , 04:53 PM

Re: How do I update a bunch of records at once? - 01-25-2007 , 05:00 PM

Re: How do I update a bunch of records at once? - 01-25-2007 , 05:06 PM

Re: How do I update a bunch of records at once? - 01-25-2007 , 06:05 PM