I have a ESTOQUE table containing a field called QTDE , this field has 3 decimal places.
What would be the command to return straight from SQL formatted with 3 houses? Because the whole values are returning without the houses....
Hello, directly asking, how does this type of field work?
I know there are three types:
BLOB = 64KB, MEDIUMBLOB = 16MB and LONGBLOB = 4GB
Given this example:
CREATE TABLE COMPROMISSOS (
ID INTEGER NOT NULL,
DESCRICAO...
I have a SQL query that searches two tables for a primary and one for history
but when I run the query the values come duplicated I use UNION All
because if I by UNION or DISTINCT displays the following message:
...
Speaking of SGDB Firebird , when using GDS32.dll library, out of compatibility with banks created by Interbase , are there other differences when using fbclient.dll ?
Is there a difference between creating b...
Hello! I am developing a C # application, in which I have already installed it on several machines for testing with windows xp, 7 and 8 and in all of them the application worked correctly, however on a specific machine it just does not run and i...
I have a project in Delphi 7 that makes use of Firebird.
I'm thinking of migrating this application to a Delphi XE * version.
However, we know that since Delphi 2009 the String pattern is Unicode and not ANSI anymore.
My Firebird database...
I do in mysql to search the last 1000 regitros:
select * from tabela order by id desc limit 1000;
Now, how do you do this in Firebird?
This way I get the following error message:
Dynamic SQL Error
-SQL error code = @ 1
-Token...