| Author | Topic: Is it possible to use VIEWS in xBase++ |
---|
| Jacob John | Is it possible to use VIEWS in xBase++
on Mon, 12 Aug 2019 13:44:38 +0530Hi,
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 John | Re: Is it possible to use VIEWS in xBase++
on Tue, 13 Aug 2019 14:42:50 +0530Hi,
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 Borzic | Re: Is it possible to use VIEWS in xBase++
on Tue, 13 Aug 2019 14:50:30 +0200Jacob 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 John | Re: Is it possible to use VIEWS in xBase++
on Wed, 14 Aug 2019 11:52:19 +0530On 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 |