Stack Overflow
Stack Overflow

Questions tagged [elevatedb]

ElevateDB is a commercial, lightweight database engine offered by Elevate Software.

ElevateDB is a commercial, lightweight database engine from the company that created DBISAM.

Marketing and sales materials are available on the Elevate Software website: http://www.elevatesoft.com/products?category=edb

8 questions
8
votes
3 answers

How to Format a DBGrid Column to Display Two Decimal Places?

I would like to format specific cells to force two decimal places. The data is coming from an ElevateDB stored procedure and hooked into a TDataSource. EDIT: SQL Programming Note: I wasn't sure if this was just an ElevateDB issue or not. Before…
Michael Riley - AKA Gunny
  • 5,074
  • 4
  • 42
  • 89
2
votes
2 answers

How to Return the ID Value When Inserting a Record Using ElevateDB

With SQL server you can simply return @@Identity to get the ID value of the last insert. Is there a way to do this using elevatedb?
Michael Riley - AKA Gunny
  • 5,074
  • 4
  • 42
  • 89
0
votes
1 answer

Why can't I connect to ElevateDB database using DB Manager (so I can export tables)?

I am trying to save user data that has been entered and saved in a proprietary program. The program hasn't been updated for about eight years, the company behind it does no longer exist and no support is available. I have the old program installed…
AppleMoose
  • 123
  • 1
  • 1
  • 9
0
votes
0 answers

How to put query or join result into one field with pure sql

For every table record I must find/check that record in second table and based on substring condition put results back in one field separated with delimiter if more then one. table2->someRef always start with two char + something else like two…
TK Zan
  • 35
  • 3
0
votes
1 answer

All values from first table, even if nothing matchs on other tables

I have three tables (shown below with the relevant columns) Table SALESSaleCodes "SaleCode" VARCHAR(2) COLLATE "ANSI" DEFAULT '', "Description" VARCHAR(25) COLLATE "ANSI" DEFAULT '' Table INVOIHeader "DocNum" INTEGER DEFAULT 0, "AcctDate"…
Phil
  • 444
  • 3
  • 11
0
votes
1 answer

Order a select by Name and id (ELEVATEDB)

I Have a table named families, where i have nested families of products. All the entries of the table that have a length lower than 5, are parent families, and the families with a length of 5, are families with associated products. For example: ID …
kristonpelz
  • 53
  • 8
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
-1
votes
1 answer

How to Import Data from .DBF file to Some Other Database like ElevateDB?

I have large file say named as "customers" and it is in .DBF format. Now I want to import that .DBF file data to ElevateDB database. ,,,Is ther any ways to import data by Query or write program for import from .DBF to ElevateDB...
Vish Soni
  • 43
  • 1
  • 7