Posts by Pr99 • 65 points
6 posts
-
0
votes1
answer28
viewsQ: Doubt with this query
My teacher made the following query, to show the total amount of stock of each product, however I do not understand very well how it does to generate the total stock quantity of each product,…
-
0
votes1
answer356
viewsQ: How to validate jcomboBox before saving
I have the following problem, I am trying to validate these jcombobox, I want that if the user does not select an item from the movie jcombobox, a message appears: "Select Movie", if it is the…
-
2
votes1
answer63
viewsQ: Error in user registration, changing user instead insert
My problem is the following, I saw that when I edit a record , it works, the registration is changed, but when I want to register a new user, it falls in the editing condition, it edits the…
-
1
votes0
answers72
viewsQ: How to improve my input and output validation
I have the function inserir, and in it has an input and output validation, first she makes a select with the function count with a where referencing the product code, then it falls into condition…
-
0
votes1
answer62
viewsQ: How to prevent me from registering the same movie again
I have this method: test method of the package view location class public int teste(){ String selecao = cbFilmes.getSelectedItem().toString(); String[] campos_filmes = selecao.replace("…
-
2
votes0
answers106
viewsQ: How to make a Trigger Delete with validations
I have the following problem, I want after I delete a location from the leases table I go in the movies table and make the situation column as available, but in case I have the movie code in the…