Questions tagged as 'tablas'

Tagged questions
1
answer

Table with consecutive and accumulator in Vue

In this table programmed in VUE 2 I want this result: +-------------------------------------------+ | fact $importe $ acumula consecutivo | +-------------------------------------------+ | 23 $ 350 $ 350 1 | | 28...
asked by 27.12.2018 / 02:46
1
answer

PROBLEM RELATIONSHIPS LARAVEL TABLES

I need your help, I am making a list of tables in laravel with migration, which tables are 'Products', 'inputs' and 'ProductProduct', the relationship or database would be from 1 to many (1 product has N inputs) but this error appears:    121...
asked by 04.11.2018 / 22:11
1
answer

Drop table in a MySQL trigger

I would like to know if there is a possibility of having the sentence "DROP TABLE TABLATEMPORAL" using MySQL inside a trigger, since when trying to save the trigger with this sentence I get the following error: "There was an error while apply...
asked by 05.09.2018 / 07:07
0
answers

Help in relational model for a Time Tracking system

I proceed to explain what the project that I just started is about to explain my concern. It is a time tracking system but at its most basic level, nothing compared to the large systems that already exist (primaERP, Harvest etc) in which the...
asked by 20.05.2018 / 05:25
1
answer

Simple SELECT SQL doubt

I have a table with the following records (the fields are Formula - Base): F1 - B1 F1 - B2 F1 - B3 F2 - B1 F2 - B2 F3 - B1 F3 - B2 F3 - B4 What I want is for me to select which formulas contain the bases B1, B2 and B3....
asked by 14.11.2018 / 17:13
1
answer

SQL close date

Along with saying hello and thanks for this space, I ask for help with the following. I have two tables .. the table1. is a historical sales record with the fields fecha_vta, código_producto, cantidad. in the other table I have the variation of...
asked by 05.12.2018 / 17:01
1
answer

Substring in a comparison (ON)

Friends, I'm doing a SQL query where I have to use only part of the characters in one column and compare it with another to get the matches: SELECT A.NUMCLIEN,A.CODIDENT,A.CLAIDENT,A.DIGIDENT,C.ENTIOFI,C.CUENTA FROM GPBC.UGDTMAE C JOIN GPBC.PE...
asked by 27.10.2018 / 02:18
2
answers

Searcher in JQuery, Ajax and PHP (Error)

I try to create a search form in the following way: By default, the order history appears: $(document).ready(function(){ $.ajax({ type: 'POST', url: 'php/cargar_historial.php' }) .done(function(listas_rep){ $('#historial...
asked by 28.08.2018 / 16:38
1
answer

how to align the td of a bootstrap table

Dear friends, I have a data table loaded from a javascript function ... it contains the following: html+="<table class='table table-hover table-striped table-responsive'>"; html+="<thead><td class='tamano_celda_th'>FECHA</...
asked by 30.10.2018 / 19:28
0
answers

Create several tables with different names from a macro

Hi, I'm new using python, I'm trying to read several csv files and create a table in python for each of them. I already managed to import them but I do not know how to make the name of each table change, here's the code: import os import glob...
asked by 04.11.2018 / 21:43