Questions tagged [Firebird] (73)

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...

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...

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...

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...

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...

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. ...

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...

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...

At the moment connect to the MySQL database using the SQLAlchemy module. Is it possible also means a flask'to connect to Firebird dB?

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.