Questions tagged as 'transacciones'

Tagged questions
1
answer

How to execute a transaction within a Command

I am making an application that will register an order and for that I need to use the transaction sentences. I have developed an attempt that I will attach below and the following error:    Unhandled exception of type 'System.InvalidOperation...
asked by 31.10.2018 / 14:04
2
answers

Put a variable as a title in an sql server query

I want you to show me a variable variable in the header. When I do this: declare @dato char(6) declare @sql varchar(800) set @dato='201601' select @sql='select @dato as '+ @dato exec(@sql) I get this error:    Msg 137, Level 15, State...
asked by 14.09.2016 / 17:52
1
answer

Stored procedure does not run completely when I call it from PHP

I'm having a very serious problem because it does not let me continue with the project I'm developing. The logic is as follows, I upload a file of Excel to the server (from a web system) then I read the data that is in the file of E...
asked by 22.04.2016 / 16:11
3
answers

Combine prepared transactions and queries

I am studying the subject of transactions and queries prepared in PHP. Testing I have created a code to combine transactions with prepared queries. It would be something like that (imagine that the connection is already established by PDO): tr...
asked by 01.02.2018 / 01:48
1
answer

Insert data to sql server only if the 3 "insert" were correct

Good afternoon, I am currently filling in 3 tables in my database, so when the data is obtained they are entered in the first table, I get the primary key of the first insert and then fill it in the following two, I tried my code and everything...
asked by 09.11.2017 / 20:55
4
answers

Register sale with its retail detail through transactions in a stored procedure MYSQL

I'm trying to register 2 tables through transactions in MySQL and I have a table VENTA , to which I put as a field the field id_venta and is type int autoincrement, plus I have the table DETALLE_VENTA , which has as FK...
asked by 01.07.2016 / 20:01
1
answer

Doubt rollback in PHP / MySQL

I am starting to use TRANSACTIONS in PHP / MySQL but I am observing the following situation: In my tests I have noticed that rollback is not necessary although I have read that they are always put to return the data to its original stat...
asked by 20.06.2018 / 08:02
0
answers

How to fill the JFrame fields stored in MySQL using Hibernate?

my question is how can I fill in the fields of my JFrame with the data stored in my bbdd using hibernate? That is, I select a row of my JTable , I get its id and by clicking on a edit button there will be a form that will have a...
asked by 14.12.2018 / 15:23
0
answers

doubt transactions between different objects java

I am trying to develop a small example of what I understood about object-oriented programming with JAVA, but I have a question, I have two objects: PROCESS AND REQUEST the procedure has a relation with request, I have a method in which it is cal...
asked by 31.01.2018 / 00:27
2
answers

SQL TRANSACTIONS

A query, I have a procedure with transaction handling, in which several INSERT must be executed, as I do to know in which INSERT I failed the procedure in such a way that I can show in the RAISERROR message something like "error to insert...
asked by 26.01.2018 / 21:02