Stack Overflow
Stack Overflow

Questions tagged [advantage-database-server]

Advantage Database Server is an embedded relational database management system from Sybase.

Advantage Database Server is a full-featured, easily embedded, client-server, relational database management system from Sybase, a subsidiary of SAP.

Some of the strengths of Advantage include:

  • Supports both ISAM (navigational) and SQL data access
  • Supports both the DBF and ADT (proprietary) data formats
  • No Administration
  • Easily Embedded
  • Supports Windows and Linux

Resources:

393 questions
3
votes
1 answer

Query recent records with separate date and time fields

I'm working with a table in SAP Advantage with separate date and time fields. I want to find records with a date and time within the last 5 minutes. This works 99% of the time: SELECT * FROM table_name WHERE TIMESTAMPDIFF(SQL_TSI_DAY,…
TommyGunn32
  • 924
  • 1
  • 8
  • 22
3
votes
4 answers

Select everything to the right of a specific character

Given this data: Home: (708) 296-2112 I want everything to the right of the : character. This is what I have so far, but I'm getting no results: right(phone1, locate(':', phone1 + ':')-1) phone If I use left instead of right, I get just "HOME" -…
Brian K
  • 87
  • 7
3
votes
3 answers

Is it possible to create indices with expression engine expressions using SQL?

We are trying to create an index on CDX and ADT tables that use the Advantage expression engine. The code we tried so far looks like this: CREATE INDEX IDX1 ON TBL1 (STR(SOME_NUMBER_FIELD,6)+DTOS(SOME_DATE_FIELD)); Is it possible to create an index…
Jens Mühlenhoff
  • 14,565
  • 6
  • 56
  • 113
3
votes
2 answers

Reset identity (auto increment field) in advantage db table

Please show me the way to reset auto increment field in a table of the Advantage Database Server 11.0. In SQL Server, it works like this: DBCC CHECKIDENT ('tableName', RESEED, 0); GO UPDATE: What I want is to write consecutive values (1,2,3,4....)…
mad
  • 1,029
  • 3
  • 17
  • 38
3
votes
1 answer

How can I insert special characters into Advantage SQL database?

I'm trying to insert characters like µ as varchar but it doesn't work, I get error message which says cannot convert Unicode characters to Codepage characters because it's medical document, I'm not allowed to change any data. The program is…
Sparkm4n
  • 644
  • 1
  • 9
  • 29
3
votes
2 answers

How get Advantage Database Server installed license count in Delphi Code

I would like to be able to get the number of installed user licenses for an Advantage Database Server instance in code using Delphi. I have found a function that lets me get the installed version, ie. …
Bill Seven
  • 768
  • 9
  • 27
3
votes
4 answers

Trapping errors in TClientDataSet.CommandText

I have a TClientDataSet connected to a TDataSetProvider, which in turn is connected to a TAdsQuery. I set the SQL command and then open the ClientDataset something like this: try CDS.CommandText := 'SELECT * FROM tablename WHERE fieldname = 1'; …
Rob McDonell
  • 1,309
  • 9
  • 15
3
votes
1 answer

Why do I get "Error 6060" when I try to use DBD::Advantage with a 64-bit perl on Linux?

I realize that I am attempting to go beyond the "supported" behavior of the manf's released drivers for Perl, after all they have only released it in package with x86 .so's. However, since I cannot use their package with x64 Perl on a RHEL 5.4…
WarheadsSE
  • 63
  • 5
3
votes
1 answer

Advantage Database, case sensitivity, and collations

I have something similar to this in my Advantage database:- drop table #test; create table #test (x cichar(50)); insert into #test (x) values ('cheese'); insert into #test (x) values ('fromage'); insert into #test (x) values ('Queso'); select …
Pseudo Nym
  • 41
  • 4
3
votes
2 answers

Advantage Database Server ORDER BY behaviour

I'm using ADS v10 beta. I'm trying to numerate ordered resultset. 1) ORDER BY in nested queries. I need to use nested SELECT for some calculations: SELECT Name, Value, ROWNUM() FROM (SELECT * FROM MainTable WHERE Value > 0 ORDER BY Value) a And I'm…
ie.
  • 5,982
  • 1
  • 29
  • 44
3
votes
3 answers

Check the existence of the table when sql script runnnig first time (Advantage data architect)

Good day. I have the following question: Is it possible to check the existence of the table when sql script running first time? I'm using Advantage Data Architect 11.10. I want to clarify my question. In my script I need to create a temporary table…
netwer
  • 737
  • 11
  • 33
3
votes
1 answer

how to use variable table name in select query (Advantage Data Architect)

I'm writing the same small sql script and I'm using Advantage Data Architect 11.10. One part of my script is create 'cursor' based on the following request: ... declare myCursor; declare prefix char(4); declare tableName char(10); ... tableName =…
netwer
  • 737
  • 11
  • 33
3
votes
4 answers

how to load a file into a blob without loading into RAM first?

I am using C# and I am having trouble loading large files into a binary field use byte arrays. Basically, if I load a file that is too large, I get memory problems. Is there a way to load a file into a binary field without using large amounts of…
Ace Grace
  • 631
  • 1
  • 7
  • 21
3
votes
1 answer

Concurrent update to DBF files with Advantage Local Sever and FoxPro

Is it safe to update DBF files using Advantage Local Server .Net provider whilst a FoxPro application is running that may also be accessing the DBF files? i.e. does Advantage take care of row locking?
ChrisR
  • 1,308
  • 1
  • 14
  • 27
3
votes
5 answers

Advantage Database or SQL Server

I have a client that currently uses a local Advantage Database on their PC along with an application. They are thinking of upscaling their setup to have multiple applications running communicating with a database server i.e/a client-server…
Jon
  • 38,814
  • 81
  • 233
  • 382
1 2
3
…
26 27