User bio
my video https://youtu.be/zx6WoApljBI
my business story https://community.intersystems.com/post/45-years-intersystems-1978-2023
- main languages: German, English, Italian, French, Spanish, Latin, ..
- private: married since 1969, 3 successful children
Member since Jul 21, 2017
Posts:
Replies:
If you use a custom class query %Library.Query type you may write your parameters to some
^mtemp.Evgeny($i(^mtermp.Egeny)) = ..... direct from the Execute method
or ^mtemp.Evgeny($h) = ....
For basic class query %SQL.Query () you may take the usual SQL approach
- Create a SQL method that always returns 1 (TRUE)
- You pass all your parameters into that method
- which does the ^mtemp trick and a QUIT 1
- add to the WHERE clause . . . AND MYTRACE(par1,par2,---)=1
I refer to this a STATIC clause since it is only executed once by query
because of no reference to any column values
It was my approach to SQL debugging
If your payload is received as a string
set jsn={}.%FromJSON(payload)
write jsn.%Get("boolprop")
works without a persistent object
Open Exchange applications:
Certifications & Credly badges:
Robert has no Certifications & Credly badges yet.
Global Masters badges:







Followers:
Following:
Did you also run a rebuild index ?
Just defining is not enough.