Trying to write to an SQL table an image, its name and description, and any foreign keys to allow me to subsequently search.
On execution I get conversion error from to Int 32 .
But all the fields in the table are set correctly.
What am...
I'm trying to make a system that gets images and saved them in a specific database, but I can not solve this error (I already applied CONVERT in SQL but it did not solve).
(Error Area)
//Aqui vai entrar a gravação do db
SqlConnection conect =...
I am trying to write to a table several fields of a Windows Form App.
Some of these fields are foreign keys from other tables.
If the fields have values, the SQL statement executes but if they do not have values I get a conversion error (Text to...
Code
DECLARE
BEGIN
FOR I IN (SELECT * FROM PRODUTOS_TESTE2) LOOP
DBMS_OUTPUT.PUT_LINE(I.codigo|| ' - ' || I.categoria || ' - ' || I.VALOR);
END LOOP;
END;
Error message:
Relatório de erros -
ORA-06550: line 5, col...
I have this PL-SQL code:
/*1. Criar um bloco PL/SQL anônimo para imprimir a tabuada abaixo:*/
DECLARE
VN CONSTANT NUMBER(2) := 5;
BEGIN
FOR i IN 1..1O LOOP
DBMS_OUTPUT.PUT_(VN || ' X ' || i ||'='|| VN*i);
END LOOP;
END;
Er...
I want to change get_where to mysql or PDO, but I do not know! Help ...!
public function get_where($table = '', $where = NULL, $limit = NULL, $offset = NULL)
{
if ($table !== '')
{
$this->from($table);
}
if ($where...
I know that I can check codes that are in one table and are not in another with the following query :
SELECT cod FROM tabela1 WHERE cod NOT IN (SELECT cod FROM tabela2)
But how can I check the records that are not in a table but are in a c...
I need to convert a field from Nvarchar to Float in a search, and get the highest value.
This function works
SELECT MAX(valor)
from [Enops].[dbo].[Tbl_Pulsomedia15_Vazao_Eta_B_Bentes]
Where valor <> 'processando' and valor <>...
I have an application that lists in a grid files that are registered in the table
SCF_Process Documentation
However, now I need to list only if this file also exists in the table
SCF_ARQUIVO_UPLOAD
What the application does i...