>If the question is which is likely to perform better, then the answer
is the select.
>Select statements can be compiled and optimized once and reused, avoiding
>validating access and metadata references. The execute block must be
compiled,
>optimized, and access checked each time it's used.
Is there any utf-8 code page that can be used as database charset? So, there
will be possibly no more such issues.
Sent from my iPhone
> On 27 Jan 2016, at 15:25, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] wrote:
>
> 27.01.2016 14:15, blumy2...@yahoo.com [firebird-support] wro
On Wed, Jan 27, 2016 at 7:48 AM, hamacker sirhamac...@gmail.com
[firebird-support] wrote:
>
>
> I would know whats methods is more effective, per exemple:
>
Example below shows two convoluted ways to return 'Y' or 'N' depending on
whether an item with a particular id exists: a select against rdb
On Wed, 27 Jan 2016 10:48:49 -0200, "hamacker sirhamac...@gmail.com
[firebird-support]" wrote:
> I would know whats methods is more effective, per exemple:
> To know if itens exists or not, select:
> select
> case
> when exists(select 1 from cv_itens where id_cv=51716)
> then 'Y'
>
27.01.2016 14:15, blumy2...@yahoo.com [firebird-support] wrote:
> Field STRADA in table is define WIN1251
Win1251 is a Cyrillic character set, it dos not include Romanian letters.
--
WBR, SD.
On 27/01/2016 13:15, blumy2...@yahoo.com [firebird-support] wrote:
in my Builder c++ 6 application i have a SQL query for a table, in
Firebird 1.5.6 fdb database
" where STRADA " + = QuotedStr(edText->Text). Field STRADA in table is
define WIN1251
in edText, the are Romanian characters,
in my Builder c++ 6 application i have a SQL query for a table, in Firebird
1.5.6 fdb database
" where STRADA " + = QuotedStr(edText->Text). Field STRADA in table is define
WIN1251
in edText, the are Romanian characters, like ş and ţ.
if the text not include romanian characters, th
I would know whats methods is more effective, per exemple:
To know if itens exists or not, select:
select
case
when exists(select 1 from cv_itens where id_cv=51716)
then 'Y'
else 'N'
end as existe_itens
from rdb$database
OR using block execute:
execute block
returns(exist varchar(