Sybase Adaptive Server Anywhere, is an RDBMS by SAP, that runs as an embedded database. Since version 10, ASA is developed under the name [SQLAnywhere]
Questions tagged [sybase-asa]
162 questions
1
vote
1 answer
Privatize connection to SQL Anywhere 16 Database
After connecting to the database with one computer, I am looking to disallow any other network connections. My first attempt was to modify the network database server properties (see image below) to remove the -x tcpip parameter which, according to…
Zach Williams
- 13
- 2
1
vote
0 answers
php pdo fetchAll is empty but rowCount show
this is my code:
$pdo = new PDO($dsn, $user, $pass);
$q = "SELECT C1,C2,C3 FROM table";
$stmt = $pdo->query($q);
$nums = $stmt->rowCount();
echo "Count: ".$nums."
"; $erg = $stmt->fetchAll(); print_r($erg) And the result is: Count:…
"; $erg = $stmt->fetchAll(); print_r($erg) And the result is: Count:…
Fabian Knauf
- 117
- 8
1
vote
2 answers
How to collect column headers and data using dbisqlc.exe command
I am trying to query a Sybase ASA database using the dbisqlc.exe command-line on a Windows system and would like to collect the column headers along with the associated table data.
Example:
dbisqlc.exe -nogui -c…
Brad Krusemark
- 503
- 1
- 4
- 10
1
vote
1 answer
sybase sql anywhere 11 query results are incorrect
I have the following table which has >13.000 rows.
CREATE TABLE "DBA"."mytable" (
"c1" numeric(8,0) NOT NULL,
"c2" numeric(2,0) NOT NULL,
"c3" numeric(4,0) NOT NULL,
"c4" …
Guner Sen
- 11
- 2
1
vote
1 answer
Copy database field value from one table to another
I use Sybase ASA7, I have 2 tables in a database.
Both tables contain 2 fields - ID and EventDateTime with 20 records.
ID field = 1 to 20 in both tables.
Table 1 has the EventDateTime field filled in against each ID, table 2 does not, they are just…
6String_Coder
- 517
- 10
- 30
1
vote
1 answer
sqlanydb query on damaged SQL Anywhere table disconnects connection, produces OperationalError (Communication Error -85)
I was using python and sqlanydb to query a Sybase Anywhere database file. Most queries were working, but any SELECT query involving a particular table:
conn = sqlanydb.connect(**{"uid":"dba", "pwd":"sql", "dbf":"file.db"})
cursor =…
Richard C Yeh
- 61
- 5
1
vote
1 answer
How to use Sybase LOAD TABLE correctly?
I have been using ISQL (SQLAnywhere 12) to import data from CSVs into existing tables using INPUT INTO and never ran into a problem. Today I needed to import data into a table containing an auto-increment column, however, and thought I just needed…
sqlandrew
- 13
- 1
- 4
1
vote
1 answer
ASA8 - Do not have permission to grant permissions
I'm having a problem on my customer pc (and not on my own) when I run this embedded sql script in a Powerbuilder application on a ASA8 database. I use embedded scripts to modify database tables and add users:
ALTER TABLE LOADCON ADD LOADSALES_RATE…
Alex Szlanina
- 49
- 7
1
vote
2 answers
SUM() OVER PARTITION BY - Invalid use of Aggregate Function
I have a query which in the following example works fine
Select t2.leadno
, t1.quoteno
, t1.cn_ref
, sum(t1.qty/100)
, ROW_NUMBER() Over (Partition By t2.leadno order by sum(qty/100) desc) as RN
From dba.quotelne as t1
LEFT…
Jonathan Griffin
- 148
- 2
- 17
1
vote
2 answers
Search database table by record fields and display record on cxgrid
What is the best way to allow a user to search for a record in a database table by typing text into a tedit box clicking a button then the results will then display onto a tcxgrid.
I have a tadquery/datasource that is looking at a table which…
Sharpie
- 373
- 2
- 15
- 34
1
vote
1 answer
Button is disabled if DBLookUpComboBox hasnt got anything selected in it.
Using Delphi XE2.
Writing a software package to do with a customer database. I have a form which displays all customer info on it and one of these fields is a lookupcombobox with a button next to it. (The lookupcombobox drops down a list with more…
Sharpie
- 373
- 2
- 15
- 34
1
vote
3 answers
Refresh Query / cxGrid
Using Delphi XE2.
I am writing a software package which uses cxGrids and are linked to Querys/Datasources.
At a click of a button how do you refresh a Query to make sure the records are up to date in the cxGrids.
Also if a record is highlighted on…
Sharpie
- 373
- 2
- 15
- 34
1
vote
1 answer
Sybase ASA 9 Trigger after insert get new row
By using trigger I want to copy new added record to another table. I use the follow trigger but it is not bringing values from new added row.
ALTER TRIGGER "SalesTRG" after insert on
DBA.SalesTransaction_Archive
REFERENCING NEW AS…
user4369225
- 11
- 2
1
vote
1 answer
Inserting a record in sybase db table using stored procedure - delphi programming
I am new at programming with delphi. I am currently creating a simple notebook program and i need some help. I have a form called contacts with 5 tEdit fields. I am thinking i could create a stored procedure in my sybase database to insert record…
TechnoA
- 75
- 1
- 10
1
vote
1 answer
Issue connecting with SQLAnywhere via Python: sqlanydb.OperationalError: Parse error: Cannot find .ini file
I'm afraid this might is just an configuration issue but maybe also some issue with coding. However, I'm trying to connect with a database using Python and sqlanydb. SQLAnywhere is installed within /opt/sybase and Shell is sourcing the sa_config.sh…
frlan
- 6,950
- 3
- 31
- 72