Questions tagged as 'firebird'

Tagged questions
1
answer

SQL query using order by filtering through the records [closed]

I have the table: | cod | hora | produto | Amostra | Min | Max | |-----|-------|---------|---------|-----|-----| | 1 | 08:00 | 96722 | 1 | 100 | 200 | | 2 | 08:23 | 96721 | 1 | 90 | 90 | | 3 | 08:50 | 96722 | 2...
asked by 06.09.2016 / 16:08
1
answer

Problem with using Jaybird

I can not connect to my database using firebird jdbc. the bank is very old and I can not discard it yet, I need to at least download the list of clients and save in sqlite. The problem happens well at first, when I use: Class.forName("org.f...
asked by 02.06.2016 / 23:32
1
answer

How to list each Collation name with your charset - Firebird 2.5

I want to make a query involving RDB $ Character_Sets , RDB $ Collations and RDB $ Fields to get a list of "Fields" with their RDB $ Character_Set_Name and RDB $ Collation_Name . SQL statement used: select distinct Fields...
asked by 02.06.2016 / 14:19
0
answers

Configuration Persisisntece.xml with datasource Glassfish

Next staff I made 2 datasources of glassfish !!!! Where the first is a fixed database !!! Here is the image: Thisdatasourceisworkingcorrectly!!!MysecondIdonotpasstheDatabasepropertybecausethispropertycomesfrommyfirstdatasource,ie,Igetthepath...
asked by 28.04.2016 / 22:50
1
answer

Firebird - select master-detail

Hello. I need to query the system tables, so I get the following result: Relation_Name, Field_Id, Field_Name, Field_source, Field_type for each user-defined table (Relation_Name) (except Views). That is, for each table, the fields (Field_N...
asked by 07.06.2016 / 03:28
1
answer

Access violation in module 'DBXCommondriver220.dpl'

I'm having trouble using Firebird on Embarcadero C ++ XE8. Error: Access violation in module 'DBXCommondriver220.dpl'     
asked by 06.05.2016 / 04:23
0
answers

Unidac uniQuery component does not return keygenerator value

I'm having trouble inserting into Firebird using Devart's uniQuery component (Delphi 7 with Unidac). The field that is the primary key is in the fieds of the query and the configuration of the component is like this: CAMPO_ID : ProviderFlags...
asked by 25.11.2015 / 19:36
0
answers

Insert blob firebird php

I have a problem when trying to insert a blob field in firebird my code is seguitne $ficheiro = $this->blob_create(file_get_contents($_FILES['ficheiro']['tmp_name'])); $extensao = pathinfo($_FILES['ficheiro']['name'], PATHINFO_EXTEN...
asked by 03.08.2015 / 12:39
2
answers

Generate Sequence Records with ClientDataSet (MultiUser)

I have the following scenario: Orders table with Company, OrderNumber which are primary key. Other fields such as Customer, Value, ect ... I have a SQLQuery, a DataSetProvider and a ClientDataSet connected pointing to this table. In the On...
asked by 12.11.2014 / 19:43
1
answer

How to use C # Windows Forms with Firebird and Object Orientation? [closed]

I recently learned a little object orientation and c # . But I am trying to create an application that is developed in C # windows forms , with firebird and object-oriented database. But what is the right way to do it? How do I connect my ba...
asked by 12.08.2015 / 21:59