I have the following code to create a stored procedure:
CREATE PROCEDURE UpdateProductos(
_Id int,
_Producto varchar(60),
_CategoriaId int,
_Descripcion varchar(400),
_UsuarioModificador varchar(60),
_Estado int
)
BEGI...
Following as regards my doubts about Hibernate is concerned.
Let's say I have a database with the table asignatura .
CREATE TABLE IF NOT EXISTS 'asignatura' (
'id' int(11) NOT NULL,
'name' varchar(12) NOT NULL,
PRIMARY KEY ('id')
)...
In a new installation of Gx15 u10 when trying to connect to a Database MySQL 8.0.12 shows the error of the capture:
MySQLNonTransientConnectionException: Client does not support
authentication protocol requested by server;...
I have the following code:
<button onclick="javascript:descargarZip(this.value)" value="<%=sArchivoZip%>"><img src="./IMG/icons/mail-arrow-down-icon.png" /></button>
which calls a download function in js:
function...
I'm doing an inner join of 3 tables and it does not work ... with 2 tables it's all good .. when I add the third table it does not show me anything.
<?php
try{
require_once('include/funciones/db_conexion.php');...
Good day! I have a problem, I am trying to fill a JComboBox from mysql, and I can not! :( The console does not send me an error but it does not show anything either, I'm just starting in this and I do not have much experience! Hopefully someone...
I have the following sentence that helps me to update the fields of a detail_dulce table that collects only numerical values
update producto
inner join detalle_dulce on detalle_dulce.idp = producto.idp
inner join existencia on producto.idp = e...
*** I have the following PHP file to connect to a database in MySQL:
Connection.php
<?php
$Link = 'mysql:host=localhost;dbname=yt_colores';
$Usuario = 'root';
$Password = 'root';
try{
$PDO = new PDO($Link, $Usuario, $Password);
} catch...
I make a query to the Database where it brings me a certain initial numbers and some endings that are saved in the arrays $ initial and $ final.
I go through these arrays with a while but I want that every time the array is traversed, the initia...
I have a condition that will be executed depending on the data that is being sent to the procedure.
This is my code:
CREATE DEFINER = erp@localhost PROCEDURE sp_stockProductoMovimientoAlmacen(
idProducto VARCHAR(50),
operacion CHAR(6),...