With this SQL command I enter some data in the table, the problem is, in the system the field "ROUTES_PROCESSUAIS.OBSERVACAO" is with line breaks and at save time via SQL the line break is lost.
Would you like to make this SQL insert...
I am a beginner in PHP and I am creating a personal project to consolidate my knowledge until I came across a problem, when entering a name that has an apostrophe this apostrophe causes INSERT INTO not to execute causing the data are not...
I'm having a problem sending FILE data to DB.
With the help of @zuul I came to this problem.
<?php
require("conectar.php"); //chama o arquivo de conexão ao BD
if (isset($_POST['Nome'])) {
$Nome = $_POST['Nome'];
}
$Morada = $_POST['M...
Next I have to do a search and implement a query in the database using Merge and I have to do this using one of the scripts used in class.
The problem is that when I run the script it gives the following error in insert and the...
I would like to know if it is possible to make a INSERT and a UPDATE in the same query, that is, in the same operation.
I'm using the following to do both.
public Connection conn = null;
...
conn = DriverManager.getConnection...
Hello,
I have the following script, .sql, to create a table and also create a trigger.
SET client_encoding TO 'LATIN1';
CREATE OR REPLACE FUNCTION before_insert() RETURNS trigger AS '
DECLARE
n integer;
BEGIN
IF tg_op = ''INSERT'...
I would like to know how to set an insert pattern in a column in SQL.
Example:
CREATE TABLE XPTO(
ID INT IDENTITY(1,1),
NOME VARCHAR(100) NOT NULL,
ATIVO CHAR(1) NOT NULL)
In this case, I want to limit the ACTIVE fie...
Follow the code:
//informações necessarias para inserir no DB.
coo := copy(lTemp,53,6);
ccf := copy(lTemp,47,6);
ecf := copy(lTemp,4,20);
//Data sendo formatada para ser inserida...