Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Calling all Coders!

Author  Topic 

steamngn
Constraint Violating Yak Guru

306 Posts

Posted - 2005-01-04 : 21:54:44
Here's a good one for all the propeller heads out there:
Anyone know how to to get a stored procedure to force a carriage return, either from within SQL or perhaps by calling a javascript or somesuch? Looking for a workaround for an app; The idea is after the sproc is triggered to print a report, it will call the system carriage return to close the print screen...
Silly challenges are so much fun!

There's never enough time to type code right,
but always enough time for a hotfix...

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2005-01-05 : 08:10:13
And you're not talking about:

select ' Hello ' + char(13) + ' There'

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page

steamngn
Constraint Violating Yak Guru

306 Posts

Posted - 2005-01-05 : 08:46:08
Well....yesnosorta.
What I am asking for is the carriage return to function as if someone has just pressed the <enter> key on their pc. Scary thought, but could it be done?
quote:
Chaos, Disorder and Panic ... my work is done here!

Great Tag!
Andy

There's never enough time to type code right,
but always enough time for a hotfix...
Go to Top of Page

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2005-01-05 : 09:08:12
Ummm ... You want SQL to react to keypressed ? I *quess* if you had an XP, it might be doable, but I know little about XP's..

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -