I am making a web module for an old system that uses Firebird. I made the connection using the PDO, but when I make a query using some special character it does not return results. If you do not use a special character, the query works perfectly...
Personally I found the following webservice tutorial: link
Looking at the tutorial I was a bit confused about it.
1- Should the web service be part of the Android application?
For example I create a web service I put this web service...
I'm doing a search where the user enters the order ID and the system does return the request's observation, product code and qtd. And these data are arranged in 2 tables. (I did not create the bank, it already came ready) However, with my query...
How to concatenate String in Firebird?
I'm trying like this:
select ("00"||"01") AS TESTE from tabela
I have tried with parentheses, no parentheses, with column name, without the column name ... it just will not ...
is giving the fol...
I'm doing a project with a firebird database but, at the time of authenticating the user, it is returning true even if there is no user registered in the database with the if (ER.HasRows) line, so it is not falling in else . I'm not...
I have a table with approximately 7 thousand records, I need to create a new column in this table but I would like all the old records to have the value 'S', when I try to create the column the fields get null value, passing as default ' S'. How...
I am doing a query in a database and I need to display the information on the screen, but searching one by one. I tried to do it by array, but it is not displaying the vector.
Code:
<?php
$a = $_GET['a'];
if($a == "buscar"){
$id = $_PO...
I own this table code
CREATE TABLE news (
id_news INTEGER NOT NULL,
title VARCHAR(128) NOT NULL,
slug VARCHAR(128) NOT NULL,
text TEXT NOT NULL,
PRIMARY KEY (id_news),
KEY slug (slug)
);
You are experiencing the f...
I have a field called patient_id, I want to create a select + - so
select count(paciente_id where = 0), count(paciente_id where <> 0) from agenda
I do not know, but I want to know the amount of items where patient_id is equal to zero...
I'm doing a system in Delphi 2010 with Firebird 2.5 that I select a database and I need to pass the local path to my Database on my Sqlconnection.
procedure TFormImportDados.btnBuscaArquivoClick(Sender: TObject);
begin
OpenDialog.Execute();...