former_SQLA_member1694868
Participant
Member since ‎2010 Sep 02

User Statistics

  • 227 Posts
  • 0 Solutions
  • 328 Kudos given
  • 261 Kudos received

User Activity

Web Style Procedure - Select vs Call - Different Schema Than Expected

2020 Jul 14
Starting from Breck's article here: Building a Link-Checker Inside SQL I created (copied) a basic procedure to check the HTTP status of a webpage: CREATE OR REPLACE PROCEDURE sxhttp_head_attributes ( IN url LONG VARCHAR ) RESULT ( ...

ODATA - CORS Support

2018 May 15
We are testing some different grid tools in order to display SQLA 17 data in a client website. After lots of trial and error I am down to this error message as the grid tool attempts to access a published table of an SQLA ODATA producer: 16:06:06.28...

Visual FoxPro as a Remote Server via OLE

2017 Sep 08
I am attempting to bring the contents of a Visual FoxPro database into SA 17.0.4.2053. I have installed VFP 9 using the CD provided by the client and downloaded the OLE DB provider for Microsoft Visual FoxPro as Microsoft says the ODBC driver is no...

Extra Decimal Storage

2017 Jun 02
SQLA 17.0.4 Build 2053 (also seen in 12 and 16 though) It appears that fields defined as decimal (30,6) can store more than 6 decimal places. Take this example: drop table if exists zMyRate; create table zMyRate ( ID integer default autoincrement...

OData ODSL service model setup to expose procedures as services only.

2017 May 25
Using SQL Anywhere 17.0.4.2053 Setting up ODSL model the documentation indicates that without a model, all tables and views with primary keys are exposed. If I setup a model and only include the statement for a service service namespace "OBabyServic...
View more