Questions tagged as 'sql'

Tagged questions
2
answers

Error in database (android studio) sql

table products has no column named direc 10-08 14: 25: 09.403 939-939 / com.example.arturosv.problem E / SQLiteDatabase: Error inserting Number = 6.0 direc = gh Tel = 67.0 name = a Main main code package com.example.arturosv.problem; impor...
asked by 08.10.2016 / 21:30
2
answers

Display the current date each time a command is executed

Is there a command or function that shows the date when a command is executed? Use SQL Developer, and for example if I run: select sysdate from dual Set the system date, and I want the date to be with hours, minutes and seconds. How cou...
asked by 06.10.2016 / 19:04
1
answer

Select within Select in SQL query with VB.net

I have 2 tables:    -Article       -Articulo_Panio The Article table has, among others, the Stock_Local field (which would be the stock that is physically in the business) and in the table Article_Panio are the items that are insid...
asked by 24.06.2016 / 02:19
1
answer

How to get a value in SQL Server Chain

I mean, I have a string of numbers that seems like they are not, but a chain is reproduced in the following way: 1881181818181818181800 What I need is to make a selection in the second pair of numbers that would be 81 search for number 81 b...
asked by 05.09.2016 / 22:29
1
answer

Join in sqlalchemy

I am trying to pass a query that I have made - and I already tried it in SQL - to SQLAlchemy in python using Flask. This is the query in SQL: select Reclamo.IdReclamo from Reclamo,ServicioAsignacion,ReclamoServicioAsignacionAfectado where S...
asked by 23.09.2016 / 17:00
3
answers

Error getting multiple results from a subquery - SQL

I want to make a select, with 3 columns, the first is an id , the second is a name , and the third another name . The objective is to obtain in a final table that I already have mounted, a column that contains one or another name dependin...
asked by 25.11.2016 / 13:59
1
answer

SQL script with column '-1'

I have this SQL script: create view transactview as ( select SUM(quantity) as venta,tag,shift_id,pump,nozzle from transactions where tag in (100,200,300,400) group by tag,shift_id,pump,nozzle union select SUM(quantity) as venta,'-1',shift_...
asked by 12.08.2016 / 16:13
1
answer

Problems the query takes me as Alert Injection SQL

Thank you in advance for answering. The problem is that when I run the following query I get an alert injection SQL . \!/ ALERTA !!!!! [09 Aug 2016 10:45:30] <br> TIPO: SQL INJECTION-INTERNO <br> URL ATAQUE: /gci//workflowgest...
asked by 09.08.2016 / 18:06
1
answer

Problem with sub-query in Access

I have a database in Access that has the following tables: Table Options Columns: Id_Option int Option varchar (50) Status (bit) Contains these data: Table Votes Columns: Vote_ID int Id_Option int...
asked by 16.08.2016 / 23:59
3
answers

Error "User does not have sufficient privileges or object not found"

I have a problem with UcanAccess, which is when using the WHERE clause, it throws me an error. ConnectAccess.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class...
asked by 21.08.2016 / 21:42