How To Submit Query Required Data Without User Prompt Using Mixed Oledb Source And Substrings In Vb Code ? Follow
For several years for three clients (Bartender Automation 9.10) I have developed a windows service that prints the labels by making raw data collection through stored-procedures on SQL Server database, and after (vb.net code) using the "Format.SubStrings("xxxx").Value = xxx" to populate the label with data. Now I have a new customer and a new BarTender 10.1 Automation. The client first used the software EasyCode and wants, even with Bartender create the label through direct connection to the database so can see immediately the label (during the editing) over to check if it's ok. I used as a data source fields in a SQL table and I created a small query with a prompt to enter a "product code" for data searching. I also assigned a name to the product text that I use in the service program as a substring. When print the label the value of the substring that i assign in code is ignored, and I see (Print.Message) that the query is running but with key research ='' (no record found) and Result=2. How do I programmatically connect to OLE DB source and compile the query by assigning the value of search ?