Stack Overflow
Stack Overflow

Questions tagged [ibexpert]

40 questions
0
votes
2 answers

How can I search a specified character in the entire SQL database with IBexpert?

How can I search some particular character on the entire database with IBexpert? For example: I have some "'" (') in some part in the data of the tables and this is getting me an error later on, and I have many tables to search manually... How can I…
Bruno 'Shady'
  • 4,348
  • 13
  • 55
  • 73
0
votes
2 answers

How to dock, setup Query Manager

Anyone know how can I dock the Manage Query panel to right? My firebird version is 2.5, IBExpert version is 2015.12.11 After I click on the button the Queries window (on my first picture) will be popup. I also checked options in the IBEXPERT.tb file…
Steve88
  • 2,366
  • 3
  • 24
  • 43
0
votes
0 answers

Firebird 2.5: invalid request BLR 623; LTRIM not defined; entrypoint not found

I am completely new to Firebird Database; I am working on a Firebird 2.5 database that already exists; I retrieve the stored procedures and views (database objects) from this database to develop reports in Microsoft SSRS. I use Windows 7 Operating…
user3812887
  • 439
  • 12
  • 33
0
votes
1 answer

IB Expert Access - IBExpert.stg storage

I have a Firebird 2.5 Database in IB Expert; whenever I open IBExpert I get this following error: IBExpert currently uses IBExpert.stg (C:Users\xyz\AppData\Roaming\HK-Software\IBExpert\IBExpert.stg) as a main storage for its data. This way is…
user3812887
  • 439
  • 12
  • 33
0
votes
1 answer

Firebird in IBExpert throws errors while accessing some stored procedure

I am completely new to Firebird; I have been given a Firebird 2.5 database (by our client) - XYZ.fdb I have registered this XYZ.fdb database in IB Expert. I am able to run successfully some views and stored procedures. However for some other…
user3812887
  • 439
  • 12
  • 33
0
votes
1 answer

Concurrent transaction in IBExpert and Firebird 2.5.2

I am trying to run following query on IBExpert delete from mytable where EMPID = 55 and ROLEID = 445 I am getting error: update conflicts with concurrent updates. Concurrent transaction number is 292071. How do I come to know which query is…
user1556433
0
votes
0 answers

ibec_ExtractMetadata don't extract tables like "TaSomeData". IBExpert. IBEScript Firebird 2.1

I have a problem with the command ibec_ExtractMetadata from IBEScript(ibeblock). In my Database most tables have names in InfixCaps like "TaActions", "TaDiscountSystem" etc. If I use ibec_ExtractMetadata with tables in UpperCase - all is…
Ingword
  • 1
  • 1
0
votes
1 answer

Error running script

I have a Firebird SQL script as follows :- ALTER TABLE COSTCENT DROP ROW_VER; ALTER TABLE COSTNUMB DROP ROW_VER; When I run it in ibexpert, I get the following error :- Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown - line…
Ace Grace
  • 631
  • 1
  • 7
  • 21
-1
votes
1 answer

Firebird DDL for user and privileges

I have Firebird 2.5 and I need to extract all user and privileges as DDL to export to another Firebird database. For example, I need get the script for user max "Create user max FIRSTNAME 'Max' LASTNAME 'Power' Grant admin option"; I use IB…
Pedro Luque
  • 164
  • 2
  • 13
-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
1 2
3