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
  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.

Rb to filemaker 5 query

Featured Replies

I am trying to query my filemaker 5 database. The database is called testdb. The plug-ins for Local data access comp and remote data acces comp are checked. My fields in my database are as so

ID_NUM NAME LAST COMPANY DATE MISC

dim cursor as databasecursor

cursor=testdb.sqlselect ("select * from tempdb where ID_NUM='"+editfield1+"'")

If cursor <> nil then

editfield2.text=cursor.field("NAME").getstring

editfield3.text=cursor.field("LAST").getstring

editfield4.text=cursor.field("COMPANY").getstring

else

msgbox "Record not found"

end if

What's wrong with the code It is written in Realbasic 5. I want to use rb with a filemaker database. I am entering an Id num into a editfield

and hitting a pushbutton. I am just trying to query the database with the info in editfield1 and getting the results in the other editfields. Can someone please check the code and tell me what I am doing wrong. Thank you in advance

Create an account or sign in to comment

Important Information

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

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.