Questions tagged [Firebird] (73)

2
answers

Group sample?

For example, there is such a request: select case when id in (1,2,3,4) then 'Elementary school' when id in (5,6,7,8,9) then 'high school' when id in (10,11) then 'high school' end Class_type, COUNT(*), sum(case when s.ocenka>4 then 1 end as) 'Honors' from class c group by Class_type You need to like this report was...
Timothy asked April 16th 20 at 10:47
2
answers

Delicious in the group?

Hello! ID - the class number (1-11), name - name of the class (the first class of the eleventh, i.e. the string) and COUNT how many students in the class. Let's say so. select ID, NAME, COUNT(*) from class c group by c.id, c.name He brings 1 first class 40 2 the second class .... I need three lines Elementary school Hi...
Winnifred asked April 16th 20 at 09:56
0
answer

How to migrate a Firebird database to another drive (a symlink)?

There is a car on Windows 10 Pro 32бита, server Firebird 2.5 SuperServer 32 bits and multiple databases. Database scattered on the disk E:\ with file names of the type "DBBALBLABLA123.FDB" Task: move database files *.FDB in C:\databases\AmirsDB\*.FDB and normal file names. Everything must be transparent to users. Did the f...
Kiarra asked April 9th 20 at 09:42
1
answer

How to subtract from date sql 12 hours?

Good time of day. There is a request to the current corrupt database. Firebird 2.1. The query is executed via isql. SELECT C. CODE AS "Service", C. NAME AS "name", T. TRANZDATE AS "date", max(T. TRANZTIME) AS "Time", T. INFOSTR AS "Map", sum(T. SUMM) AS Summa FROM DOCUMENT D LEFT JOIN TRANZT T ON D. ID = T. DOCUMENT...
jaylan_Ratke5 asked April 8th 20 at 17:12
1
answer

Why the request to the same Firebird database from php and OO Base works differently?

Trying to get data from the database Firebird 3 using php (Laravel - jacquestvanzuydam / laravel-firebird) The table 664 records. And php sees it. Here is the query using php is working fine: select first 10 skip 10 * from "CONTROL_TBL" order by "name" asc Do this: select skip 100 first 10 * from "CONTROL_TBL" order by "na...
andy asked April 8th 20 at 09:21
1
answer

How to execute sql query using bat file?

Good time of day. There is a task: to run a daily sql query using bat file. Firebird server 2.1 on localhost. Use built-in utility isql. Trying to run a. bat file, but it returns empty results, using cmd, the same query works. What is a mistake? Maybe something else you need to make a request? C PowerShell is not familiar. ...
owen_Spenc asked April 8th 20 at 02:56
1
answer

How to calculate the sum of the same values in the same column, but different in another?

We have a working database under Firebird base for sales. I have the following query: SELECT (C. CODE) AS "a Service", (C. NAME) AS "name", T. TRANZDATE AS "date", T. TRANZTIME AS "Time", (T. INFOSTR) AS a "Map" of T. AS SUMM Summa FROM DOCUMENT D LEFT JOIN T ON TRANZT D. ID = T. DOCUMENTID JOIN CLIENT C ON D. CLIEN...
Gudrun asked April 7th 20 at 16:16
2
answers

How to increase the life time of an application will connect to Firebird?

Went to "inherited" facial joints - a simple application written, apparently, in Delphi, which as a DBMS uses firebird. So, if the application is inactive (the user does not use it) for over 10 minutes (approximately) - when you attempt some action within the application, you receive an error about re-authorization. There i...
Hellen.Howell21 asked April 3rd 20 at 18:26
1
answer

Is it possible to connect to a Firebird dB using Flask?

At the moment connect to the MySQL database using the SQLAlchemy module. Is it possible also means a flask'to connect to Firebird dB?
Jake.OConne asked April 2nd 20 at 17:13
0
answer

What are the testing tools databases for Delphi?

Good time of day. I need to test the manipulation of the database. (DBMS Firebird, if it matters). What is or what are some tools to test database? Thank you. UPD: After manipulation can (and should) change the structure and some data. I need to check whether this was done. How it should be done I know.
leonor.Lind66 asked April 2nd 20 at 16:16