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
0
votes
1 answer

Alter table using Nexusdb embedded database in Delphi

I am creating a small tool to update database table. So i want to add columns to table using embedded database (using alias path- without running Nxserver) database. I did it successfully but table can't be opened from Enterprise manager. It says…
Ishanka
  • 360
  • 4
  • 18
0
votes
1 answer

What flavor of Object Pascal is used in the Nexus DB report Designer?

I use a software called RentalDesk NX that is built on top of Nexus DB. According to the help manual for Report Designer, I need to code in Object Pascal, but none of the functions I can find referenced online (such as RightStr, StrToDate, or…
NickSentowski
  • 820
  • 13
  • 27
0
votes
1 answer

How to access to NexusDB from Java

I want to access to NexusDB V3 with Java. So I have a Java project with many files that connects to the database. Can anyone tell me if it is possible to use a Java class file for connecting to the database. I've tried JDBC connector and the ODBC…
khennouche faycal
  • 51
  • 3
0
votes
1 answer

remove SQL duplicate values, distinct not working

SELECT BM.PUser, BM.Desc, BM.Price, BM.Info, CAST (CASE WHEN BI.Closed = 'E' then BQ.Qty-BQ.Consign-(SUM(BD.QtySold)) ELSE BQ.Qty-BQ.Consign END as int) as Stock FROM BINVOICE BI , BDETAIL BD , BQTY BQ , BMASTER…
paralyzed21
  • 1
0
votes
1 answer

Sum multiple rows of SQL

Here's my code: SELECT Invoice_detail.Xtype, Invoice_detail.Totallineprice FROM Invoice_detail Invoice_detail INNER JOIN Invoice_head Invoice_head ON (Invoice_head.idx = Invoice_detail.Xinvoicehead) WHERE (…
NickSentowski
  • 820
  • 13
  • 27
0
votes
1 answer

NexusDB Field with spaces ADO SQL

I can't figure out which syntax to use for fields in my NexusDB that have spaces in them. I've tried the usual things like: [ ] `` but none of these work, the query just errors. So an example query might be: select `offical name` from…
kstubs
  • 808
  • 4
  • 18
0
votes
1 answer

C# Serializer class Encoding Issue

I'm really not understanding where these characters are coming from. I am populating a custom class object and then serializing it to disk and getting strange characters in the result like…
kstubs
  • 808
  • 4
  • 18
0
votes
2 answers

How do I output the value of a parameter in SQL after it has been inserted?

Is it possible to retrieve the SQL statement with the values of parameters after it has been set and inserted into the SQL component? SQL Statement: SELECT * FROM SomeTable WHERE SomeColumn = :pSomeValue; Code: procedure LoadParams(aValue:…
Michiel T
  • 537
  • 9
  • 23
0
votes
1 answer

FullTextIndex in NexusDB, How to tokenize the searchstring

We are using NexusDB for a small database. We have a table with a FulltextIndex defined on it. The index is configured with the following options: Character separator ccPunctuationDash ccPunctuationOther The user enters a search text in an edit…
Bascy
  • 2,017
  • 1
  • 21
  • 46
-1
votes
3 answers

How to add 10000 to existing column?

I have a table called stock and one of the column is called stock_code. The stock_code is all 5 digit int (I believe), but now I'm running out of numbers, I need to change all the code to 10 digit. So I need to add 10000 to all the stock_code. Can…
Howard Kuo
  • 1
  • 1
1 2
3