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.

356 questions
0
votes
2 answers

INSERT WITH NOT EXISITS

I'd like to combine an insert query with a "where not exists" Here my SQL : INSERT INTO MYTABLE (ACT_ORDER, MNU_ACTION, ACT_STATUT, ACT_BEFORE, ACT_AFTER) SELECT (1,'acOuvPOS', 'T', 'T', NULL) WHERE NOT EXISTS (SELECT * FROM MYTABLE WHERE …
mimou_2009
  • 47
  • 7
0
votes
1 answer

Importing a CSV file using a FDBatchMove into a FDTableTask

I am starting my first app that needs an embedded database, ability to import a CSV into a table and display the results into a Grid. I used the Live Binding Wizard to link my grid to a BindSourceDB. Here are the basic components I am…
Robert Griffin realsol
  • 187
  • 2
  • 9
0
votes
1 answer

Interbase PSQL return values

I wrote a very simple script. I am new to PSQL and I wanted to return some values based on a very simple loop. CREATE PROCEDURE DRAW_DOWN RETURNS( I_VAL INTEGER) AS DECLARE VARIABLE STARTING_BALANCE INTEGER; DECLARE VARIABLE TRADING_SERIES…
TommyK
  • 416
  • 2
  • 6
  • 24
0
votes
1 answer

InterBase - Casting calculated column as varying character

I am attempting to write a query that uses a calculated value, I then want to cast this calculated value as a string so that I can add a '%' to the end. However I am not succeeding with the query below: select a.Subjects, a.RequiredTime,…
Cliff Crerar
  • 433
  • 8
  • 24
0
votes
2 answers

How do I configure IIS 7 to allow a remote database connection from within an ISAPI Web Server

I have a native Web service application (ISAPI) that I have built with Delphi 2010. At this time, it only exposes two methods. The first one, EchoString, is designed to give me feedback that the Web service is functioning properly, and it adds a…
Cary Jensen
  • 3,751
  • 3
  • 32
  • 55
0
votes
1 answer

How to use a multi value parameter from SSRS an interbase query

Interbase cannot accept multi value parameters with ? It can use WHERE sl.Truck_Nbr IN ("A205", "A206") but not WHERE sl.Truck_Nbr IN (?). I have tried using ="""" & (Join(Parameters!Parameter3.Value,""",""")) & """" in the parameter expression…
Rolland
  • 11
  • 1
0
votes
1 answer

Interbase export to CSV

We are using Interbase XE3 (2013) with Delphi XE. We need to export tables as CSV-File as they are imported into MsAccess for further controlling purposes. For exporting we use the function of IBExpert and/or by our own program (Export as CSV-File…
Matze
  • 1
  • 3
0
votes
1 answer

Connecting to Firebird using ODBC

I have downloaded Firebird_ODBC_2.0.4.155_Win32. I have also started ODBC Data Sources from the Control Panel. Now I cant find Firebird/InterBase driver in the Drivers Tab. I am sure that I installed Firebird. Why?
alyssaeliyah
  • 2,214
  • 6
  • 33
  • 80
0
votes
1 answer

Using Interbase in delphi7

I am new to Interbase in delphi. Could anyone show me how to properly use Interbase to query data from a Firebird database in coding? I have tried something like this: procedure TfJM00001.af_search; var i : integer; qryQuery :…
Chhun Panharath
  • 136
  • 1
  • 10
0
votes
1 answer

SQL Server linked server to Interbase

I have created a linked server to an Interbase database with the OLE DB Provider from IBProvider.com. This worked really well, but apparently this IBProvider was only a test version which has expired. Instead of buying the full version I was…
Mance
  • 79
  • 1
  • 8
0
votes
1 answer

Delphi and Interbase: username and password not defined?

I recently encountered a legacy code (Delphi 2007). There is a SYSTEM.IB file while I believe it's the database file. The program is roughly as follows: ibSys: TIBDatabase; // The following will throw exception username and password are not…
user534498
  • 3,926
  • 5
  • 27
  • 52
0
votes
1 answer

Python connection to Firebird gdb file

I want to access a gdb file with python. I'm new to firebird and interbase. I can access my file with this command: (Debian 8.4) isql-fb mydb.gdb How can I connect to same file with Python? I tried fdb and kinterbasdb and always get an error…
Bruno Canongia
  • 514
  • 6
  • 12
0
votes
0 answers

How to find amounts greater than zero before a specified date

Currently I am trying to find the outstanding balance of an account before a certain specified date. below is my query SELECT TRANS.AMTUNRES UNPAID, TRANS.TRANTYPE, TRANS.INCPROVCODE IPROV, ACHOLDERACH.ACBALANCE BALANCE, …
Sam
  • 35
  • 5
0
votes
1 answer

Filtering records based on where customers were invoiced one month and paid in another

So i currently have a list of records that i am trying to filter based on when they were invoiced and when they paid for the appointment I want only records where the customer was invoiced and did not pay until the next month ie they had their…
Sam
  • 35
  • 5
0
votes
2 answers

Display results if null or not. SQL

I have two tables, ingredient and ingredient_language. I need to display (from SQL) all translations of each ingredient, and in case that I did not have any translations for some language, in the rows have to appear like this, for example: Language…
Nega developer
  • 259
  • 3
  • 8
  • 19
1 2 3
…
23 24