+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: DB (/Thread-DB)
DB - SS001 - 05-13-2010
Hi Ankur,
I have used SQL query to fetch an order number from database and i have stored it in datatable. I have used that value in datatable as a variable and passed in my script.
The value stored in the datatable is as below
order.453452
I want to pass the number "453452" as a variable. Can you help me with that?
Thanks in advance
RE: DB - manishbhalshankar - 05-13-2010
Hi,
You can use Split function to get the no from order.453452. Use (.) as your dleimiter.
You can get more help on split in qtp help.
RE: DB - basanth27 - 05-13-2010
Code:
ReqNum=Split(order.453452,".")(1)
msgbox ReqNumRE: DB - SS001 - 05-13-2010
I tried Split() and it works.
Thank you so much