All standard search does not have long enough description field.
I have created a custom search with Description length = 50
However, it does not seem to work with an error returned.
Your help will be much appreciated.
JimmySu1402 wrote:Hi Mike,
Would might test my plugin and let me know why i ran into issue when I am trying to use the custom search to add item to Bill of Material.
Private Sub Search_Showing(sender As Object, e As System.EventArgs)
Dim search As JiwaApplication.JiwaSearch.clsSearch = sender
With search
If .CurrentSearchMode = JiwaApplication.JiwaSearch.clsSearch.SearchModes.jswInventory Then
' Add Inventory Custom Search to display
Dim AOption As New JiwaApplication.JiwaSearch.SearchOption
With AOption
.Title = "ASAS - CustomSearch"
.SQLStr = "SELECT IN_Main.InventoryID, IN_Main.PartNo, IN_Main.Description, CASE IN_Main.Status WHEN 0 THEN '0. Normal' WHEN 1 THEN '1. Discontinued' WHEN 2 THEN '2. Deleted' WHEN 3 THEN 'Slow Moving' WHEN 4 THEN '4. Obsoleted' END AS ItemStatus, IN_Main.DecimalPlaces " +
"FROM IN_Main "
.OrderBy = "ORDER BY PartNo"
.AddColumn("InventoryID", vbString, "", 0, 1)
.AddColumn("Part No", vbstring, "", 15, 2)
.AddColumn("Item Description", vbString, "", 50, 3)
.AddColumn("Item Status", vbstring, "", 9, 4)
.AddColumn("Decimals", VariantType.Integer, "", 0, 10)
End With
.Options.Add(AOption)
End If
End With
End Sub
Return to Technical and or Programming
Users browsing this forum: No registered users and 19 guests