Control for database script

  1. 8 months ago

    Is there any control available to add mysql queries(script) in it?

    What i want to do is place queries somewhere and then read it line by line and execute on database.

    i tried it by using TextArea control but seems there is characters limit for textarea as i am not able to add my all the queries in it.

  2. Emile S

    8 Nov 2019 Europe (France, Strasbourg)

    @chetana n characters limit for textarea

    What’s your installed RAM value ?

    What is your script size ?

  3. @Emile S What’s your installed RAM value ?

    What is your script size ?

    i have 8 GB RAM and Windows 10 OS.

    i don't know the total no. of characters but there are about 50,000 lines of script, out of them about 10,000 get copied into TextArea's value editor

    Maximum Characters allowed is set to 0.

    When i backspace few characters then i can enter that much characters.

  4. Louis D

    8 Nov 2019 Testers, Xojo Pro QC, Canada

    I would place the script lines in an array of strings. Then, I would use a listbox to display a moving window of the array elements. For example, you start showing script lines at index 0 to index 24. With a pageDown, you fetch elements 25 to 49, and so on. You can then develop logic to edit specific elements, move up and down by larger or smaller increments, even run individual elements or groups of elements. The key is that the data is kept in the array, and the UI only serves to show and manipulate the data.

    Arrays can have a maximum index value of 2,147,483,646 therefore with this concept, you are probably constrained by the system resources only.

  5. Jean-Yves P

    8 Nov 2019 Testers, Xojo Pro Europe (France, Besançon)

    did you try with this custom-edit-field control :

or Sign Up to reply!