Stack Overflow
Stack Overflow

Questions tagged [nexusdb]

NexusDB is an SQL database engine, embedded(free) and stand-alone(commercial).

http://www.nexusdb.com/support/index.php?q=node/509

http://en.wikipedia.org/wiki/NexusDB

The database is continuation of FlashFiler lineup from the now defunct TurboPower company.

NexsuDB is a Delphi based database engine conforming to SQL standards. The Nexus DB engine can be configured to run either as a stand alone server or as an embedded database similar to Berkley DB. It available in both 32-bit and 64-bit architectures and only runs on the Windows platform.

Its supports connection(s) with the following technologies.

  1. ODBC
  2. ADO
  3. .Net
40 questions
6
votes
3 answers

Fastest way to locate record in TQuery resultset

I am wondering what the best (read: fastest) way is to locate a record in a resultset of a Tquery SQL statement. Until now i'm using TQuery.Locate and if i'm right that is the only statement that can be used to search in the resultset. So how can…
Bascy
  • 2,017
  • 1
  • 21
  • 46
5
votes
1 answer

Fast read of a Nexus database table

I want to read the entire contents of a table into memory, as quickly as possible. I am using Nexus database, but there might be some techniques I could use that are applicable to all database types in Delphi. The table I am looking at has 60,000…
awmross
  • 3,789
  • 3
  • 38
  • 51
4
votes
0 answers

Connecting to Nexus DB using ODBCConnection in dotnetcore

I am trying to connect to NexusDB using ODBCConnection in System.Data.Odbc namespace. I am able to run the same piece of code on my machine using .NetFramework 4.6.1 console app which is working. I have NexusDB V3.09 Driver installed on my…
Mahesh
  • 823
  • 1
  • 11
  • 29
4
votes
4 answers

Firebird or NexusDB

I know that there are many Delphi database related questions available, but I'm considering only these two databases. I will need to query around 100.000 records. From your experience which one is faster: as embedded as C/S Thanks.
Mihaela
  • 2,482
  • 3
  • 21
  • 27
3
votes
1 answer

NexusDB: : Query execution failed: Type mismatch (nxtInterval <> nxtNullString) when comparing at line

Getting the error below, when I was trying to pull the records from Nexus Database. Error: NexusDB: : Query execution failed: Type mismatch (nxtInterval <> nxtNullString) when comparing at [$3CA0/15520] Query: SELECT * from FROM…
Pancheti
  • 217
  • 1
  • 7
2
votes
2 answers

Unable to insert date-time as null values to Nexus Database from c# dapper code

Getting below issue while inserting the DateTime value as null into Nexus Db using a dapper class to nexus Database. public const string SqlQuery = @"INSERT INTO Test(test1, test2, test3, Date1,Date2)) …
Pancheti
  • 217
  • 1
  • 7
2
votes
1 answer

TDataSource TDBMemo not in Insert or Browse mode

I have a DBLookupComboBox that lists values from 1 table that I'm selecting a value from. When the value is selected, I want the 2 DBMemo Boxes I have to be able to input/edit into to insert/update into another table. But They don't allow me to…
DavieDave
  • 1,394
  • 2
  • 18
  • 35
2
votes
1 answer

Is it possible to add BLOB Wide Memo field to a nexusdb table using a query?

I am developing a database comparing tool using delphi and nexusdb. I tried to add a BLOB Wide Memo field to a table using query. but i could not find the correct data type. i tried follow queries. ALTER TABLE Test ADD COLUMN TestField…
Ishanka
  • 360
  • 4
  • 18
2
votes
4 answers

SQL question: excluding records

I have a database (NexusDB (supposedly SQL-92 compliant)) which contains and Item table, a Category table, and a many-to-many ItemCategory table, which is just a pair of keys. As you might expect, Items are assigned to multiple categories. I am…
Jamo
  • 3,238
  • 6
  • 40
  • 66
1
vote
1 answer

Does Django pyodbc support Nexus DB or is it Database dependent?

I have a project where i need to connect Nexus DB in a Django application. I have tried with Django-pyodbc, DATABASES = { 'default': { 'ENGINE': "django_pyodbc", 'HOST': "nexusdb@xxx.xxx.x.xx", 'USER': "", 'PASSWORD': "", 'NAME':…
Arun Augustine
  • 1,690
  • 1
  • 13
  • 20
1
vote
1 answer

How can I open .DB7 data files?

I've got a bunch of files with DB7 extension, coming from a customer's software. Each one of them is related to a database table. What I want is to export data in a more practical format, such as CSV. Reading the header of the file, something…
Fabio B.
  • 9,138
  • 25
  • 105
  • 177
1
vote
1 answer

Creating a table in NexusDB with german umlauts?

I'm trying to import a CREATE TABLE statement in NexusDB. The table name contains some german umlauts and so do some field names but I receive an error that there were some invalid characters in my statement (obviously the umlauts...). My question…
MCelik
  • 13
  • 2
1
vote
1 answer

Insert data from a dataset in delphi

I want to insert data to a nexusdb table which are in a access database table. i am using two query for this. one for select data from access database and other one for insert to nexusdb. I don't want insert this using a loop. Is there any way to…
Ishanka
  • 360
  • 4
  • 18
1
vote
1 answer

NexusDB execution failed

NexusDB : Query execution failed: Operating system error in Temporary Storage Manager: Espace insuffisant sur le disque($70/112) [$2B27/11047] I don't understand this message. What's the real problem? Query code: SELECT d.Code, c.RaisonSociale,…
TDX
  • 33
  • 4
1
vote
1 answer

Group by date, day interval in SQL query

Say I have a table similar to the following (simplified): | Name | Date | Hours | | Bob | 10/1/13 | 5 | | John | 10/1/13 | 8 | | Bob | 10/2/13 | 6 | | Ashley| 10/2/13 | 4 | ... | Bob | 10/17/13 | 4 | | John |…
computmaxer
  • 1,677
  • 17
  • 28
1
2 3