I have a question related to running an SQL query for range of data.
I am running a query like:
i installed and configure the cache odbc ODBC-2016.1.1.107.0-lnxrhx64.tar in centos7.
it connected while executing in terminal .(i.e isql -v DSN)
When working with a large query executed though an ODBC connection what is the best way to allow the paging of the results at the client side.
I'm trying to use the standard TSQL DECLARE syntax but I get the following error:
[%msg: < IDENTIFIER expected, @ found^ DECLARE @>]
How do I declare a variable? For instance:
I have a class with a string property with DISPLAYLIST and VALUELIST parameters specified.
When I query this class via ODBC I receive logical value as it is and not a display value.
In OS X 10.8 and earlier, PHP was built with ODBC support, making it easy to connect to a Caché database: