version 6 search window

Discussions relating to breakout scripting, .NET and COM programming with Jiwa objects.

version 6 search window

Postby tonys » Thu Jan 11, 2018 3:46 pm

I have created a custom search option but not sure how to set the qty's and $ as numbers instead of txt.


How can I make the Qty’s and Cost show formatted to 2 decimal places.



'tony add second one

SQL = "SELECT InventoryID, PartNo, Description, Lcost, QuantityLeft, QuantityAllocated, Warehouse, BinLoc "
SQL = SQL & " FROM View_CouplersStockSearchWithBin "

OrderBy = "ORDER BY PartNo"

Set AOption = CreateObject("JiwaSearch.SearchOption")

With AOption
.Title = "Part and Bins"
.SQLStr = SQL
.OrderBy = OrderBy
.AddColumn "InventoryID", vbString, "", 0, 1
.AddColumn "PartNo", vbString, "", 10, 5
.AddColumn "Description", vbString, "", 10, 2
.AddColumn "LCost", vbString, "",10, 2
.AddColumn "QuantityLeft", vbString, "", 10, 2
.AddColumn "QuantityAllocated", vbString, "", 10, 2
.AddColumn "Warehouse", vbString, "", 10, 2
.AddColumn "BinLoc", vbString, "", 10, 2



End With
JiwaSearchObject.Options.Add AOption
Set AOption = Nothing
tonys
Occasional Contributor
Occasional Contributor
 
Posts: 26
Joined: Tue Mar 04, 2008 10:25 am

Return to Technical / Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron