Questions tagged as 'update'

Tagged questions
2
answers

Update to several records

   I want to update all the records of a table (tbl_DepresacionesUmas) where the status is different to low but when doing that, it returns more than one value and generates an error, how can I solve that in sql? Update Tbl_DepresacionesU...
asked by 14.08.2018 / 21:49
1
answer

SELECT FOR UPDATE MYSQL

I have a simple query that I execute in mysql with phpmyadmin : select * from tabla for udpate ; But I get an error "an expression was expected" . I can not realize what is missing. Thanks!     
asked by 11.08.2018 / 00:17
1
answer

Creation of Script to complete data

My problem is to generate a location report by teams having the following BD: The problem with the report is that the equipment table saves the entry ID or movement automatically but not the location, so you would have to make a script....
asked by 08.08.2018 / 19:22
1
answer

Update table with sum

Good morning People, I need the column "Expenses" to be added as new records are being entered. Try to do it with an update, I work in mysql but doing it in sql server throws me an error. The sales id is with the number 3 because before loading...
asked by 07.08.2018 / 14:22
1
answer

firebase update multiple database realtime

I'm doing a sales system with firebase and javascript, I have products and I want to modify several of them at the same time with the following code only modifies me the first one for (var i = 0; i < compra.length; i++) { if (compr...
asked by 20.07.2018 / 15:14
1
answer

How to update the data with the button instead of the blur

How I have a huge doubt, I have my table and now I update the data and all I need is to do it by pressing a button and NOT by clicking outside the table with blur. I leave my code, Thank you. <script src="../../js/jquery-3.3.1.min.js">&l...
asked by 11.07.2018 / 22:16
0
answers

Error in PostgreSQL trigger - UPDATE

I have a question for you. I am developing a database in which I have a table called "currencies", which has a field called dvs_local (boolean) which indicates which is the local currency of the system (only one of the table - TRUE, the rest mus...
asked by 04.07.2018 / 01:47
0
answers

Update in firebase Cloud

I have the following code to update in firebase: this.db.collection('users').doc(nombre).update({ 'data_array' : { status:estatus } }) .then(function () { }) .catch(function (error) { console.log("Error ! "+error); });...
asked by 29.06.2018 / 00:26
1
answer

Insert enum field (mysql) multiple checkbox values

I need help to insert multiple values in mysql of a checkbox in a form: I have these checkboxes in my form <LABEL>Extras (los que procedan):</LABEL> <INPUT TYPE="checkbox" NAME="extras[]" VALUE="Vista Al Mar">Vista...
asked by 27.05.2018 / 19:34
0
answers

How to update 3 tables in a single statement with SQLite 3?

Friends I want to update only the APPROVED column of each Table. I need to set its value to TRUE only where the REVISED column (of the same row) is TRUE. I have the following 3 tables TABLE A: ID APROBADO REVISADO 1 FALSE FALSE...
asked by 09.05.2018 / 19:02