go to post Kurro Lopez · Feb 20, 2020 That depends on your data model. If you require many related tables, it may be more useful to have the invocation with the data you need by appending the tables by primary keys. SELECT table1.code, table2.descriptionFROM table1INNER JOIN table2 ON table2.tab_id = table1.id Also, it's important create the proper index to the fields that you need to search. There is not a simple answer :) Best Regards,Francisco Lopez
go to post Kurro Lopez · Feb 18, 2020 If you have just one index, you can use the method %AllIndex https://cedocs.intersystems.com/ens201813/csp/docbook/DocBook.UI.Page.cl... You can use it together%IGNOREINDEX to remove the index that you don't need Regards
go to post Kurro Lopez · Jan 30, 2020 Great, I have some questions about VSCode-ObjectScript. It is the best occasion to ask the creator of the application directly.
go to post Kurro Lopez · Oct 31, 2019 It's just I need... By this way, I have the version number Many thanks
go to post Kurro Lopez · Oct 31, 2019 Good approach, thanks for your answer. The methods will be exactly the same as before. The changes in version is a slight change in BP, so I need which version is calling. If I user the version number as parameter, I can add into a message and calls to BP with the version and not replay all methods for each version. I'll be in mind for future versions. Thanks
go to post Kurro Lopez · Oct 19, 2019 I think it is a "Best practice", but the information is scattered throughout the conversation. Why not create a last comment with a brief of the conversation, with pros and cons? It could be more clear. Regards
go to post Kurro Lopez · Oct 18, 2019 None of them. The best practices is "Do what you want"... hehe Now seriously. I think the best practices is use according to the explication of each comment. Use brace to delimit the scope, not use if you have one line and precondition, etc..
go to post Kurro Lopez · Sep 5, 2019 Last time, we have a value of 10 and the error increases more frequently, even when I was loading files.So, the idea is to put a value like 30 seconds to allow that time the TCP disconnection. If I change the value to 30 (or 60), can the process open the TCP connection automatically and try to connect to FTP? If I leave it indefinitely (-1), is there a way to make the connection again?
go to post Kurro Lopez · Sep 4, 2019 This is the configuracion in DEV environment, in Prerelease it has that value in SSL configuration.
go to post Kurro Lopez · Jul 17, 2019 I'm thinking to create a framework with some utilities for Rest, utils functionst, etc... When it works fine, I'll do
go to post Kurro Lopez · Jul 17, 2019 Hi Vikram,Have you checked if you have granted privileges?Best regards,Francisco Lopez
go to post Kurro Lopez · May 31, 2019 It's a great plugin. Works in server side like Studio IDE. I need to check debug plugging.I just miss a way to to push my code into a repository (Git, TFS,...) because there is not a copy in my disk folder (like Atelier). To do it, I need to synchronize all my code in Atelier and push into Git.4.9 over 5Best regards,Francisco López
go to post Kurro Lopez · May 30, 2019 As says the song.... "Words don't came easy to me, How can I find a way to say.. THANKS"I see you in Spanish Developer Community and this community too Best regardsFrancisco López
go to post Kurro Lopez · May 24, 2019 Good point.I'll do it.It's not as elegant as <foreach> but...Maybe is not elegant, but this idea is from a gentleman, so it has glamour Best regards,Francisco Lopez
go to post Kurro Lopez · May 24, 2019 So it is not possible to do in a DTL?As you say, I need to do it as code, instread of DTL.Thanks for the answer
go to post Kurro Lopez · May 23, 2019 Exactly... using %Save aftewards RemoveItem in Ens.Config.Production worksThanks for all
go to post Kurro Lopez · May 23, 2019 it is a mistake when I've copied it in the post. The original code is the same name, and I get the idItem, thanks