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

How to calculate moving average?

I have a field in my database named "Value" and I need to calculate the moving average of this "value". The table has a primary key "index" which is used as the sort order for the table. There appears several approaches to this problem in broad…
user1026448
  • 79
  • 7
0
votes
2 answers

Connect Advantage Database through JNDI in Spring

I am facing few issues while connecting to Advantage Databse through JNDI using spring. I tried to connect Advantage Database with the below code is working.
user2819805
  • 1
  • 1
0
votes
3 answers

In SQL, omit entire record if column (of multiple values) matches condition

I'm pretty new to SQL... I have a table with the following columns : Employee,Title,Age,Children Output of a basic SELECT would be : Steve |Foreman|40|Billy Steve |Foreman|40|Amy Steve |Foreman|40|Michelle Daniel|Smith |35|Eric Daniel|Smith …
user2820853
  • 17
  • 4
0
votes
1 answer

Need help to solve query (using datepart)

SELECT -- Subtract minute, second, millisecond part of date, effectively rounding to floor of the hour -- For example '2017-03-17T14:31:25.567' becomes '2017-03-17T14:00:00.000' DATEADD( mi, -1 * (DATEPART(mi, tab.logindt) % 60), …
user225752
0
votes
1 answer

How can we get a column values as comma separated in Advantage Database server?

Below statements fails for ADS DECLARE @listStr VARCHAR(MAX) SELECT @listStr = COALESCE(@listStr+',' ,'') + Name FROM Product SELECT @listStr Please help
Dileep Paul
  • 167
  • 3
  • 17
0
votes
2 answers

Skipping rows in results is not currently supported

I am using Advantage database server 10 with MVC Entity FW. While trying to skip items of an IQueryable list, getting an error "Skipping rows in results is not currently supported." allItems.Skip(itemIndex).Take(pageSize); Any familiar with this…
Dileep Paul
  • 167
  • 3
  • 17
0
votes
2 answers

Saving blob field from Advantage DB to file

I have problems retrieving a blob field containing images, then saving it to file. The downloaded file does not seem to be in the correct format; if I open it with a hex editor it contains the word @R_BLOB@ What could be wrong? bg: =…
slucarini
  • 41
  • 1
  • 3
0
votes
1 answer

Using Visual Objects RDD and ADS 11 on encryption using supplied AX_SetPassword method

This code does not work: METHOD AX_SetPassword( szEncodeKey AS STRING ) AS VOID PASCAL CLASS ADSDataServer // Set password for record encryption DbInfo( DBI_AXS_SET_PASSWORD, String2Psz( szEncodeKey ) ) RETURN The error message is:…
renejp
  • 1
  • 1
0
votes
3 answers

In an EXISTS can my JOIN ON use a value from the original select

I have an order system. Users with can be attached to different orders as a type of different user. They can download documents associated with an order. Documents are only given to certain types of users on the order. I'm having trouble writing…
Eric G
  • 3,427
  • 5
  • 28
  • 52
0
votes
3 answers

Creating index in a data dictionary with Clipper

I am converting existing Clipper code from free tables to data dictionary. I can read and write to tables but I can't create an index. Here is the code : connSaisie := DacSession():new(GetSsoConnection(1)) connSaisie:SetDefault() DbeInfo(…
kuzkot
  • 81
  • 4
0
votes
1 answer

What would cause SetKey to not change my Table State?

I have a table that I have set up as a pointer to be used by another form. There is a procedure on this form where using a For Loop I create new records in the table if the GUID does not already exist. With Table^ do for I := 0 to…
Trevor
  • 16,080
  • 9
  • 52
  • 83
0
votes
1 answer

Asp.net MVC3, open connection

I open Database connection in my controller and pass the opened connection to my Model for using that connection. but since 2nd time calling to the controller(Ajax), it return an error message that say 'Connection must be open.' I reloaded page, and…
Expert wanna be
  • 10,218
  • 26
  • 105
  • 158
0
votes
1 answer

Returning Records with Distinct or Unique data over multiple fields

What I am trying to accomplish Select up to two records from table Visit that contain one of a number of codes in fields Test1-Test8 Within the last 2 years. But the two records cannot have any duplicate codes. ie Lets say Record1 contains '85.43'…
Trevor
  • 16,080
  • 9
  • 52
  • 83
0
votes
1 answer

Using Foxpro tables and Advantage Data Architect

I mainly want to use advantage to be able to access Fox tables larger than 2 gig. My programs are simple and are run from the command window. I have Adv Data Archetect installed and have the ODBC driver installed. I'm not very knowledgeable with…
KEV KNOX
  • 1
  • 1
0
votes
1 answer

Performance issues Advantage-Database-Server 10.1 - windows 7 client - virtual windows server 2008

I have some performance issues with ADS 10.1 after changing the network. Let me explain: Old configuration of the network: Server - Server2003R2 - Processor: Intel XEON 5130, 2 GHZ - 4 GB RAM - ADS 7.01 Workstation(s) - Intel 2160, 1,8…
user1458497
  • 1
  • 3
1 2 3
…
26 27