Creating Checkbox Component SQL String

Asked By silvalillian 10 points N/A Posted on - 10/26/2011

I am trying to make a statement using SQL but since I am just a beginner in using this, I cannot get my statement correct. The program I am doing is a Visual Basic 6 database. This is regarding my checkbox component SQL string. The problem is, when choosing one of those checkboxes and selects it; the data will be seen in the data list component.

How can I reference the data list on my SQL checkbox statement?

For instance, I have a database table named as category and it has two fields; (ID(key) and category) and another table named as Class 1 which consist of four fields; (category1, category2 *the two will consist of the IDs from the table Category*, group and class.

Now I want to make a multiple checkboxes for the Category types like cotton, wool, acrylic, and blend.

This is to select one or more categories then return the applicable items from the yarns table on the data list component.

How can I write the correct statement for this?

Please send me some help.

Thanks.

• Status: Open
• Question Views: 826
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Jackman 0 points N/A #95132

Creating Checkbox Component SQL String

The two types of components in visual basics are the reusable code and the non reusable codes. To achieve reusable codes you can write the functions and procedures. Open your HTML editor the type this simple codes

HTML > Title > simple calculator test > title > body

Dim add results, subresults, mulresults, divresults

Dim addnum, subnum, mulnum, divnum

This simple codes will create an object which will allow you to interact with your dll calculator after creating the component string. To create the string change the project name then leave the threading model and add the reference library change names of the class1 module do the coding then compile the codes.

About Jackman

Questions
4

Answers
159

Best Answers
47

• Vote Up 0 Vote Down

• Posted on - 10/27/2011
• Question Category: MS SQL Server