Re: How to Verify Page Setup for a Form?

I would say "QS_Toolbox", form editor ;-) 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: Use Named Selection Unexpectedly Loads First Record of Named Selection

Hi Douglas Doc says: When you create a named selection, the current record is “remembered” by the named selection. USE NAMED SELECTION retrieves the position of this record and makes the record the new current record; this command loads the current record. In your example, the first record is

Re: 4D Summit Virtual?

It seems difficult now for any European to come in USA for the next month. - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: DOCUMENT LIST : how do I know the documents are valid

Just an idea I set once on a project: check the size of the document. Until size is changing, consider that the copy/move is not finish and wait 1 second more. - Patrick EMANUEL Administrator www.association-qualisoft.eu

Re: Command(s) with column and C-number

Hi Arnaud, You're absolutely right. Thanks to remind me it and figure out this! - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Command(s) with column and C-number

Hi, I would say that it helps you if you share code with someone which is not working with the same 'language', or between different version of 4D. Sometimes, commands are renamed and using the token (:C) force to update the syntax. It is also the same for constants ;-) Patrick -

Re: Event handler method in component

Hi Arnaud, I had also the same problem and the only way I found is, like all of us, to insert a method onto the host to call back it. Not sure that the object is a solution. Nothing found on this and not sure that another solution exists. Patrick - Patrick EMANUEL

Components and external data

Hi, I understand that if a component needs to have access to 1 or more tables there are 2 ways to do this: - Inject the table definition(s) into the host - USE DATABASE and connect to an external database/datafile. I have some questions about using external databases in the context of a

Re: LIST USER FORMS does not work on 4D Server anymore

Hi Julio, If you have a look on the red icon present on the documentation and let the mouse on it, you'll see 'Not for server'. If you click on it, you'll get all commands 'Not for server'. This information is also available on our latest QS_toolbox version. Patrick - Patrick EMANUEL

Re: post-icon conversion

4D Tech mailing list wrote > FYI, the find is working, but the replace is not. The ID's stay negative > even though I tell 4D to replace them without the negative. Unfortunaly,yes, you're right. I remember having written a method to do that by code, and not working at all. I got confirmation

Re: post-icon conversion

Waiting V18 to manipulate project files which for some will be flat format could be a solution for someone whose want to deliver an application in V18 For the others which are not able to move to v18 for some reasons (client doesn't change system version, ), they have to do that 'manually',

Re: post-icon conversion

Hi, I really suggest you to export your library to a folder and to set this folder into your "ressources" folder. After that, redo the link with all pictures, unfortunally, must be done manually. At long terms, it is an investment because the day you have to update the picture, you just have to

Re: Printing structures

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: Printing structures

Hi Tom, should be good if you're able to share it here ;-) Cheers Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: [ANN] AJ_Tools_UnitTest

Thanks Maurice for all these tools! 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: AW: v13 or v15 Pic Library usage

If you have any question, don't hesitate to ping me at the association email : i...@asociation-qualisoft.eu Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: v13 or v15 Pic Library usage

Hi Chip you can use QS_Toolbox. There is a tool which list you the objects using pictures. The current version (2.20) is in V15 Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso &

Re: Stylesheet Search?

Hi Robert, In QS_Toolbox there are 2 functions: - one to list style sheet definition - one which list all object and style sheet attach To change them, you have to do it manually. In the future, we should be able to update this information directly on the exported project file. Patrick -

Re: Quick Open Method (QOM)

Hi Tim, yes, you did. Thanks again 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: Quick Open Method (QOM)

Hi Tim, thanks a lot :-) I'm fine with commands METHOD and work a lot with them in QST. My concern is about how you display the result inside the "Find" result dialog from 4D application. If it is not this, it is really realistic as result. Patrick - Patrick EMANUEL

Re: Quick Open Method (QOM)

Hi Tim Very impressive and useful! Great job. By curiosity, can you explain us the trick you use to get the result into the search dialog? Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply

Re: v15 to v17 Conversion of Obsolete _o_C_STRING/_o_ARRAY STRING Commands

Absolutly, and there are also some tools (free) that can help you, like QS_Toolbox ;-) - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Printing structures

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

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

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

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

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

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'

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

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?

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?

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?

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?

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

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

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

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: Web Area display PDF

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?

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

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?

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

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?

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?

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: Macro to check that local variables are declared in a method? [Solved]

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

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?

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?

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?

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

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

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

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

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

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

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

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?

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?

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

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: HTML Editor in 4D

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

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