Questions tagged as 'sql'

Tagged questions
0
answers

What do I do with "provider can not be found. it may not be properly installed "?

I have this problem with the RAD studio 10.2 when executing a program that shows the data of a table in a grid ... (yes, very basic). Work with pgAdmin 4 I do not know if this helps, since I was reading that the problem is with the...
asked by 28.10.2017 / 16:34
1
answer

ORA-02270 assign a fk to a part of the primary key

Hi, I have a problem because a foreign key is part of the primary key of the other table and that is why it gives the error, the model according to the solution of the book is as it is here, so I do not know how do for Oracle to assume it as goo...
asked by 28.10.2017 / 03:01
0
answers

ExecuteScalar SQL Server does not store an integer? C #

Good afternoon, I would like to know what I'm doing wrong because when I save the data through an insert, I keep the primary key with a very large value (it seems to be decimal) the table has the primary key as identity so that should be saved 1...
asked by 09.11.2017 / 19:15
2
answers

how to view the records by user

Good evening, I'm doing a system for booking juices in php, but what happens is that when making a booking record, all users can see the reservations of others and I just want them to see their own reservation. //este codigo es para mostrar la...
asked by 09.11.2017 / 18:53
0
answers

mysql query with several filters

I have this query in MySQL and I would like to know if it is possible to make the following queries with this query: at least for the date range for a start date without providing the final date only by first name, last name, person...
asked by 26.10.2017 / 16:45
0
answers

Which query is faster?

Good morning. I need to make an update to a table (table a) of 50000 records from a table (table b) of 200000 records where I look in table b for all the records that match table a. I have these two questions: UPDATE data_0_pagos a INNER...
asked by 26.10.2017 / 21:14
1
answer

Firebird materialized views

Good afternoon colleagues, I'm trying to improve the performance of a database in Firebird 1.5; I've noticed that the consultations I do on some views take too long, and I read there is a way to materialize the view to improve performance. I'...
asked by 20.10.2017 / 20:15
0
answers

SQL query does not run

I have a table [texts] in phpmyadmin like this: Column [column1] - > Type [int (20)] - > Null [no] - > Default [None] Column [column2] - > Type [text] - > Null [no] - > Default [None] . . The first column is used as...
asked by 19.10.2017 / 06:46
1
answer

sql-workbench find record that is not repeated in two tables

Good morning everyone ... Let's see who can help me with this simple query ... I have a database formula 1, in it there are two tables, one is cars and the other participation, the participation table has the key (codeCoche) foreign cars that pa...
asked by 01.11.2017 / 15:30
0
answers

Error "DATE data type is not found" when executing query

I'm working on sql server and I have to put a field with the variable DATE but when I run the query it sends me this error: Columna, parámetro o variable nº 9: no se encuentra el tipo de datos DATE.     
asked by 23.10.2017 / 20:00