Questions tagged as 'sql'

Tagged questions
0
answers

problem when printing a report in ireport

Hello colleagues, what happens is that when I preview my report using the jar ireport, it loads it well, it appears in the position I want, like this: But, when you send it to print, it ends like this: Any property you are not...
asked by 09.04.2018 / 19:00
2
answers

Php odbc postresql

I need your help for days fighting to solve this error :    syntax error, unexpected 'else' (T_ELSE) The code in php is as follows: <?php include('conexion.php'); $desde = $_POST['desde']; $hasta = $_POST['hasta']; //COMPROBAMOS...
asked by 18.04.2018 / 19:49
0
answers

migrate database access to sql server

I have two databases in access with extension .401 and .402, I want to import them into SQL server. I already tried saving them as extensions .mdb and .accdb, and I can not pass all the tables to sql, only half are imported, the rest I do not ha...
asked by 13.04.2018 / 21:22
2
answers

sql query error using php

<tr id="campo-select"> <td> <strong>Personas:</strong> </td> <td> <?php $consulta_listar_usuario = $usuario->listUserpordepartamento($conexion); ?>...
asked by 06.04.2018 / 19:48
0
answers

How to add new check type column in postgres?

I am working under a database that already has content, so I just need to add a role column in the user table, this column should only allow 3 values: [alumno,academico,administrador] . When I create a table I usually only do the follow...
asked by 07.04.2018 / 00:05
0
answers

Using files to save SQL queries is good for performance

I am doing a new project in node.js, but I have the question whether it is a good idea to save the SQL queries in file to be able to version in git, since I am using the orm squelize. using the fs library of node.js, to retrieve the inf...
asked by 04.04.2018 / 19:54
1
answer

Relational model of an organizational structure, SQL SERVER

if someone can help me .. I am creating a database for an organizational structure of a company that has different levels, that is I have a main node from which more children hang and so on 6 levels. It's saying something like that .....
asked by 10.04.2018 / 13:05
0
answers

How they encrypted a text sql server field and that they suggest me to decrypt

I must recover the contents of a database but I do not know what method they used here, the field is of the text type     
asked by 10.04.2018 / 15:49
0
answers

How to position a row in datagriview c #

The information that I show in the datagriview comes from a stored procedure of sql server, where I insert a row to add the total, now what I want is to be able to position is row that appears at the beginning some serious idea of a lot of...
asked by 10.04.2018 / 14:22
0
answers

sql query from a table in an excel file

My query is: on how to insert texts from a table in an excel file, to textboxes (vba form) using an sql query. this is the code: Private Sub cmdBuscar_Click() On Error Resume Next Const adOpenStatic = 3 Const adLockOptimistic = 3 Const...
asked by 05.04.2018 / 20:42