Harri,

Unfortunately, I don't have any real experience working with character
sets. So I can't be much help.


Sean

> -----Original Message-----
> From: harri@... [mailto:harri@...]
> Sent: Saturday, January 27, 2001 3:10 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: SP syntax question (and more)
>
>
> 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
> >
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> eGroups is now Yahoo! Groups
> Click here for more details
> http://click.egroups.com/1/11231/0/_/_/_/980626234/
> --------------------------------------------------------------
> -------_->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>