go to post Kyle Baxter · Mar 15, 2016 There is no Requirement for bandwidth that I'm aware of. Studio uses ODBC to connect to the Server, and it will have to bring over the class/routine list in order for the open dialog to work, and if you have a large system this can take some time. I think as long as Studio is getting information, though, that it should work (albeit slowly). If you find Studio is working too slowly, you can import your project to a local instance and work off of that.
go to post Kyle Baxter · Feb 11, 2016 This is working as expected (to the best of my knowledge). If you have a property that is SqlComputed and not Calculated, then the property value is stored on disk. We calculate that value to store it on disk and do so on the first INSERT/%Save(). Then, since there is no SqlComputeOnChange value, the value won't be re-computed on any UPDATEs. However, I believe you will be able to set that property directly via INSERT/%Save().
go to post Kyle Baxter · Feb 2, 2016 Hi Jack, Sorry, lost half the email. The second problem is that you are searching for: 'Elément' instead of 'Élément' which iFind reports as different words (indeed, they do NOT match). Cheers! Kyle
go to post Kyle Baxter · Feb 2, 2016 Hello Jack, Your query should be: SELECT * FROM my_table WHERE %ID %FIND search_index(IDXBASDescriptionDemande,'éléments',1) To get stemming to work.
go to post Kyle Baxter · Jan 26, 2016 While I don't think there's a 'good' way to do this, I think your approach might work. Say you have two Namespaces, A & B. You can link Ens.MessageHeader & Ens.MessageBody from B to A and then run the query: SELECT <Fields> FROM Ens.MessageHeader WHERE (...) UNION ALL SELECT <Fields> FROM Ens.MessageHeaderB WHERE (...) While this will work (technically) it is limited. You won't necessarily be able to JOIN, ORDER, or GROUP the results in a meaningful way, and so you will need to write some additional code to do this. That said, you could certainly write a stored procedure to handle this situation if you so chose. The stored procedure here is more in line with what Dave L. said - you need to write code to merge the results. But if you don't care about order and you think you're only going to get a small number of messages back, no reason this can't work.
