about API isc_dsql_describe_bind()

[Tsutomu Hayashi]

Hi all

I am using C API isc_dsql_describe_bind, here is confusion.

>From InterBase6APIGuide to neweset InterBase2009APIGuide(no Firebird
API Guide) said that set da_version to 1.

But, in source code From 1.0 to newest 2.5 I see this parameter is
called "dialect" and compare with xsqlda_dialect.

Should I set da_version to 1 or 3? As far as I see the code, I should
set to 3, but all sample is set to 1.

Thanks,

Tsutomu Hayshi

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Alexander Peshkoff]

On Wednesday 11 November 2009 11:28:18 Tsutomu Hayashi wrote:

> Hi all
>
> I am using C API isc_dsql_describe_bind, here is confusion.
>
> >From InterBase6APIGuide to neweset InterBase2009APIGuide(no Firebird
>
> API Guide) said that set da_version to 1.
>
> But, in source code From 1.0 to newest 2.5 I see this parameter is
> called "dialect" and compare with xsqlda_dialect.
>
> Should I set da_version to 1 or 3? As far as I see the code, I should
> set to 3, but all sample is set to 1.

Tsutomu, this is support question and should be asked not here, but at
http://tech.groups.yahoo.com/group/firebird-support/.
The answer is simple - SQL dialect and XSQLDA version are 2 absolutely(!!!)
different things, they are unrelated, i.e. set DA version=1;


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Tsutomu Hayashi]

Hi Alex

Sory, I see.

Thanks!

2009/11/11 Alexander Peshkoff <peshkoff@...>:

> On Wednesday 11 November 2009 11:28:18 Tsutomu Hayashi wrote:
>> Hi all
>>
>> I am using C API isc_dsql_describe_bind, here is confusion.
>>
>> >From InterBase6APIGuide to neweset InterBase2009APIGuide(no Firebird
>>
>> API Guide) said that set da_version to 1.
>>
>> But, in source code From 1.0 to newest 2.5 I see this parameter is
>> called "dialect" and compare with xsqlda_dialect.
>>
>> Should I set da_version to 1 or 3? As far as I see the code, I should
>> set to 3, but all sample is set to 1.
>
> Tsutomu, this is support question and should be asked not here, but at
> http://tech.groups.yahoo.com/group/firebird-support/.
> The answer is simple - SQL dialect and XSQLDA version are 2 absolutely(!!!)
> different things, they are unrelated, i.e. set DA version=1;
>
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Adriano dos Santos Fernandes-3]

Alexander Peshkoff escreveu:
> Tsutomu, this is support question and should be asked not here, but at
> http://tech.groups.yahoo.com/group/firebird-support/.
> The answer is simple - SQL dialect and XSQLDA version are 2 absolutely(!!!)
> different things, they are unrelated, i.e. set DA version=1;
Alex, just FWIW, internally there is a confusion of what XSQLDA version
is. It *is* compared with dialect version.


Adriano


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Vlad Khorsun-2]

> Alex, just FWIW, internally there is a confusion of what XSQLDA version
> is. It *is* compared with dialect version.

    Really ? Could you show this bad code ?

Regards,
Vlad

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Adriano dos Santos Fernandes-3]

Vlad Khorsun escreveu:
>> Alex, just FWIW, internally there is a confusion of what XSQLDA version
>> is. It *is* compared with dialect version.
>>    
>
>     Really ? Could you show this bad code ?
The code I was talking about is where DIALECT_xsqlda is used. The logic
to know about XSQLDA version is based on client dialect.

If I'm not wrong, we can even remove the SQLDA (non-X) support, because
I don't think we support the client dialect 0.


Adriano


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Vlad Khorsun-2]

> Vlad Khorsun escreveu:
>>> Alex, just FWIW, internally there is a confusion of what XSQLDA version
>>> is. It *is* compared with dialect version.
>>>    
>>
>>     Really ? Could you show this bad code ?
> The code I was talking about is where DIALECT_xsqlda is used. The logic
> to know about XSQLDA version is based on client dialect.

    As i understand it, DIALECT_xsqlda is the SQL dialect number starting
from which XSQLDA is used instead of SQLDA. So, i see no confusion there.
 
> If I'm not wrong, we can even remove the SQLDA (non-X) support, because
> I don't think we support the client dialect 0.

    Agree.

Regards,
Vlad

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Adriano dos Santos Fernandes-3]

Vlad Khorsun escreveu:
>> The code I was talking about is where DIALECT_xsqlda is used. The logic
>> to know about XSQLDA version is based on client dialect.
>>    
>
>     As i understand it, DIALECT_xsqlda is the SQL dialect number starting
> from which XSQLDA is used instead of SQLDA. So, i see no confusion there.
>  
Yes, but this has a workaround because SQLDA haven't a version field.
And it mixes the two things, which you all have said to be incorrect on
the SQL_NULL discussion. :-)

>  
>  
>> If I'm not wrong, we can even remove the SQLDA (non-X) support, because
>> I don't think we support the client dialect 0.
>>    
>
>     Agree.
But let it be there for now. The code may be interesting to do another
change in XSQLDA/VAR.


Adriano


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Alexander Peshkoff]

On Friday 13 November 2009 13:14:59 Vlad Khorsun wrote:

> > Vlad Khorsun escreveu:
> >>> Alex, just FWIW, internally there is a confusion of what XSQLDA version
> >>> is. It *is* compared with dialect version.
> >>
> >>     Really ? Could you show this bad code ?
> >
> > The code I was talking about is where DIALECT_xsqlda is used. The logic
> > to know about XSQLDA version is based on client dialect.
>
>     As i understand it, DIALECT_xsqlda is the SQL dialect number starting
> from which XSQLDA is used instead of SQLDA. So, i see no confusion there.
>
> > If I'm not wrong, we can even remove the SQLDA (non-X) support, because
> > I don't think we support the client dialect 0.
>
>     Agree.

Agree, but suggest do not touch yValve and related for a while. If we decide
to have new internal interface in 3.0, all this parts are to be almost
totally rewritten - no use wasting time for cleanup now.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Tsutomu Hayashi]

Thanks all

A vague problem is clear.

Tsutomu Hayashi

2009/11/13 Alexander Peshkoff <peshkoff@...>:

> On Friday 13 November 2009 13:14:59 Vlad Khorsun wrote:
>> > Vlad Khorsun escreveu:
>> >>> Alex, just FWIW, internally there is a confusion of what XSQLDA version
>> >>> is. It *is* compared with dialect version.
>> >>
>> >>     Really ? Could you show this bad code ?
>> >
>> > The code I was talking about is where DIALECT_xsqlda is used. The logic
>> > to know about XSQLDA version is based on client dialect.
>>
>>     As i understand it, DIALECT_xsqlda is the SQL dialect number starting
>> from which XSQLDA is used instead of SQLDA. So, i see no confusion there.
>>
>> > If I'm not wrong, we can even remove the SQLDA (non-X) support, because
>> > I don't think we support the client dialect 0.
>>
>>     Agree.
>
> Agree, but suggest do not touch yValve and related for a while. If we decide
> to have new internal interface in 3.0, all this parts are to be almost
> totally rewritten - no use wasting time for cleanup now.
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel