Stack Overflow
Stack Overflow

Questions tagged [dbisam]

DBISAM is an embeddable relational database mainly geared to Delphi and C++Builder application developers.

DBISAM is an embeddable relational database mainly geared to Delphi and C++Builder application developers.

Documentation and product page.

21 questions
2
votes
1 answer

SQL 13 months transaction and quantity data extract broken down per month

I was reading through a couple of older posts and tried to apply the same logic to my question, I need to extract 13 months of data broken down per month, I would also like to apply the data to relevant headers... any suggestions. Please see code…
Griphon
  • 25
  • 3
2
votes
3 answers

Is EXISTS clause supported by DBISAM's sql engine?

Strangely, it seems that the EXISTS clause is not supported by DBISAM's sql engine, as it's always resulting in an SQL error. The following is a sample where EXISTS is being used. Am i missing anything here? update Table1 set HASXACTION =…
Johny
  • 419
  • 4
  • 15
2
votes
5 answers

SQL Subtract Min And Max

I'm simply trying to use min() and max() functions in an expression like so: SELECT WSN, MIN(TOP) - MAX(BASE) FROM PERFS GROUP BY WSN But this doesn't appear to be valid SQL. I keep getting told I can't use aggregate functions in an expression.…
John
  • 485
  • 3
  • 5
  • 16
1
vote
1 answer

Shift one position behind in a raw conversion from a hex buffer

I've been trying to extract a table from a blob column in a database that was converted into a hex string in the process. I'm using R for all my job. A capture of the BLOB data column is highlighted below: DATA column is a hex string coming from a…
Ricardo Soto
  • 13
  • 4
1
vote
1 answer

IF ELSE with DBISAM SQL

I am running the following query using DBISAM SELECT((SUM(sales.sale_amount) +SUM(sales.vat_amount)) -SUM(payments.fee_amount)) AS Balance,account_details.id FROM account_details JOIN sales ON account_details.id = sales.account_id JOIN payments…
gld22
  • 11
  • 2
1
vote
1 answer

Update function on a RecordSet object in VBscript causing DBISAM parse error

I'm having difficulty using the Update function on a RecordSet object while using the DBISAM 4 ODBC driver. Here is what my code looks like. dtmNewDate = DateSerial(1997, 2, 3) MsgBox(dtmNewDate) 'Create connection object & connection string Set…
Pete S
0
votes
0 answers

Encoding errors when reading .dat file (DBISAM table) into Pandas data frame

Thanks in advance for any assistance y'all can offer. I'm attempting to create a Pandas data frame from a .dat file (DBISAM table) generated by the Retail Edge POS software. My question was similar enough to this and when using their code, I was…
sccx
  • 35
  • 5
0
votes
1 answer

Finding the first empty column in a data row

I saw similar questions and most turned into arguments about table design, normalization, etc. Not all of us have the luxury of making our clients change their database designs. Here is my dilemma. My client asks that I make it possible for their…
Meta Mussel
  • 548
  • 1
  • 5
  • 19
0
votes
1 answer

IQ Retail API not returning Invoice data

I am trying to do an invoice request on IQIntAPI and I am getting the below error message 5 Unable to open Data…
Kidd Mahobele
  • 53
  • 6
0
votes
1 answer

How to export dbisam image records to SQL Server

I have a dbisam database that I am trying to export the images that are contained in one of the tables. There is a single record export available when you double click on the (memo) type when you display the table and that works fine. But I have not…
Chris
  • 11
  • 3
0
votes
1 answer

Exporting MEMO Fields From DBISAM

I have several DBISAM Database tables, I can read them and edit them. But when I export the Data to an excel spreadsheet it doesn't export the MEMO fields located in the table. Does anyone know of a way to export the MEMO fields so i do not have to…
Nick M.
  • 3
  • 3
0
votes
0 answers

SQL Management Studio: "DBISAM Engine Error # 12035 The table 'step_log' is not the correct version'"

I´m using SQL Management Studio for PostgreSQL to migrate another DB to PostgreSQL. On starting up and closing down the studio i get the error message from above. It does not affect any of the steps after yet (the actual work i do with the program)…
coffee_bear
  • 31
  • 1
  • 8
0
votes
0 answers

Multiply a field with a counted field

I'm using DBISAM to have a table from existing datas. My problem is : NAME | COUNT(QTY) | PRICE | ? | _______|________________|____________|_________| A | 1 | 9.5 | 9.5 …
BlackAlpha
  • 376
  • 1
  • 5
  • 15
0
votes
1 answer

How do I use the DBISAM database in VB.net?

I am trying to connect to a DBISAM database. This database system is used mostly on Delphi. The table files are stored in a folder. My question is: Is there a way to connect to these databases from vb.net? How should I go about doing that?
user4570133
0
votes
1 answer

Sql grabbing most recent record

I'm currently using DBISAM sql compiler. It's very very identical to ms sql compiler, the only difference is that I can't have any nested join statements. The query below is a nested query that grabs the most recent loan record and the rate. I'm…
Master
  • 2,038
  • 2
  • 27
  • 77
1
2