Questions tagged as 'sql'

Tagged questions
1
answer

Why do you show the data as null if I have a record with more than one user?

Again I need your help community, I have the following table in my database, with the records of a user's schedule (the rout are fictitious) I have registered three schedules with the same date and different time for the same user, if I...
asked by 10.11.2017 / 15:36
0
answers

Show all the records of a MySQL field in a Select HTML

Good evening, I'm making a system for the university of the reservation of some mini-audits, One (01) user can make several reservations and after booking the user must inform the payment by uploading a pdf. I show the user a form to inform t...
asked by 12.11.2017 / 05:29
1
answer

Get DATE column of the JTable to save it in SQL

I have: SQL Server 2017 I have jcalendar-1.4 added to my project I have import java.sql.Date; in my class. I have the column fechaNacimiento type DATE in my database. To obtain the information from the da...
asked by 11.11.2017 / 04:28
1
answer

SQL scripts contained in EXE

I have this scenario, a set of several scripts that I need are contained in the EXE to avoid modifications on the part of the user and that are: 1) creation of the database 2) inserts of the teachers 3) inserts of the test data When execut...
asked by 11.11.2017 / 08:34
0
answers

An attempt to attach an auto-named database for file

I am working on a login in ASP but when I do the query it sends me the following error:    An attempt to attach an auto-named database for file C: \ Users \ Jose Pablo \ Documents \ Visual Studio 2015 \ WebSites \ ProyectoFinal \ App_Data \ s...
asked by 17.11.2017 / 21:45
1
answer

ERROR WHEN CREATING FIELD WITH DATA TO MYSQL PHPMYADMIN (1 & 1 hosting)

When creating the field dateee I get an error, and that is when I put the datatype ... I'm using a paid hosting sql (1 & 1) and it creates conflict with a sql statement .. The sentence: ALTER TABLE publicaciones ADD dateee DATETIM...
asked by 06.11.2017 / 15:04
0
answers

Connect with AWS from C # winform

I have an Application written in C# winform and the database ( SQLSERVER EXPRESS ) is in AWS (Amazon Web Services). I'm using a connection string like this: namespace Datos { public class Configuracion { static p...
asked by 30.10.2017 / 14:39
1
answer

SQL: consult and compose result

Good, I'm trying to make a query for SQLlite, in it I have a table from which I refer to three other tables called Statu_Actual similar to the following table. tabla: *Statu_Actual* id_Puesto | id_Clientes | id_Vhiculo | Status 1 1...
asked by 30.10.2017 / 03:25
2
answers

no How to get the last value inserted in the BD Oraclexe?

I am working in JEE, with WebLogic and OracleXE as a database engine, I am using a DataSource (NO JPA), in this database you have to create sequences to generate autoincremental values, I already did it and it works well when I execute it becaus...
asked by 31.10.2017 / 13:31
1
answer

Because when executing my sql script when I get to the part of my autoincrementable triggers it stays in a loop?

Create some triggers so that my primary keys are autoincrementable at the time of inserting but at the time of executing my script everything executes well when you are going to execute the first trigger that is Trigger_idcomisario stays in a lo...
asked by 21.11.2017 / 01:31