Stack Overflow
Stack Overflow

Questions tagged [interbase]

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.

331 questions
0
votes
2 answers

How to hide stored procedures and triggers code from users other than SYSDBA in Interbase?

I found some information about the encryption and embedded password features in Interbase 2009, but it does not prevent database users to see the source code. Is it possible to hide the stored procedures and triggers codes from all user including…
Colin Jong
  • 63
  • 1
  • 5
0
votes
1 answer

Remove white space between words in interbase

I need to remove all white space between "words" in interbase. Coming from a SQL server background I was assuming (wrongly) that interbase would support a replace function but aparently doesn't. So given a telephone number that may or may not…
Rich Andrews
  • 4,108
  • 3
  • 33
  • 48
0
votes
2 answers

Correct use of alias in Interbase subqueries

I have a problem with my newly created aliases ABONO and CARGO. The ALIASES (for the column names of the result) and SQL query works fine UNTIL I try to calculate "ABONO-CARGO AS AJUSTE" => Interbase gives an error that it does not know the column…
Florian Wagner
  • 31
  • 2
  • 8
0
votes
1 answer

Loading large firebird datafile table into a DataSet

I have a Firbird 1.0 data file weighting aprox 25 GB that I am working with it. It has a table which has stored documents and doc's pics as blob. So, I am asking is it possible to open such big data file using fib datasets, i firstly tried to open…
Suhrob Samiev
  • 1,478
  • 1
  • 24
  • 55
0
votes
1 answer

Deploying Interbase ToGo on Mac OS X

Here are the conditions for the experiment: Interbase ToGo is licensed Interbase folder including the license folder is in the same folder as my multi-platform application called myPgm.app developed by Delphi XE2 as HD-FMX application. When…
user1311715
  • 1
  • 1
-1
votes
1 answer

Unable to log into Local Server -gds_db InterBase Developer Edition

Unable to log into Local Server -gds_db after download of Interbase Developer Edition. Getting "Error logging into the requested server" Connection rejected by remote interface' .Using un/pw of SYSDBA masterkey.
Richard King
  • 1
-1
votes
1 answer

Some columns returned empty from interbase sql

I have strange problem on my pc/server. I run query such as Select field1, fieldId from myTable this will return in average 10 results Now the strange thing: sometimes when i render it to my drop down list, the fieldId is blank, i mean rendered…
cpoDesign
  • 8,060
  • 11
  • 56
  • 98
-1
votes
1 answer

Search Interbase with php form (drop down list with values of one column)

I am trying to make a search form (which will be best to be with drop down menu) with values from column CUST_BULSTAT and to fetch a single row data that will be printed into a text template document. On this stage I am connecting to database and…
Ombre
  • 1
-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
  • 5
  • 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

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

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
  • 23
  • 5
-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.
Diana Cruz
  • 1
-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 2 3
…
22
23