[Resolved] String

snufse · November 13th, 2008, 11:49 AM

I need to pass a value to a stored procedure. The field is JobNumber and defined as char(12) in my sp. In my program I get the JobNumber value from a TextBox. When I map to JobNumber I need to right justify the value from the TextBox with leading blanks. This is what I have done (so far)

dim JobNumber as string
JobNumber = Space(12)

Now I need to set JobNumber = TextBox.text right justfied with leading blanks. The value of the TextBox is always numeric and could be any number from 1 to 999999999999. Thank you.

gbianchi · November 13th, 2008, 07:44 PM

mmm.. and what about

Code:

JobNumber = space(12 - textbox.text.length) & textbox.text

You can add an if before to check the length (for 0 space)... Done this a millions times ;)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

snufse · November 14th, 2008, 10:19 AM

Hi gbianchi,

Worked great. Thank you very much.

gbianchi · November 14th, 2008, 12:29 PM

np.. :)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========