the attach file
You can only upload graphic files such as screen shots. If you want others to access a copy of the database file, upload it to a file sharing site such as drop box and then post the download link here in your next post.
What kind of link to the back end do you have? Is this ESS?
This sounds like a locking issue with SQL Server, so I don't think that I can help you any with that.
YES i use ESS. are you sure it is coming from SQL. I'll check it.
Hi again. it doesn't seems that is coming from SQL Server. I checked the locking tables/records, everything seems to work fine.
Something is different.
“this record was modified by another user since your started editing…”
Is not the way FileMaker edit locks records that are native to FileMaker. When user A opens a record for editing, by clicking/tabbing into a field, users get a different message with the very first keystroke that attempts to modify data in the same record. If I recall correctly, editing a record in a portal can edit lock all the portal records, but I still wouldn't expect to get that specifc error message.
Perhaps this is a difference dur to how FileMaker interacts with the ODBC data source.
Mr Vodka knows his stuff--especially ODBC data sources, but I don't read that thread as describing a problem with FM or its ODBC link. The poster in that thread was able to resolve the issue. Does the info in that thread help you resolve yours? Are you using the Execute SQL script step in conjunction with ESS?
If not, perhaps a post to Report An Issue is in order to see if you have identified a bug or not.
i'm trying to make a workaround cause it seems complicated.
now simple question, how can i filter a portal on more than one value.
in portal filter:
Exactly as you have posted it.