Angel Montes de Oca's questions

I need values ​​that go like this:

0.5   
1  
1.5  
2  
2.5  
3  
Etc

I made a function but I don't know if it can be done in another way that requires less code, here is my code:

private String GetNumber(int spinner) {
        String result = "0";
        if (spinner == 1) {
            result = "0.5";
        }
        if (spinner == 2) {
            result = "1";
        }
        if (spinner == 3) {
            result = "1.5";
        }
        if (spinner == 4) {
            result = "2";
        }
        if (spinner == 5) {
            result = "2.5";
        }
        if (spinner == 6) {
            result = "3";
        }
        if (spinner == 7) {
            result = "3.5";
        }
        if (spinner == 8) {
            result = "4";
        }
        if (spinner == 9) {
            result = "4.5";
        }
        if (spinner == 10) {
            result = "5";
        }
        if (spinner == 11) {
            result = "5.5";
        }
        if (spinner == 12) {
            result = "6";
        }
        if (spinner == 13) {
            result = "6.5";
        }
        if (spinner == 14) {
            result = "7";
        }
        if (spinner == 15) {
            result = "7.5";
        }
        if (spinner == 16) {
            result = "8";
        }
        if (spinner == 17) {
            result = "8.5";
        }
        if (spinner == 18) {
            result = "9";
        }
        if (spinner == 19) {
            result = "9.5";
        }
        if (spinner == 20) {
            result = "10";
        }

        return result;

    }

Is it the correct way or is there an easier way?

I am creating a .exeto run a .jar, it works, the only problem is that it shows a popup( CMD) for a few milliseconds, is there any way to make this not happen?

Here my code to run the .bat:

using System;

namespace Launch
{
    class MainClass
    {
        public static void Main(string[] args)

        {
            System.Diagnostics.Process.Start("start.bat");
        }
    }
}

this is my .bat:

@echo off
cd "C:\Program Files (x86)\START"
"C:\Program Files (x86)\START\jre8\bin\javaw.exe" -jar -XX:+UseConcMarkSweepGC -Xmx1024M -Xms1024M START.jar

Another way I tried was to do everything from C#(but got the same result):

using System.Diagnostics;

namespace Launch
{
    class MainClass
    {
        public static void Main(string[] args)

        {           

            ProcessStartInfo psi = new ProcessStartInfo();
            psi.Arguments = "-jar -XX:+UseConcMarkSweepGC -Xmx1024M -Xms1024M START.jar";
            psi.CreateNoWindow = true;
            psi.WindowStyle = ProcessWindowStyle.Hidden;
            psi.FileName = "jre8\\bin\\javaw.exe";
            Process.Start(psi);


        }
    }
}

I want to verify if my database exists before continuing with the execution of my program, but I don't know where to start, because I have looked at some examples and nothing has worked for me.

This is the query you want to throw:

"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'Data_base'"

I am trying to compare a variable with a String but I have not found a way to do it, the variable is the result of a function, which the result can be "Terminal" or "Server", which I can print without any problem, the The problem is that I can't find a way to compare it with a string, here is my code:

function seleccionar(){
osascript <<EOT
set rTipo to the button returned of (display dialog "$1" buttons {"Terminal", "Servidor"} default button "Servidor")
if(rTipo = "Terminal")then
return rTipo
do shell script "echo 'type=terminal'> ~/Desktop/type.txt"
end if
if(rTipo = "Servidor")then
return rTipo
do shell script "echo 'type=servidor'> ~/Desktop/type.txt"
end if
EOT
}

value="$(seleccionar 'Selecciona el tipo de instalacion:')"
echo $value

I'm looking to compare it like this:

if value == "Servidor ; then
  if lsof -Pi :3306 -sTCP:LISTEN -t >/dev/null ; then #comprueba el puerto 3306
  echo "El puerto 3306 ya se encuentra en uso"
  exit 1
  fi
fi

is there any way?

I have a .pkg that I have created to distribute my company's software, but when downloaded from other macs it says "It cannot be opened because it comes from an unidentified developer", the pkg is signed with a valid App Store Installer type certificate With the productign tool , the certificate appears correctly in the upper right part of the .pkg and it is valid, it opens without any problem, except when it is downloaded from the internet, is there any other way to sign it or avoid that?

I have created an installer with the Packages.pkg tool , but when distributing it on other macs it doesn't allow it to be installed because it only allows the appstore and identified developers, I already have my certificate, but I don't know how to sign it, how can I do it?

I am creating a script to delete some files (my purpose is to learn to use the dialogs and execute some tasks), I was building it based on examples on the net, the dialogs work fine, except when I want it to execute the commands sudo, it tells me:

syntax error: End of line expected but identifier found. (-2741)

At first I tried to create a function to call it but it didn't work either, this is what I have so far:

#!/bin/sh
osascript <<EOT
 app "System Events"
set answer to the button returned of (display dialog "Deseas eliminar MySQL?" buttons {"Si", "No"} default button 2)
#display dialog "You selected " & answer
if answer = "No" then
display dialog "Cancelado" buttons {"Aceptar"}
else
if (answer = "Si")then
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/var/mysql
sudo rm -rf /usr/local/mysql*
sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo rm -rf /var/db/receipts/com.mysql.*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /private/var/db/receipts/*mysql*
launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysql.plist
launchctl unload -w ~/Library/LaunchDaemons/com.st.plist
set answer to the button returned of (display dialog "Se ha eliminado MySQL, es necesario reiniciar.\nDeseas reiniciar ahora?" buttons {"Si","Reiniciar mas tarde"}default button 2)
end if
end if
return  -- Suppress result
end
EOT

I'm trying to create a script .shto capture the action of a dialog on Mac that shows the buttons Noand Sithen execute code depending on the response, I have not been able to get it to take the user's actions.

This is what I have achieved:

    #!/bin/sh
    #!/usr/bin/env bash

    # error "Message"
    function advertencia() {
    osascript <<EOT
    tell app "System Events"
    display dialog "$1" buttons {"No","Si"} default button 2 with icon caution with title "$(basename $0)"
    return result
    end tell
    EOT
    }

    resultado=$(advertencia "Selecciona una opcion:")

    if ["$resultado" == "Si"]; then
       advertencia "Seleccionaste Si"
    else
       advertencia "Seleccionaste no"
    fi

But it does not work.

I have previously created (with Inno Setup , pascal) an installer for windows ( Here the Link ) which has custom pages, text fields, combo box, radio buttons, scripts, license, installation modes, among others, this is my installer for Windows:

• I have been researching how to replicate it on Mac, since I want to make a native installer.

• I've come across Packages , which can create Plug-Ins but I didn't find the skip page function as well as the installer I created.

• I found PackageMaker (Apple) and it was the same, I can't create such a custom installer.

I found that Opera has a custom installer, it's more or less what I want to achieve (Next, next, back, etc.) but I can't find a way to do it on MacOS:

I have a JProgressBar and it comes out in orange, I have tried to change the color with this but it has not given results:

 UIManager.put("progresoIP.background", Color.BLUE);
 UIManager.put("progresoIP.foreground", Color.BLUE);
 UIManager.put("progresoIP.selectionBackground", Color.BLUE);
 UIManager.put("progresoIP.selectionForeground", Color.BLUE);

and with this:

  progresoIP.setForeground(Color.blue);
  progresoIP.setBackground(Color.blue);

positioned underinitComponents();

still the same:

I have a TEdit in Inno Setup and would like to set a maximum of 20 characters:

eDBnameT := TNewEdit.Create(TerminalPage);
  eDBnameT.Top := ScaleY(270);
  eDBnameT.Left := ScaleX(130);
  eDBnameT.Width := ScaleX(200);
  eDBnameT.Height := ScaleY(23);
  eDBnameT.Text := 'sicar';
  eDBnameT.Parent := WizardForm.InnerPage;
  eDBnameT.Visible := False;

I have tried with:

eDBnameT.Length := 20;

but it throws me an error.

I need to make the cursor change while it is executing a specific task, return it to normal when finished.

I have one DLL( TransferImg.dll) that is written in C#(provided by an external company), which they tell me that I need to create an interface to access image transmission functions from JAVA, I have been investigating how, but I have not found something that understands or works.

The data provided to me is: - TransferImg.dll library
- Add reference to project.
- Add Using Transfer;
- Create Object Command myobj = new Command();
- Call the function myobj.SendImagesToScalewhich returns an integer with the error.

This is the function I want to use:

int SendImagesToScale(string Ip, string PathImage ,string Tipo, Socket iSock);

I don't have a clear idea how to do it, this is my code taken from an example:

public class SendImg {
    public interface CLibrary extends Library {
        CLibrary INSTANCE = (CLibrary)
            Native.loadLibrary((Platform.isWindows() ? "C:\TransferImg.dll" : "c#"),                                   CLibrary.class);

        void SendImagesToScale(string Ip, string PathImage ,string Tipo, Socket iSock);
    }

    public static void main(String[] args) {
        CLibrary.INSTANCE.SendImagesToScale("192.168.1.111", "C:\img.jpg", "Splash", 3306);

    }
}

Dll: TransferImg.dll

I need to hide a page in Inno Setup depending on a variable booleanin Inno Setup, how can I do it?

Create a page based on an answer to my question How to create an options page in Inno Setup? The only thing I don't understand is how to grab the one that is selected to create the condition.
Could someone explain to me how to do it?

Here I leave my code:

InstallTypePage := CreateInputOptionPage(wpSelectDir,'Texto1', 'Texto2', 'Texto3', True, False);

    //Crea los radio buttons en esta página
    InstallTypePageID := InstallTypePage.ID;
    InstallTypePage.Add('Instalar');
    InstallTypePage.Add('Reparar');
    InstallTypePage.Add('Desinstalar'); 

I need to create a page for my installer that contains radio buttons with the options of:

• Install
• Repair
• uninstall

I am completely new to Inno Setup I would appreciate your answers thank you very much.

I am trying to create an installer with Inno Setup which installs a Server or Terminal of a point of sale, the problem is that when I install a terminal I need to verify if the database exists in the Hostspecified (Server) to be able to advance.

The way I achieve and get close to what I want to do is by running the mysqldump.exe:

mysqldump.exe -uroot -pjavac -P3500 -h10.1.12.79 baseDatos

The problem I have is that I don't want to create a backup, I just need to check if the database exists or not, with some lightweight command line program.

Is there any tool that can check the existence of a database and can run it for CMDsimilar?

I am trying to insert the values ​​like this:

INSERT INTO `paises`.`moneda` (`mon_id`, `moneda`, `abr`, `tipoCambio`, `singPlur`, `caracter`,`mn` ,`img16`, `img24`, `img32`, `status`)
VALUES (1, PESO MEXICANO, MXN, 18.7000, PESO:PESOS, $, 1,?,?,?,1);

I want to put them in a script .sqland later execute it with a file.bat

@ECHO OFF
ECHO Insertando Datos...
"C:\Users\Winchester\Desktop\mysql.exe" -u root --password=javac -P 3306 < "C:\Users\Winchester\Desktop\insertar-monedas.sql"
ECHO Completado
pause

But I get the error of

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MEXICAN, MXN, 18.7000, PESO:PESOS, $, 1,?,?,?,1)' at line 2

In my installer created with Inno Setup it was necessary to check the availability of a port to install and mount a MySQL service, since if the port is in use it is necessary to change it.

I am making an installer, which needs to send a query at the end of the installation and after mounting the sMySQL service. I have no idea how this is done, this would be in the CODE section in PascalScript.

Once the installation is finished, an XML is accessed to load them to a couple of ListBox, having them selected we send the data (which includes Country, Currency and some others). Previously it was done using JAVA with IzPack , with the following code.

    String insert = "INSERT INTO `simarin`.`moneda` (`mon_id`, `moneda`, `abr`, `tipoCambio`, `singPlur`, `caracter`,`mn` ,`img16`, `img24`, `img32`, `status`) "
            + "VALUES (" + ((isPrincipal) ? "1" : "null") + ", '" + de.getName() + "', '" + de.getWSMoneda().getAbr() + "', " + convert(a.getWSMoneda(), de.getWSMoneda()) + " "
            + ", '" + de.getWSMoneda().getSingPlur() + "', '" + de.getWSMoneda().getCaracter()
            + "'," + (isPrincipal ? 1 : 0) + " ,?, ?, ?, 1);";

    PreparedStatement pse = conn.prepareStatement(insert);
    pse.setBlob(1, b16);
    pse.setBlob(2, b24);
    pse.setBlob(3, b32);
    pse.execute();

It is the code that was passed to me to translate it to Inno Setup but I have no idea how to do it. Does anyone know what it would be like?