HeckDan's questions

Make the button with an image and assign a script to this image, ok everything is correct up to here.

I need help to generate the Script that adds the random value that is generated between a certain range to a certain cell, something like the function =ALEATORIO.ENTRE(celda1;celda2);... but this function is executed every time the page is updated, so I want to make a button so that The random number will only be generated when I hit this button.

I've been studying the Google Apps Script, but I'm still not very skilled if you can help me that would be great. So far what I am understanding is that I must proceed, I must create the function, I must indicate in the sheet that I am in this case I have placed .getActiveSpreadsheet();so that it takes the active sheet without having to put the Id of the sheet. Now I must proceed to recognize the two cells where the minimum and maximum range for which the random will be generated is; in this case cell B2 and cell B3 indicate the corresponding ones. From what I have seen, I must specify the helpers to be able to handle the sheet and its data, the sheet variable refers to the first sheet of the document (the sheet or book with index 0), now I need to place the result of the random numbers in the cell B6

function Sorteo(){
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = ss.getSheetByName("Sorteo");
 var cell = sheet.getRange("B6");
 var rango_min = sheet.getRange("B2");
 var rango_max = sheet.getRange("B3");
 cell.setValue(Math.floor((Math.random()*(rango_max - rango_min)) + rango_min));
}

If so far I am doing well, how can I make this happen when I press the button?

// Edit // I ran the code without further ado, I didn't add anything to onClick()it that I thought it would need, apparently, it ran straight, but...

It has given me the following message as a result in the correct cell:#¡NÚM!

// I return to Edit // The error has been corrected after the suggestion of the user Ruben. I have given it many times to draw and it has not gone out of the limits, if someone else can verify that the draw formula is "correct" I would appreciate it. Add the function to the button and it's very nice!

Greetings, Concatenating data in BIRT is actually simple, the data field is placed: Ejm:

dataSetRow["IMPUESTO"]+" "+(dataSetRow["PVP"]*dataSetRow["IMPUESTO"])/100

where the use of the +" "+ does the concatenation in the BIRT, but if I want to split the content by some character how should I do ? because what you put above would result in:

Taking as an example that the tax is 12 , the amount without tax is 200 and the result of AMOUNT*TAX/100 is 24

1224.00 <<< something like WTF?

if I want something like 12 - 24% or 12 / 24% to remain in the same "Data"

if I put something inside the +" / "+ it doesn't take the concatenation and show me only the first one :( how can I make it work?

There is a lot of information about mam, but I can't find anything concrete to help me understand those complex tables where there is a Ternary Relationship (between 3) ; I know that for these cases an intermediate table must be created, something like the child table of a trio.

This table will have to inherit the primary fields from its mothers and convert those primary fields into a "composite primary field" (help me with the definitions in case I'm wrong, I'm not very clear on the topic that's why I ask the question ) if so let's see the following example ( not complete ):

CREATE TABLE `taller_bdphp`.`t3_asignacion` (

        `idst3` INT(7) NOT NULL AUTO_INCREMENT ,    /*este seria el id para
                                                    identificar el registro, ejemplo: Registro numero: 203*/

         `placa` VARCHAR(10) NOT NULL ,                 /*esto seria una FK y a 
                                                    su vez una PK de la tabla vehiculos*/

        `cedula_p` INT(8) NOT NULL ,                /*esto seria una FK y a 
                                                    su vez una PK de la tabla personal, 
                                                    sirve para indicar el mecánico que esta trabajando con el vehiculo y que servicio le realiza a su vez*/

        `idservicio` INT(3) NOT NULL ,              /*esto seria un FK y asu vez una PK de la tabla servicios, 
                                                    (existen determinados servicios, por ejemplo: Revision, Mantenimiento, Lavado.
                                                    y se le debe poder asignar uno o mas servicios al vehiculo.*/

         `fecha_iniciot3` DATE NOT NULL ,           /*esto seria un campo propio de la tabla ternaria,
                                                    indica la fecha en que se inicia el servicio asignado*/

        `fecha_fint3` DATE NULL ,                    /* otro campo que puede estar nulo,
                                                     indica la fecha que se termina el servicio (cuando el vehiculo se va)*/

        `Estadot3` VARCHAR(1000) NULL ,             /*otro campo simple para escribir o comentar sobre el estado del servicio*/

         PRIMARY KEY (`idst3`)) ENGINE = InnoDB;

(Uff I get tired doing that hehe...) I hope that you can understand it better... If you understood the table... the FK is NOT COMPLETE and the declaration of the "COMPOSITE PRIMARY KEY" ARE NOT DONE... That's my question: How do you do that?

• Would the foreign fields have to be placed or declared again? is repeating them required? Here I don't know, because since they are also primary I don't know how to consider them in this case...
• On the other hand, after that, how would the "COMPOSITE PRIMARY KEY" be declared? PRIMARY KEY ( idst3, placa, cedula_p, idservicio)) <<< would that be the correct way?
• Lastly, how would the foreign keys be declared, those if they remain the same one by one with the same method as always? Well the method I use is:

FOREIGN KEY(placa) REFERENCES vehiculos(placa),

Is that method correct? although there are people who place a CONSTRAINT on it that I never really knew what it was for because even if it is not placed it still works, there are also those who add the

ON DELETE CASDADE ON UPDATE CASCADE,(to update the tables in "cascade" [if one is modified, the others are modified]) ¿In phpmyadmin, the ones that will be foreign and part of the primary compound are placed as index. You must then choose to create an index of a single column or create compound index??!

Reference Source: https://www.genbetadev.com/bases-de-datos/bases-de-datos-y-relaciones-ternarias

https://www.w3schools.com/sql/sql_foreignkey.asp

When declaring the primary key (PK) of a table (eg USER), there are several options:

• An existing field ( username) can be placed as a primary key (natural key), so the username will be validated so that there is no other equal. For example:

  CREATE TABLE usuarios(
    username VARCHAR(30) not null;
    password VARCHAR(30) not null;
    tipo_u   VARCHAR(10) null;
  
    PRIMARY KEY(username)
  ) ENGINE INNODB
  

• A new field ( iduser) can be added as a primary key (surrogate key), perhaps auto-incremental if desired. For example:

  CREATE TABLE usuarios(
    iduser   INT not null AUTO_INCREMENT;
    username VARCHAR(30) not null;
    password VARCHAR(30) not null;
    tipo_u   VARCHAR(10) null;
  
    PRIMARY KEY(iduser)
  ) ENGINE INNODB
  

Is one of the two more recommended? Which of the two ways allows a better performance in a database? What advantages does each method bring?

Is it more secure using the iduser? I really don't see much use for it, but I have seen that many sites use it like this.

I have learned USING by doing things like this:

SELECT nufactura,des,cantidadc,precio,precio*cantidadc AS "SUBTOTAL"
FROM `facturas` INNER JOIN `fac_pro` USING(nufactura)INNER JOIN `productos` USING(codigop)
WHERE nufactura = "700" 
ORDER BY cantidadc DESC

but I haven't really understood its order very well or why it is like that, much less the use with ON and WHERE and that call with nombre.nombre1.That point I don't really know what it does. Is it the same as FROM ? Is it like a pointer or something?

I have these doubts in SQL... it is a not so strict language and it runs despite the different ways of writing it... What exactly is the difference between CREATE SCHEMA and CREATE DATEBASE when I started to see the code generated by Workbech, it works with SCHEMA and really, that word has me a bit sick... all my short life of studying sql had been DATABASE: S

On the other hand, taking advantage of the question... the Workbench also makes use of the CONSTRAINT in front of the FOREIGNKEY

Here is an example of code generated by Workbench

CREATE TABLE IF NOT EXISTS `tallermecanico_hd`.`e_vehiculos` (
`placa` INT NOT NULL,
`marca` VARCHAR(25) NULL,
`modelo` VARCHAR(25) NULL,
`anio` VARCHAR(4) NULL,
`observ` VARCHAR(255) NULL,
`serial` VARCHAR(25) NULL,
`color` VARCHAR(25) NULL,
`puertas` INT,
`motor` VARCHAR(25) NULL,
`transmision` VARCHAR(25) NULL,
//<<<aqui yo colocaria el campo foraneo cedula_c pero workbench no lo hizo<<<
PRIMARY KEY (`placa`),
CONSTRAINT `cedula_c`
FOREIGN KEY ()
REFERENCES `tallermecanico_hd`.`c_clientes` ()
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;

I was used to just placing the Foreignkey like this:

FOREINGN KEY(cedula_c)REFERENCES c_clientes

and if it works the same but what is the difference D: what does the CONSTRAINT do??? In addition, the Workbench uses the name of the database. name of the table. In addition, I do not put anything inside the parentheses of references and it does not create the foreign field cedula_c

How do I look for the theme of the points... [db].[table] what is that called that point is the same as putting FROM or something similar? that has some name to look for that topic well that nobody gave me >.<