December 23, 1997

Using variable in SQL WHERE clause

Question: How can I use the contents of a text box as the WHERE clause in a SQL query? “SELECT * FROM Table WHERE Field = Text1.Text” doesn’t work. Answer:

Calculating the Records

Question: Can you help me to get a calculated value from many records? A dataset(Paradox table) that I use has an Integer field which is used to put minutes value.

Setting Environment Variables in VB

Question: My 16bit application requires the presence of a DOS environment variable. On startup I check for it. If it does not exist I display an error. I would like

Counting Work Days

Question: I need to calculate the number of workingdays. Is there an easy way to do this? Answer: From what I can see, there is no built-in function to do

Which VB for me?

Question: I wish to create my own Windows program for a kart racing club that we can enter all the drivers for a race meeting, draw a grid for the

ObjectInputStream Constructor

Question: How do I use the socket.getInputStream() with theObjectInputStream? Because the arguement type of the ObjectInputStream constructor is FileInputStream. I like to do something like:remoteIn = new ObjectInputStream(socket.getInputStream()); What should

Finding Whole Words in a TextArea

Question: How do I find whole words in TextAreas? I have an application that is suppose to find particular words in a paragraph to see if you use certain words

Borland Database Engine

Question: Many companies offer Borland Database Engine replacements claiming to be smaller and faster. What does the BDE offer that these replacements don’t? Is there a good reason to keep

Percent Bars with the Windows 95 Look

Question: How do you make a percent bar with the Win 95look and feel? I know that you can make a percentbar using a picture box, but I am trying