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
1
vote
1 answer

Nexus DB Assertion failure

NexusDB: Query1058317796: Query execution failed: Unexpected exception object raised: [EAssertionFailed] Assertion failure (C:\DSN\WIN\lib2006\Fontes\Externos\NexusDB2\nxsrBufferManager.pas, line 1115) [$3CA1/15521] i tried this sql SELECT * FROM…
1
vote
4 answers

Accessing NexusDB from Java

I am trying to get info from an embedded db called NexusDB using java. Alternative 1: I've read in NexusDB website that there is an ODBC driver so I might use it with unixODBC. Then I need to do a JDBC-ODBC Bridge as stated here. Alternative 2: Get…
Macarse
  • 91,829
  • 44
  • 175
  • 230
0
votes
2 answers

Delphi/Query component - assign a long string (800 char) to a sql.text property trim the sql to 326 char only

I use Delphi/NexusDB and I build SQL (about 800 char long) at run time then I pass it to the nexusdb query.sql.text property to execute it but I found error of invalid token on execution. I pass SQL like this Query.SQL.Text := VarStrSQL; // <<----…
zac
  • 4,495
  • 15
  • 62
  • 127
0
votes
1 answer

NexusDB for each loop / substitute

I need a little push up. I have a temporary table created from a select. Now I need to go through that table and for each record in that table I need to do insert to other table with some values from this temporary tables. Anyway I can't figure out…
Hero981
  • 3
  • 3
0
votes
0 answers

Synchronization of the SQLite database with nexusDB

I want to create a mobile application, which has SQLite as databases (on mobile app) and nexusDB is the central database, which contains all the company data. I would like to synchronize SQLite (I use DB Browser for SQLite) with nexusdb and I don't…
0
votes
1 answer

Connect to NexusDB using Go or PHP

Im trying to access an applications nexusDB records/tables I cant find much information on this online, is it possible with Golang or PHP7 and if so is there any documentation on doing so.
Kravitz
  • 2,769
  • 6
  • 26
  • 53
0
votes
1 answer

Using SQL is it possible to search via string without regards to the order of the characters?

I would like to be able to search using a sql query without regarding the order of the characters within a string: the search for 'black box' should return 'box black 32oz 2 pack', 'box black 32oz 4 pack' currently it does not return any of it. I…
0
votes
0 answers

Query execution failed: \r\nTable already exists. (Tablename: django_migrations)

I have a project where i need to use django with Nexus DB. I have customized django-pyodbc package to nexusDB compactable as third party Database engine. But While making the initial migration found this error. Traceback (most recent call…
Arun Augustine
  • 1,690
  • 1
  • 13
  • 20
0
votes
1 answer

How to connect NexusDB in windows via python?

Does anyone have any idea about connecting to NexusDB via python? Thanks.
Arun Augustine
  • 1,690
  • 1
  • 13
  • 20
0
votes
1 answer

How to conect Delphi 10 with NexusDB old version

I want to get data from nexusdb 2 to delphi 10. How can i connect delphi 10 to nexus server 2. I can not change nexus server version because another project (Which is developed in Delphi 6) using same database with nexus server 2.
Danush
  • 36
  • 4
0
votes
3 answers

Retrieving metadata of the result of a TQuery

In our application a user can enter SQL code to retrieve data from a NexusDB database. We want to determine the metadata of the result of such a query without actually executing the query. We use the metadata to i.e. determine the number of fields…
Bascy
  • 2,017
  • 1
  • 21
  • 46
0
votes
1 answer

Is it possible to strip Debug Information from DCUs?

I am using free embedded NexusDB from GetIt which comes without sources, only .DCUs However, these DCUs has debug info in them, which hamper debugging a lot, i.e. when I try to Step Into (F7) my code, IDE often prompts me about source file location…
0
votes
1 answer

export BLOB from nexus enterprise manager

I'm trying to convert a bunch of blob files back into PDFs. Currently they look like this: I haven't really found much on the internet, and the few guides or post i've found, haven't yielded any results. Has anyone ever tried doing this?
mol
  • 73
  • 10
0
votes
1 answer

NexusDB declare and set table result in a variable and select it

In NexusDB I'm trying to create add a query result in a variable, then update the selected items and later select the variable START TRANSACTION; set result = (SELECT * FROM "some_table" where synced = false); UPDATE some_table set synced =…
Eelco
  • 339
  • 1
  • 3
  • 13
0
votes
1 answer

DBLookupComboBox and Refreshing of Contents

I have Delphi 7 and I'm using NexusDB for the database. I have a main form where I have a DBLookupComboBox to list the contents of a Table. If I press a button I have on the form to add a new item to the list (which opens a 2nd dialog box) and then…
DavieDave
  • 1,394
  • 2
  • 18
  • 35