Re: Printing structures

2019-05-08 Thread Patrick Emanuel via 4D_Tech
well done! Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: Printing Structure Diagram

2019-05-07 Thread Patrick Emanuel via 4D_Tech
Bonjour Alexander QS_Toolbox source is opened, that mean you have access to the code. If you have a look on the method 'TOOLS_Export_Drawn_Structure', you'll see the picture is resized to fit the screen and the export is in JPG I you just want to get the SVG file without any resizing, you just

Re: Printing Structure Diagram

2019-04-18 Thread Patrick Emanuel via 4D_Tech
Hi, In QS_Toolbox, I've implemented the Vincent solution. You can view inside the component the diagram and also export it as picture. Have a look here: association-qualisoft.eu - Patrick EMANUEL Administrator

Re: Easy dynamic field highlighting

2019-02-17 Thread Patrick Emanuel via 4D_Tech
Very nice and useful. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: SDI on WIndows doesnt respect a toolbar

2019-02-02 Thread Patrick Emanuel via 4D_Tech
And it is worst than you can imagine. On an engined application, the toolbar is displayed as a separate dialog! Not sure that it really useful. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002,

Re: Tracking Field Data Changes

2019-01-15 Thread Patrick Emanuel via 4D_Tech
Hi Luc, I'm interested if it doesn't matter to you to provide it to me also. My email is pat.emanuel67 (at) gmail.com Thanks Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso &

Re: v16 Replacement for 4D-Pack command: 'AP Get table info'

2018-12-11 Thread Patrick Emanuel via 4D_Tech
Hi, there some existing tools based on the EXPORT STRUCTURE command which is now the command to use to get the info that you are looking for. You have this excellent article on 4D blog: https://blog.4d.com/detailed-analysis-database-structure/ which explain how to use this command and which also

Re: I've updated sideORDA

2018-11-17 Thread Patrick Emanuel via 4D_Tech
Thanks a lot Kirk. Your presentation was very instructive and useful. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Help->v11 to v17 Upgrade or New?

2018-10-22 Thread Patrick Emanuel via 4D_Tech
4D Tech mailing list wrote > I am not uploading directly from 4D. I thought about implementing that but > decided against it since 4D is going that direction them selves. Waiting > to see what they come up with. I understood the same from teh Summit. Anyway, there is an existing module in

Re: Help->v11 to v17 Upgrade or New?

2018-10-20 Thread Patrick Emanuel via 4D_Tech
Hi Kirk, 4D Tech mailing list wrote > Did I just hear you say something about uploading direct from 4D into > GitHub...  It is not what I understood. He used GitHub to manage his version. But, if you're right, I'm also very interested by this ;-) - Patrick EMANUEL

Re: Help->v11 to v17 Upgrade or New?

2018-10-19 Thread Patrick Emanuel via 4D_Tech
About QS_Toolbox, the one I really know, there is a bunch of tools in the Structure Analysis part. It works from V15 to V17, but nothing has been added since V16R6. QS_Toolbox performed very few update for you. Its goal is to identify

Re: Help->v11 to v17 Upgrade or New?

2018-10-19 Thread Patrick Emanuel via 4D_Tech
4D Tech mailing list wrote > So, there are more than 700 lines of code with the deprecated “_o_” > prefix. Perhaps I could make a lot of that go away via Search/Replace (a > feature that I normally don’t use). Some tools can help you like QS_Toolbox from me or CodeAnalysis from Dani Beaubien for

Re: Structure to TEXT files... GitHub

2018-10-17 Thread Patrick Emanuel via 4D_Tech
As I know, not yet for the moment, may be later V18 or V17R3 give us, for the moment, the capability to manage sources with a Version control system, like Hithub does. - Patrick EMANUEL Administrator

Re: Selection to JSON Date Conversion

2018-10-09 Thread Patrick Emanuel via 4D_Tech
is that helpfull ? 4D-Forum disucssion - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Sending Text Messages From 4D

2018-08-22 Thread Patrick Emanuel via 4D_Tech
I know the Bertrand Soubeyrand provide a product doing this. https://www.soubeyrand-4d-developer.eu/ - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: v13+ - injecting code into a host.

2018-08-21 Thread Patrick Emanuel via 4D_Tech
Hi, If you don't want that user have access to your code, in this case, save it in a crypted blob. Your component will have the key to read it and by the way, just your component. In my case, I do like Dani. Patrick - Patrick EMANUEL

Re: Web Area display PDF

2018-08-21 Thread Patrick Emanuel via 4D_Tech
Thanks a lot. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: How to get the Transparent property of a form object?

2018-07-18 Thread Patrick Emanuel via 4D_Tech
Hi Kirk, in the Apparence tab of object properties, you should find Transparency option. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Consider upvoting this feature request: FORM Export as JSON

2018-07-18 Thread Patrick Emanuel via 4D_Tech
I really guess it is on work, but not yet present in v17R2 (no new command in the language part). So, do not hesitate to vote to push up the feature request. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu

Re: Any way to determine how a field's data storage is set?

2018-07-07 Thread Patrick Emanuel via 4D_Tech
Hi, Explore the XML export of the structure. You'll find what you are looking for. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: FORM GET OBJECTS and getting info about Subforms

2018-07-02 Thread Patrick Emanuel via 4D_Tech
Hi Bob, in QS_Toolbox, you have a module that give you information about form objects, included subform. Have a look on the method FORMS_GetObjectDetails, you will find what you are looking for. Patrick - Patrick EMANUEL

Re: Command name but what about Keywords?

2018-07-02 Thread Patrick Emanuel via 4D_Tech
4D Tech mailing list wrote > Yes, I wondered about that. I'm not certain how well it work in the > METHOD SET CODE context. > > Ideally I would like something like the new syntax: > Count parameters:C259 > > or with a constant: > Carriage return:K15:38 I tried to keep method code lile you

Re: Command name but what about Keywords?

2018-07-01 Thread Patrick Emanuel via 4D_Tech
Hi, In QS_Toolbox, inside the Convert part, you have the way to display constant & their token number. The catching "text" & "id" is generic and performed only when you call the Convert module. Have a look on the code (it is open since the last Summit) at the method "Get4DKeyWords" Patrick

Re: crashing issue in v15 and v16

2018-06-21 Thread Patrick Emanuel via 4D_Tech
Hi Chuck, I offered to the 4D community QS_Toolbox componant (source included) and you'll find exactly what you made and described here. You'll find also a bunch of tools that could help you in different ways (code editing, report, data,...). Starting to work with a v15 version, it works with v16

Re: Macro to check that local variables are declared in a method? [Solved]

2018-04-29 Thread Patrick Emanuel via 4D_Tech
Hi, I have this regex to find all kind of variable in QS_Toolbox. May it will help you to increase the impact of your method ;-) $PatternVariables:="(?mi-s)(\\b[[:alpha:]][\\w+]*\\b)[?=\\:|\\;|\\)|\\>|\\<|\\{|\\}|\\]|\\[|\\r|\\n]|(\\$[\\w+]*\\b)|(<>[[:alpha:]][\\w+]*\\b)" Patrick -

Re: Picture resources

2018-04-27 Thread Patrick Emanuel via 4D_Tech
Hi, you have to open the *32bits* 4D v16 version and to export your picture library. This is the only one way to get you pictures back. Then, one by one replace the call from a file coming from your ressources folder. Easy, but take times. Or get help with QS_Toolbox ;-) Patrick -

Re: Macro to check that local variables are declared in a method?

2018-04-27 Thread Patrick Emanuel via 4D_Tech
Hi, I haven't a macro but a tool that try to answer to this point (not only). It works on local ($), variable (without $ or <>) and global (<>) variable. Manage $ and <> variables is pretty easy, standard variable, more difficult. So, this code works with method of all objects and cross

Re: What happened to LISTBOX Get Information?

2018-04-20 Thread Patrick Emanuel via 4D_Tech
I really like the both options, these will very helpful ! - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: How to Determine Field Type from XML Structure Export?

2018-04-20 Thread Patrick Emanuel via 4D_Tech
Hi, You have an example here: https://blog.4d.com/detailed-analysis-database-structure/ and it is included into the QS_Toolbox component, with some more functionalities. Patrick - Patrick EMANUEL Administrator

Re: Web

2018-04-11 Thread Patrick Emanuel via 4D_Tech
Did you check preference in 4D about security. There is some improvement on it. It may be the cause. For that, there is an article on the 4D Blog (blog.4d.com) Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu

Re: 4D Summit 2018 Comments

2018-04-10 Thread Patrick Emanuel via 4D_Tech
Hi, >> naming relations is needed to take make the code readable. >Laurent's suggestion is to export the structure in XML, modify all the relation names in the text file, and reimport the structure as XML. It will be faster than to go across the complete graphical structure representation.

Re: xml to array

2018-03-27 Thread Patrick Emanuel via 4D_Tech
Hi, Arnaud de Montard publised some time ago a method to convert XML to JSON. May it can help you to do what you are looking for. Here is the link : http://forums.4d.com/Post/FR/18847378/1/20786990#20786990 Patrick - Patrick EMANUEL

Re: Moving picture resources from one database to another

2018-02-10 Thread Patrick Emanuel via 4D_Tech
Hi, This method works well only if you are not in a 64 bits version. All old pictures format aren't recognize. So, if you want that work, use this code in a 32 bits version. - Patrick EMANUEL Administrator

Re: Creating .docx files

2018-01-24 Thread Patrick Emanuel via 4D_Tech
I forgot to answer to this: What do you have in your autoloader.php file? it is not mine, but the phpword one. It is a part of the php librairy. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002,

Re: Creating .docx files

2018-01-24 Thread Patrick Emanuel via 4D_Tech
What's "Export_Echappement"? (echappement means "escape", right? Does this method add escape characters? Yes, indeed. I translate some method names but i'm too french sometimes ;-) but you catch the wording. I will update in my componant, thanks. Here is the code: C_TEXT($1;$0) If (Count

Re: Creating .docx files

2018-01-23 Thread Patrick Emanuel via 4D_Tech
Hi, I've extract and compile code lines for you. If you have able to participate to the next Summit, you will get special gift containing some example of phpword code. It works with the v0.12.1 here the code, and let me know. C_BLOB($Blob) $NomSortie:="DocumentName.docx" $PhpCode:=Create

Re: v16 List Box Set Enterable not working?

2018-01-23 Thread Patrick Emanuel via 4D_Tech
Hi, I never had any issues with EDIT ITEM Did you try something like this in your code: $Row:=size of array(ar_invBalance)+1 LISTBOX INSERT ROWS (*;"ListBoxName";$Row) ar_invBalance{$row}:="New item" OBJECT SET ENTERABLE(ar_invBalance{$row};True) EDIT ITEM(ar_invBalance;$row) Patrick

Re: v16 List Box Set Enterable not working?

2018-01-23 Thread Patrick Emanuel via 4D_Tech
Hi , did you try something like this: $Row:=size of array(ar_invBalance)+1 LISTBOX INSERT ROWS (*;"ListBoxName";$Row) ar_invBalance{$row}:="New item" OBJECT SET ENTERABLE(ar_invBalance{$row};True) EDIT ITEM(ar_invBalance;$row) the command LISTBOX INSERT ROWS adds the row(s) at the end of

Re: Creating .docx files

2018-01-21 Thread Patrick Emanuel via 4D_Tech
Did you try with phpword? It is a php librairy usefull to create .DOCX document. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Collections in v16R4

2017-07-20 Thread Patrick Emanuel via 4D_Tech
Hi guys, discussions about SDI is very interesting, but the title of this thread is about Collections. May a new thread will be a better place for SDI? ;-) - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002,

Re: HTML Editor in 4D

2017-03-28 Thread Patrick Emanuel via 4D_Tech
Hi, I had the same need few times ago and change TinyMCE for jhtmlarea. jhtmlarea can be manage exactly like TinyMCE except than I found that is easier to work with it. I have not the 4D database here, but i'm pretty sure that I haven't activate the webkit option. Patrick - Patrick

Re: Host Structure in a component

2017-03-13 Thread Patrick Emanuel via 4D_Tech
I had no issue with this kind of code from a compiled component. However, you can write: ARRAY LONGINT($tableNums;0) ARRAY TEXT($tableNames;0) Begin SQL SELECT TABLE_ID , TABLE_NAME FROM _USER_TABLES INTO :$tableNums, :$tableNames; End SQL - Patrick EMANUEL

Re: PHP EXECUTE in a loop

2017-03-13 Thread Patrick Emanuel via 4D_Tech
Before call any 'PHP EXECUTE', I used these 2 code lines first: $isOK:=PHP Execute("";"relaunch_4d_php") PHP SET OPTION(2;True;*) Since, I have few PHP error like you describe. - Patrick EMANUEL Administrator