Skip 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
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

LASSO and FM problem

Featured Replies

  • Newbies

Hi List!!!

We have two different problems using Inline code:

1) First problem

When we use this code (search and update):

[inline: -Search,

-Database='Contacts',

-Table='People',

-FMScript='DTcreate',

-KeyField='recID',

'username'=(Field:'username')]

[inline: -Update,

-Database='Contacts',

-Table='People',

-KeyField='recID',

-KeyValue=(field:'recID'),

'name'=(Var:'name'),

'email'=(Var:'email'),

'Address'=(Var:'Address'),

'ZipCode'=(Var:'ZipCode'),

'Phone'=(Var:'Phone'),

'City'=(Var:'City')]

[/inline]

[/inline]

The errors generated by File Maker are ignored! In FM we are validating the phone number with the zip code since in our country the phone number is associated with the zip code. In case the phone number matches the zip code FMP accepts the data and the record is updated, if not the data is rejected and an error occurs.

When the error occurs in the database nothing happens. The fields that were changed remain with the same information, and lasso reports nothing serving the html reporting your changes where made.

2) Second problem (different set of htmls and different database)

The Update command only works if i have an error (for example a required field is left empty). If I fill all the fields the update doesn't work!

Sometimes happens a strange thing: in spite of doing an Update, FMP ignores the -KeyField='recID' updating the first record in the database.

[inline: -Search,

-Database='Contacts',

-Table='People',

-KeyField='recID',

'username'=(Field:'username')]

[inline: -Update,

-Database='Contacts',

-Table='People',

-KeyField='recID',

-KeyValue=(field:'recID'),

'name'=(Var:'name'),

'email=(Var:'email'),

'Address'=(Var:'Address'),

'ZipCode'=(Var:'ZipCode'),

'City'=(Var:'City')]

[/inline] [/inline]

We noted that the Inline tag is the first command to be executed. Is there anyway of changing this situation, and execute it at the end?

Hardware and software setup:

We are using WebStar V, lasso 6 (with AutoValidate 1.5.1) and FMP 5.5 Unlimited, each running on different xServers system X 10.2.8. Each application is running alone.

In case of AutoValidate, we have the same results with or without it.

Best Regards!

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.