According to the v17.2 docs:
> All SQL statements are thread-safe, except for REPLICATE
> <https://livedoc.4d.com/4D-SQL-Reference-17/SQL-Commands/REPLICATE.300-3786790.en.html>
> or SYNCHRONIZE
> <https://livedoc.4d.com/4D-SQL-Reference-17/SQL-Commands/SYNCHRONIZE.300-3786772.en.html>.
> SQL code inserted in Begin SQL/End SQL blocks must comply with the following
> conditions :
> - It shall apply to the 4D Server or 4D local base (but not to ODBC).
> - it cannot reference interprocess variables
However, a method set to Thread-Safe with the following code generates an error
when I do a syntax check:
Begin SQL
SELECT Company_Name from Customer INTO :$atStr1
End SQL
The error is: “Cannot us SQL from a method declared as thread-safe.”
The original v17 docs say that you cannot use Begin…End SQL but the v17.2 docs
clearly say you can with the above restrictions. Has anyone had success getting
Begin…End SQL to work in a thread-safe method in 17.2?
------------------------------------------------
Richard Wright
DataDomain
[email protected] <mailto:[email protected]>
------------------------------------------------
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
