Alaska Software Inc. - Is it possible to use VIEWS in xBase++
Username: Password:
AuthorTopic: Is it possible to use VIEWS in xBase++
Jacob JohnIs it possible to use VIEWS in xBase++
on Mon, 12 Aug 2019 13:44:38 +0530
Hi,

We are using ADSDBEto connect Data Dictionary. Is it possible use
VIEWS in xBase++ ?

Also, I have created a View "CASINOC9" using Data Architect. But while
trying to open that View, it shows an error "Alias not found in the
alias list : CASINOC9". What could be the reason ?

Regards
Kiron
Jacob JohnRe: Is it possible to use VIEWS in xBase++
on Tue, 13 Aug 2019 14:42:50 +0530
Hi,

I have created a View in ADS Data Dictionary using Data Architecht
using a query "	SELECT CODE,NAME FROM SUBMSTB9 WHERE TYPE='1'	" and
i could open the View using DbUseArea().

Then i changed the querry to "	SELECT DISTINCT CODE,NAME FROM
SUBMSTB9 WHERE TYPE='1'	". Then DbUseArea is not working. DISTINCT not
supported. Anybody else used Views in xBase Application ?

Regards
Kiron


On Mon, 12 Aug 2019 13:44:38 +0530, Jacob John wrote:

>Hi,
>
>We are using ADSDBEto connect Data Dictionary. Is it possible use
>VIEWS in xBase++ ?
>
>Also, I have created a View "CASINOC9" using Data Architect. But while
>trying to open that View, it shows an error "Alias not found in the
>alias list : CASINOC9". What could be the reason ?
>
>Regards
>Kiron
Boris BorzicRe: Is it possible to use VIEWS in xBase++
on Tue, 13 Aug 2019 14:50:30 +0200
Jacob John wrote in news:0hv4lep2vi7c078h8lh0ebhp0096cummtl@4ax.com:

> I have created a View in ADS Data Dictionary using Data Architecht
> using a query "     SELECT CODE,NAME FROM SUBMSTB9 WHERE TYPE='1'    
> " and i could open the View using DbUseArea().
> 
> Then i changed the querry to "     SELECT DISTINCT CODE,NAME FROM
> SUBMSTB9 WHERE TYPE='1'     ". Then DbUseArea is not working. DISTINCT
> not supported. Anybody else used Views in xBase Application ?

You can do it via Advantage ODBC driver. With SQLExpress you can connect to 
Advantage and execute SQL queries: https://sqlexpress.net

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools
Jacob JohnRe: Is it possible to use VIEWS in xBase++
on Wed, 14 Aug 2019 11:52:19 +0530
On Tue, 13 Aug 2019 14:50:30 +0200, Boris Borzic wrote:

>Jacob John wrote in news:0hv4lep2vi7c078h8lh0ebhp0096cummtl@4ax.com:
>
>> I have created a View in ADS Data Dictionary using Data Architecht
>> using a query "     SELECT CODE,NAME FROM SUBMSTB9 WHERE TYPE='1'    
>> " and i could open the View using DbUseArea().
>> 
>> Then i changed the querry to "     SELECT DISTINCT CODE,NAME FROM
>> SUBMSTB9 WHERE TYPE='1'     ". Then DbUseArea is not working. DISTINCT
>> not supported. Anybody else used Views in xBase Application ?
>
>You can do it via Advantage ODBC driver. With SQLExpress you can connect to 
>Advantage and execute SQL queries: https://sqlexpress.net

Hi,

Is it possible with ADSDBE ?

Regards
Kiron