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
110
votes
6 answers

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

Database: Sybase Advantage 11 On my quest to normalize data, I am trying to delete the results I get from this SELECT statement: SELECT tableA.entitynum FROM tableA q INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum)…
LuiCami
  • 1,241
  • 2
  • 8
  • 8
38
votes
6 answers

Update multiple values in a single statement

I have a master / detail table and want to update some summary values in the master table against the detail table. I know I can update them like this: update MasterTbl set TotalX = (select sum(X) from DetailTbl where DetailTbl.MasterID =…
Kluge
  • 3,567
  • 3
  • 24
  • 21
14
votes
4 answers

Why is database view used?

Is using "view" in db design right method or we should handle it code side? What are the advantages or disadvantages?
Sessiz Saat
  • 1,079
  • 8
  • 20
8
votes
11 answers

How do you identify the triggers associated with a table in a sybase database?

I am using SQL Advantage and need to know what the SQL is to identify the triggers associated with a table. I don't have the option to use another tool so the good old fashioned SQL solution is the ideal answer.
Bill Rawlinson
  • 600
  • 1
  • 4
  • 22
7
votes
1 answer

DataAdapter does not need to make db connection open?

I try to use DataAdapter in C#.net. and still I do not understand something about DataAdapter. I read many article and blogs about DataAdapter and DataReader. I understood DataAdapter will open and close database automatically when they…
Expert wanna be
  • 10,218
  • 26
  • 105
  • 158
6
votes
4 answers

Fast SQL query but slow result retrieval

I am using the Advantage Database Server from Sybase and have for the moment a nice fast left join query, that runs really fast. The problem is that after running the query I would like to put the results into a string. I retrieved a dataset of…
André Dziurla
  • 187
  • 3
  • 9
6
votes
4 answers

Custom sort order for dataset after executing query?

I want the result set of a database query to have a certain order. The information I want to order by is not contained in the database, but dynamically generated in code (so I cannot use ORDER BY). Is there a way to sort a dataset after executing…
Heinrich Ulbricht
  • 10,064
  • 4
  • 54
  • 85
6
votes
2 answers

SSIS ISNULL to empty string

So I am currently working on a migration from an old Advantage database server to SQL 2005 using SSIS 2008. One of the columns in the old Advantage database is a MEMO type. By default this translates to a DT_TEXT column. Well in the new database I…
Justin Rassier
  • 898
  • 12
  • 26
6
votes
2 answers

Advantage Database Server: slow stored procedure performance

I have a question about a performance of stored procedures in the ADS. I created a simple database with the following structure: CREATE TABLE MainTable ( Id INTEGER PRIMARY KEY, Name VARCHAR(50), Value INTEGER ); CREATE UNIQUE INDEX…
ie.
  • 5,982
  • 1
  • 29
  • 44
5
votes
2 answers

Collation error 5175 in a conection to Advantage ADT files

I am developing an application in VB.NET which must be connected to a table Advantage (ADT) I use the following connection…
Mario
  • 81
  • 7
5
votes
1 answer

Using the ADO.NET Entity Framework with the Advantage Database Server

I'm creating and WPF application using the MVVM in VS 2013; first implementation was with SQL server and it worked like a charm. Second phase is to have support for Advantage Sybase. For this I have downloaded Advantage Data Provier to have the…
dragosT
  • 51
  • 1
  • 3
5
votes
6 answers

Why do I get a "Too many local constants" error?

Delphi 2009 complains with an E2283 error: [DCC Error] outputcode.pas(466): E2283 Too many local constants. Use shorter procedures Delphi 2007 compiles just fine. I can't find an abundance of local constants, it's a short (500 line) unit. Do you see…
Jeremy Mullin
  • 4,170
  • 4
  • 36
  • 54
5
votes
1 answer

Assignment error when assign value to parameter of a parametized query

I'm using Delphi XE2 with AnyDac Components and Advantage Database 10. In my code I'm using parametrized querys like this: q.SQL.Text := 'SELECT * FROM Table1 ' + 'LEFT JOIN Table2 ON (Table1.ID = Table1 .ID_Table2) ' + 'WHERE ' + ':0 BETWEEN…
user1619275
  • 355
  • 1
  • 6
  • 14
5
votes
2 answers

Is there a Python module to access Advantage Database Server?

As the title suggest, I was wondering if there is a Python module that can access an Advantage Database Server (Sybase) files such as ADT and DBF. I have searched the web and couldn't find what I'm looking for this is why I wanted to ask it here.
b3rx
  • 366
  • 1
  • 2
  • 8
5
votes
1 answer

Cannot create datasource, "Column 'TABLE_CAT' does not belong to table Tables

I am trying to add a datasource to my visual studio project, however it always gives me an error: Column 'TABLE_CAT' does not belong to table Tables. I get the same error in both vs2005 and vs2010. From what I have read, this error is caused by…
PRNDL Development Studios
  • 3,270
  • 2
  • 35
  • 50
1
2 3
…
26 27