RE: An SQL 92 question

Ok, thought it might work.  It works for me on SQL Server, of course not on the 
screen, but when I send the result to the printer.  Good luck.



From: programmingblind-bounce@xxxxxxxxxxxxx 
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of 
Charles_Davis@xxxxxxx
Sent: Wednesday, December 05, 2007 10:49 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: RE: An SQL 92 question


Actually, that is effectively what I was referring to when I mentioned putting 
ANSI12 between the apostrophes.  It does not affect the output at all.

Thanks,
Charles


Rodney Haynie <RodneyH@xxxxxxxxxx>
Sent by: programmingblind-bounce@xxxxxxxxxxxxx

12/05/2007 10:17 AM
Please respond to
programmingblind@xxxxxxxxxxxxx


To

"programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>

cc

Subject

RE: An SQL 92 question







Charles, I have only one more suggestion.  You may have already done this but 
here it goes:



Have you tried using the old ALT+acsii value, way of entering a ascii value.



For example, you wanted the form feed.  So you would make sure number lock is 
on, and press and hold ALT and type 012

That would put a character on the screen that is representative of the Form 
Feed.  Of course you would position your cursor at the point you want the form 
feed before  typing ALT+012.  (Again, 012 on the number pad.)



You said you are using a screen reader, you will have to tell the screen reader 
to not listen while typing in the hotkey.  Insert + 3 if you are using JAWS, 
and then type the hotkey.



If this works, I would probably set the value to a variable and use the 
variable in all the places you need it.  Otherwise, when you are reading your 
code later, you won't know what character is at that exact point.



Anyway, good luck.



HTH.

Rodney





From: programmingblind-bounce@xxxxxxxxxxxxx 
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of 
Charles_Davis@xxxxxxx
Sent: Monday, December 03, 2007 10:08 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: RE: An SQL 92 question



Unfortunately, the version of SQL supported in Interbase 2007 does not know 
about the CHAR() function.

As for

SELECT '
'

My screen reader tells me that "ANSI13" & "ANSI10" have been inserted in the 
output.  I tried to get a form feed in the output by putting Ansi12 between the 
apostrophes, but that does not add anything to the output.

Thanks,
Charles




Rodney Haynie <RodneyH@xxxxxxxxxx>
Sent by: programmingblind-bounce@xxxxxxxxxxxxx

12/03/2007 09:45 AM


Please respond to
programmingblind@xxxxxxxxxxxxx



To

"programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>

cc

Subject

RE: An SQL 92 question










Charles,

I am not sure the method you posted is giving you a carriage return, or  just 
giving you a whole bunch of spaces that push you to the next line.

CHAR(13) is carriage return

CHAR(10) is Line Feed.



You may be able to concatinate these two values into the string, but I think it 
depends on where the result set will be used to know if it will appear 
correctly for you.



So something like the following may work for you.  I wrote this up in SQL 
Server 2000, so you may have to tweak the syntax if you get an error.



SELECT 'Line One' + CHAR(13) + CHAR(10) + 'Line 2'





HTH.

Rodney





From: programmingblind-bounce@xxxxxxxxxxxxx 
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of 
Charles_Davis@xxxxxxx
Sent: Monday, December 03, 2007 8:40 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: An SQL 92 question



Just a quick SQL question:

I am using Borland's Interbase which apparently implements a subset of SQL-92.  
I am trying to have the output contain certain control characters (for 
formatting).  Interbase has a user_defined function called ASCII_CHAR(), but 
that apparently cannot be used in the SELECT clause.

I discovered that I can insert CRLFs by doing:

Select '
'

But I cannot figure out how to insert form feeds.

Thanks for the help.

Regards,
Charles Davis

Other related posts: