InterBase is a SQL database system for server, desktop and embedded applications, for use on Windows, Linux, macOS, iOS and Android. InterBase 2020 is the newest version and integrates with Embarcadero's RAD Studio IDE supporting Delphi and C++ development. InterBase supports connectivity from many other programming languages as well. See https://www.embarcadero.com/products/interbase for further information.
Questions tagged [interbase]
356 questions
-1
votes
1 answer
Firebird to My sql query giving error on query in my php script
This question is probably duplicate and will be greatly down voted, but I am so desperate, I need to ask. Can anyone see the syntax error in this query? Any suggestions? Should I post the whole php script file?
SELECT
…
Nancy
- 504
- 2
- 6
- 21
-1
votes
1 answer
Error "Token uknown" in Borland
Hello I got the error:
Token unknown - line 1, char 74
when I try to make a query with sql injection,without parameter I don't have any problem, here is the code:
DbProviderFactory factory=…
George Ntaskas
- 1
- 3
-1
votes
2 answers
How reliable are modern databases in the presence of disk errors?
InterBase had an architecture that caused disk-writes to leave the database in an always-consistent state
-- 97 things every software architect should know, p87
Is this property finally common in 2010 ?
Is there a study about database…
wiwulo
- 201
- 3
- 10
-1
votes
2 answers
Interbase XE7 Precedence using Brackets
To demonstrate the issue I am having, I am using a single table which has a DATE and a TIME field as part of the record.
For the example I wish to filter from 07:00 on one day to 06:59 the next day, so my query is as follows:
SELECT * FROM…
James Fergus
- 21
- 4
-1
votes
1 answer
What is the tADOConnection.ConnectionString in Delphi to access the Interbase server
I have a WindowsXPSP3 op system, on it a DelphiXE and InterbaseXE installed.
I created a database in IB and it works OK through the IBConsole and ISQL and connection testing also works through TCP/IP localhost:3050.
Now I try to access it from…
user3340032
- 3
- 3
-2
votes
1 answer
The char* fn_Substr(char* s, short m, short n) function does not return the correct value
I am developing a user defined function dll ib_udf64cpp.dll to my InterBase 2020 database.
I am using Embarcadero C++ Builder Alexandria 11.1 to develop and test the functions exported from the ib_udf64cpp.dll.
The code of the exported…
IMeMine
- 5
- 3
-2
votes
2 answers
Stored procedure select VS select from external connection
I am trying to find the pros and cons of using stored procedures instead of SQL queries from an external connection, but I am unable to find any direct comparison.
What is the benefit of using stored procedures instead of SQL queries from an…
Yordan Yanakiev
- 2,546
- 3
- 39
- 88
-2
votes
1 answer
Simplify SQL query to Interbase DB
I have WPF application which task is to drag data from Interbase DB. Note, that this DB is located on the remote network device. Also, Firebird ado.net data provider is used.
One of my query looks like:
SELECT
T1.ind_st,
T2.ttt,
…
Eugene
- 41
- 8
-2
votes
1 answer
Interbase partitioning
Is there a way to partition a table by range, hash or list like we do in MySQL?
I've look on many forums and such sites and haven't found anything.
Well, hope you can help me with this thing that's driving me mad.
-2
votes
2 answers
to calculate a discount?
There are 3 tables - Discounts(Discount) Customers(Clients) and Orders(Orders)
Discount
------------------------------------------------
|id_discount | count_orders | percent_discount |
------------------------------------------------
| 1 |…
Mr.Steps
- 1
- 1
- 1
-5
votes
2 answers
How to return a count of fields with a given value in a record?
I have a database table with the following fields :
---------------------
FIELDS : | H1 | H2 | H3 | H4
---------------------
VALUES : | A | B | A | C
---------------------
For a given record (row), I…
Samona
- 13
- 2