Questions tagged as 'sql'

Tagged questions
0
answers

Load bank table per session system

I am developing an application, where one of the modules is the product register, and within that register, I have the fiscal part. In this fiscal part, I have to define an NCM, and consequently the IPI rate, so I created a table with NCM cod...
asked by 11.08.2016 / 04:30
1
answer

Java check two tables within SQLite

I have a database that has two tables, being EstoqueDBQ and FilaDBQ , I need to create the following logic. If the value exists in the FilaDBQ table and in stoqueDBQ , this value should be excluded from FilaDBQ, I thought I'd...
asked by 18.03.2016 / 13:16
0
answers

Consult user in SQLite [closed]

I need to validate a user in the database. If it is valid, I want to call the second Activity. What method to use to do this validation in the android database? Insertion code: public String insereProfessor(Professor professor) { Con...
asked by 08.09.2016 / 20:12
0
answers

Create new user in the database via Rails C

Help me where the error is occurring, because I am not able to identify because the field is not being recognized.    rails c u = User.new(email:'[email protected]', registration:192536, password:'changeme', password_confirmation:'changeme') Look...
asked by 06.09.2016 / 21:01
1
answer

org.hibernate.PropertyNotFoundException: Could not find setter for sum on class Class

I'm trying to list the best selling products using SQLQuery (if anyone knows of other ways to perform such as eg using Criteria, Projections also supported) with Hibernate, org.hibernate.PropertyNotFoundException: Could not find setter for...
asked by 06.09.2016 / 20:18
1
answer

SQL query using order by filtering through the records [closed]

I have the table: | cod | hora | produto | Amostra | Min | Max | |-----|-------|---------|---------|-----|-----| | 1 | 08:00 | 96722 | 1 | 100 | 200 | | 2 | 08:23 | 96721 | 1 | 90 | 90 | | 3 | 08:50 | 96722 | 2...
asked by 06.09.2016 / 16:08
1
answer

Search PHP + SQL can not find results without typing the hyphen "-"

Hello! I have a search for auto products where the user can search for the company code, original code, product line, assembler or vehicle. This system is working if in the search field I type, for example, "E-1001", or "1001", or "E". But if I...
asked by 22.08.2016 / 20:11
1
answer

Using SUM () in mysql returning incorrect value

I'm having trouble building an sql that returns the sum of the entries and the sum of the outputs correctly. I have tables tbl_produtos(id_produto,NomeProduto) , tbl_entradas_produtos(Id_produto,QuantProdutos,Estoque,ExcluirProdutoEnt)...
asked by 02.08.2016 / 18:14
1
answer

TbQuery back N records

In delphi if I give a TbQuery.prior it returns a record. But if I want to return N records, for example, I want to go back 5 records. Does anyone know if there is any method in delphi that does this?     
asked by 20.06.2016 / 20:44
0
answers

Npgsql failed to call plpgsql function

I'm doing tests of Npgsql . One of the tests tests the return of a plpgsql function. But the test is failing by saying that the function does not exist. In the description of the error the name is given in the function passed and the param...
asked by 19.06.2016 / 17:43