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 getting Expected lexical element not found: ) There was a problem parsing the table ...
I'm trying to output the results of a SELECT query to a tab delimited text file in Advantage Data Architect. I know I can use the 'Export to' feature to do this, but there are a lot of tables and that is going to take forever. I would rather use the SQL editor, but I found out it does not accept the OUTPUT TO argument, even though tha...
As far as I know, ADS v.10 tries to keep result of query in memory until it is a quite huge. The same should be true for the __output table and for temporary tables. When the result becoming large, swapping stated. The question is what memory limit is set for a query, a worker, whatever? Could this limit be configured? Thanks. ...
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 x86_64 box, and maintaining a seperate install of x86 Perl just for this one package, I have m...
Is it possible to define a current user? I found a stored procedure 'sp_mgGetConnectedUsers'. It returns a result set with the only unique field 'Address'. How could I associate an executing query with such 'Address'. Please advice. Note: As far as I understand, another way to get the current user is to set a unique application Id fo...
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'; CDS.Open except // trap exception here - this never gets executed! end; If the SQL st...
I installed VS 2010 on a Windows 7 64 bit machine. When I try and connect to an advantage database through the server explorer using the Advanatage OLEDB driver I get a cannot discover advantage database server error. I can connect to the database using the ARC just fine. I was able to connect in VS 2008 just fine. Any ideas on why I...
Is there any updated documentation for the field names and types for the Advantage Database system tables? ...
The code below shows that a record is deleted when the sql statement is: select * from test where qty between 50 and 59 but the sql statement: select * from test where partno like 'PART/005%' throws the exception: Advantage.Data.Provider.AdsException: Error 5072: Action requires read-write access to the table How can you rel...
NumericPrecision xmlnode not returned on non-numeric fields NumericScale xmlnode not returned on non-numeric field ProviderTypeName xmlnode is returned but does not exist in documentation. How do I return the NumericPrecision and NumericScale fields as empty xmlnodes? ...
Hi, On a Windows 7 machine with Advantage Data Architect version 9.10.0.11, money type data is returned as Dollars, instead of Pounds. Sometimes, it will suddenly switch to Pounds, without me changing any settings. Everything else returns Pounds correctly (regional settings is UK with £ as the currency symbol). Has anyone else had this ...
Hey guys! I created .NET-based AEP for ADS v10 beta. Here is a procedure code. .NET side: public int TestSP(int connectionId, int connection, ref int numRowsAffected) { AdsConnection cnn; lock (_connections) cnn = _connections[connectionId]; using (var cmd = cnn.CreateCommand()) { cmd.CommandText = "INS...
Hi! I need some help with the ADS OleDB Provider for Visual FoxPro. I'm trying to insert data from an 64-Bit .net-Application into a FoxPro Database. The table in which the data will be inserted has about 130'000 records, 139 fields and 11 indexes. Every time I run my sample application i get an error which says that the indexes are co...
I am in search of who specifically to contact at Sybase regarding Advantage Database Server's DBI driver, specifically DBD::Advantage. The only reference I can find is to one 'lancesc' in the README, but there are no references to a contact email, CPAN author etc. Inadvertantly I happened upon one StackOverflow user lancesc here. Woul...
I have just installed 9.10.0.21 and the fix for "Fixed an issue where ARC would show up off the visible desktop if previously opened on a screen that was no longer attached." now opens ARC on monitor number 1 every time. It used to open it on whichever monitor I last used. I realise this is an easy way to fix a problem if you close it ...
Can the AEP Stored procedure functions have additional paramenters added? ...
Does the full dictionary path need to be specified for the DataSource? I have tried using the database AliasName and it doesn't seem to work. ...
How do you use sp_getProcedureColumns()? I cannot find any documentation for it. Thanks, Howard ...
How do I find out what the value of the COLUMN_TYPE returned from sp_getProcedureColumns? The value returned is an shortInt. There is nothing in the documentation for this system procedure. Thanks, Howard ...
Can I open the ads_err table from a windows service? ...