Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Updating Many Records - Best Practices?

fx.php

January 30, 201213 yr

Hi all,

I'm writing a web-app to talk to my company's filemaker database. It's for inventory.

The app runs a query on the products table to find the ones that we're checking inventory for, this usually returns about 1300 records. (This initial step takes about 3-5 seconds) I store the resultant FX array into the user's session. I use the array to allow the web app to quickly page through the products. The inventory numbers (3 fields - boxes, packs, units) entered by the user are stored in the array as well.

Once all the inventory numbers are entered, I will have the user commit his entered inventory to the filemaker database. My plan is to iterate through the products in the array and perform a query for each one, finding it by recID, then writing the 3 fields back to the FM database. Based on my experience with FX so far, this is likely to be a slow procedure. Is there any better way to do what I need to?

Thanks!