getting data from global data sheet and using it in the same script

getting data from global data sheet and using it in the same script - Printable Version

+- 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: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: getting data from global data sheet and using it in the same script (/Thread-getting-data-from-global-data-sheet-and-using-it-in-the-same-script)

getting data from global data sheet and using it in the same script - jbelkin@gmail.com - 07-31-2012

My test needs to create a new shipment id and use that shipment id as Order ID in the same script.

I have the following script which is suppose to get data table value and use that value in the following line on the script. The problem is, I am getting the following message "Wrong number o farguments or invalid property assignment: "Data Table. Value"

Code:
Browser("SAPPHIRE R5.1").Page("SAPPHIRER5.1").Frame("maint_iframe").WebEdit("pr0_u_airbillnumber").Set DataTableInc("QTP", "ShipmentNum",  "GlobalData")

wait(1)

Browser("SAPPHIRE R5.1").Page("SAPPHIRE R5.1").Image("Save").Click

Browser("SAPPHIRER5.1").Page("SAPPHIRER5.1").Frame("maint_iframe").WebElement("AddRowTR").Click

Dim triddata

DataTable.Value("QTP","ShipmentNum", dtGlobalSheet) = triddata

msgbox triddata

Browser("SAPPHIRE R5.1").Page("SAPPHIRE R5.1").Frame("maint_iframe").WebEdit("TRID").triddata

Browser("SAPPHIRE R5.1").Page("SAPPHIRE R5.1").Image("Save").Click

RE: getting data from global data sheet and using it in the same script - Ankesh - 07-31-2012

Code:
DataTable.Value("QTP","ShipmentNum", dtGlobalSheet) = triddata

////

use the bleow line

Code:
Datatable.value("<ColumnName>",<SheetName>")=<Your Value>

e.g.,

Code:
Datatable.value("Shipment",dtGlobalSheet)="zzzzzzz"

Regards,
Ankesh