Re: [Firebird-devel] Are isc_sql_interprete and isc_sqlcode deprecated calls?

2022-01-17 Thread Tony Whyman
to be precise - after code review I do not see isc_sqlcode() to be maked 
as deprecated
but I remember well that it was mentioned somewhere as not recommended 
in new development, sqlstate is preferred



The Firebird 4 language reference states:

|"SQLCODE| has been used for many years and should be considered as 
deprecated now. Support for |SQLCODE| is likely to be dropped in a 
future version."


This probably should be reflected in the code.

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Are isc_sql_interprete and isc_sqlcode deprecated calls?

2022-01-17 Thread Alex Peshkoff via Firebird-devel

On 1/17/22 13:17, Tony Whyman wrote:

Aren't you confusing isc_interprete with isc_sql_interprete?



definitely yes
sorry

isc_sql_interprete interpets the SQLCode, so it does make sense to 
drop it if you are getting rid of  SQLCode.


absolutely right
to be precise - after code review I do not see isc_sqlcode() to be maked 
as deprecated
but I remember well that it was mentioned somewhere as not recommended 
in new development, sqlstate is preferred





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Are isc_sql_interprete and isc_sqlcode deprecated calls?

2022-01-17 Thread Tony Whyman

Aren't you confusing isc_interprete with isc_sql_interprete?

isc_sql_interprete interpets the SQLCode, so it does make sense to drop 
it if you are getting rid of  SQLCode.


On 17/01/2022 09:54, Alex Peshkoff via Firebird-devel wrote:

On 1/17/22 12:24, Tony Whyman wrote:


In the legacy Firebird API, there are three functions that support 
error message formatting:


isc_sqlcode,
isc_sql_interprete, and
fb_interpret.

In the OO API, fb_interpret becomes IUtil->formatStatus*. *However, I 
can find no OO API equivalent for the other two. Is this because they 
are deprecated for future use?




Yes.
Whole sqlcode feature is deprecated, sqlstate should be used instead.
What about isc_sql_interprete that's just old, unsafe variant of 
fb_interpret.





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Are isc_sql_interprete and isc_sqlcode deprecated calls?

2022-01-17 Thread Alex Peshkoff via Firebird-devel

On 1/17/22 12:24, Tony Whyman wrote:


In the legacy Firebird API, there are three functions that support 
error message formatting:


isc_sqlcode,
isc_sql_interprete, and
fb_interpret.

In the OO API, fb_interpret becomes IUtil->formatStatus*. *However, I 
can find no OO API equivalent for the other two. Is this because they 
are deprecated for future use?




Yes.
Whole sqlcode feature is deprecated, sqlstate should be used instead.
What about isc_sql_interprete that's just old, unsafe variant of 
fb_interpret.





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] Are isc_sql_interprete and isc_sqlcode deprecated calls?

2022-01-17 Thread Tony Whyman
In the legacy Firebird API, there are three functions that support error 
message formatting:


isc_sqlcode,
isc_sql_interprete, and
fb_interpret.

In the OO API, fb_interpret becomes IUtil->formatStatus*. *However, I 
can find no OO API equivalent for the other two. Is this because they 
are deprecated for future use? If not, then shouldn't they also be 
available via IUtil?


Tony Whyman

MWA


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel