Hi Sean!

I suspected, that the problem is between screen and keyboard
and so it was! LangRef.pdf has only one sample on this subject and
even this is with begin ... end. Temporary blindness I quess <g>

Maybe You can help me with other problem also.
I have an idea about SP what writes text to columns in different
languges. The number of words is small - about 50 in each language.
A very similar example would be shop, where goods names are all
in english, but receipts would been printed out (and saved ) in
different languages. My program should do similar, only it deals with
licenses. Until now I haven't succeded to make a table
what has columns with different char set, for example :
WIN1252, ISO8859_1, WIN1251, NONE. To be more precise - I can
make the table, but not to write or read from it.
I searched all newsgroups and saw 1 message where somebody suggests
how to update such column (update A SET B = _WIN1251 'CYRILLIC')
This works for me, but still no luck with reading :(
Are You aware of this method, is it described anywhere? How would
be te syntax for reading (select)?

And when someone has "tasted" SP speed, especially with RDB$DB_KEY,
there is no way back to paradox :)

regards,
Harri

--- In ib-support@y..., "Leyne, Sean" <InterbaseSupport@a...> wrote:
> Harri,
>
> Your problem is that if you want multiple statements to execute
within
> the FOR SELECT ... DO loop you need to include the statements with a
> BEGIN ...END block.
>
> Your statement would look something like...
>
> FOR
> SELECT ... INTO ...
> DO
> BEGIN
> SELECT ... INTO ...;
> P_ID = ...;
> IF (P_ID > 0) THEN
> SUSPEND;
> END
>
>
> Sean
>