Using Copy All Records

Knowing which features to use and when to use them is great skill to have with FileMaker Pro development. Anytime you can determine when a certain script step, structure, web viewer or plug-in should be used is what makes for a productive developer.

In this video we’ll take a look at a long standing script step called Copy All Records. Using this core script step allows us to optimize a lot of things so we end up with a faster FileMaker solution.

With the additional tips and education in this video, you should be that much closer to solving a number of various issues for your FileMaker database. Make sure you know how to use Copy All Records in the most efficient manner!

AttachmentSize
UsingCopyAllRecords.zip298.73 KB

Comments

Hi Matt,

Thanks for the video. Would it be a little more straightforward and less error prone to use ExecuteSQL? You'd even be able to specify your sort field, limit the number of returned records, paginate, etc. Or is this an example of how to get some of that functionality without the need to learn SQL statements?

Chris Wilson

Hi Matt,

Seems that Vimeo is 'having a little trouble.'

impossible to download since several days

I think the system was confused about which links to use.

-- Matt Petrowsky - ISO FileMaker Magazine Editor

Hey Matt - looks like the system is still confused.

Peter Gerlings

Hi Matt
I can confirm what others have written before. There is definitely a problem with your videos. I've just tried to download the latest few using both a tool on iOS and Chrome on Windows... doesn't work.

Well, so far, despite some reports here and a few emails, I can't replicate download issues. I don't know if this means that Vimeo is limiting things based on IP or if it's a browser/caching issue.

When I log into a standard subscriber account I'm able to download from my location. If you are experiencing download issues then please take screenshots and/or a short video. You can send them to editor@filemakermagazine.com. I need as much information as possible, not just an "it's not working" type response. :)

-- Matt Petrowsky - ISO FileMaker Magazine Editor