Questions tagged as 'firebird'

Tagged questions
0
answers

Upload with php - problem with charset

I have a problem that has been disturbing me for some time. I have a page for simple image upload, the page is on charset utf-8 and the firebird database on iso8859-1. The reason for the system being in utf-8 is that all the plug-ins I use fr...
asked by 28.11.2017 / 20:59
1
answer

Procedure does not return the entire column

I created a procedure with ibexpert, does commit correctly, but at the time of running procedure , I get the error:    multiple rows in singleton select. My intention is to list all the values in the city column of the target table. Whe...
asked by 01.12.2017 / 06:56
1
answer

How do I store the value of the field returned with the "insert" command in a variable?

I have a Procedure that performs the "inserts" and "updates" in the tables. The need to create it was to try to centralize all the scan functions before inserting or updating records. Today there was a need to return the value of the table's "...
asked by 15.11.2017 / 03:52
1
answer

Search various PHP database items

I'm having the following problem with PHP , I'm doing a search on a Firebird database so that I can issue a report with sales orders. I will enter the order IDs one by one and will return the values for me. However, every time I...
asked by 16.10.2017 / 20:16
1
answer

Problem connecting to Firebird database

Personally, I'm having a project to do a report that does a search on a firebird bank and I'm with the .fb file ready to create the bank. However, in connection with dbschema it gives me this driver error. I researched the internet and cou...
asked by 04.10.2017 / 05:33
0
answers

PHP Connection with FIREBIRD Database

I'm trying to make the connection between PHP with the FireBird database, but I've tried several alternatives and I can not solve it. The error message that appears when trying to connect is as follows:    Fatal error: Uncaught Error: Call to...
asked by 13.09.2017 / 16:04
1
answer

Select connecting 3 tables in Firebird with different IDs

Good afternoon, I need to make a select that returns the description of the product, barcode and price . The description and price are in one table (TB_ESTOQUE) and the barcode is in another (TB_EST_PRODUCT). However, the IDs of th...
asked by 07.07.2017 / 21:48
1
answer

Code page with accent on Command Prompt

When updating my system application, a command line is called to execute a script to update the database. The script calls the Isql tool of Firebird by sending the file containing the SQL statements as a parameter. What happens is that there...
asked by 08.07.2017 / 00:03
2
answers

SELECT on a date in the range of ONE entered date and the date of the next record

How to generate a select that brings the date between an informed date and the date of the next record? In the Cargos table I only have a date, not a data_inicio and a data_fim , and I need to know the date between th...
asked by 31.05.2017 / 15:13
0
answers

Interbase (Firebird) with WampServer

I can not run php_interbase on my WAMP server, I uncommented the php.ini line, and even then PHP did not recognize it. My Wamp is 2.5 in 64x with PHP 5.5, Windows 64 bits usage. I installed Firebird on my ma...
asked by 31.05.2017 / 13:30