Tip Bank

DevX - Software Development Resource

Searching Date Fields

Question: In procedure, I used statement like this:ds.FindFirst “fulldate = ’95-10-31′” ‘ds is DynaSet variablebut always it fails, and ds.NoMatch Value is True(-1).What’s wrong with this? Please help me. Answer:

DevX - Software Development Resource

Calling Stored Procedures

Question: Can one call a stored procedure or function in oracle 7through odbc from visual basic? This might be a questionfor an oracle user group, so if you know where

DevX - Software Development Resource

Changing Database Structure

Question: I’m using VB 3.0 to work with databases in the Jet 2.0 format. I expect it will be necessary to add new fields to the database sometime in the

DevX - Software Development Resource

Filling a Structure Automatically

Question: After a structure is defined witha “TYPE” declaration, do you know of a way to directly fillthe structure with data, rather than individually assigingthe elements, or reading from a

DevX - Software Development Resource

Two VB Instances, Only One Visible

Question: I am running my VB application on Novel 3.12 file server. When application is running it shows to 2 instances of programon file server console: for example if application

DevX - Software Development Resource

Pausing After Dialing

Question: How do you pause after dialing a phone number ? I want to be able to dial a pager number and then pause 3 -5 seconds before sending the

DevX - Software Development Resource

Highlighting Text

Question: Is there an API function that will highlight a word in a textbox the way the find command does without using the clipboard? Answer: Set the SelStart property of

DevX - Software Development Resource

Changing Cell Colors

Question: I have written a calendar function using the standard grid control as the calendar. The text property of each row/column is set to the correct day within the month

DevX - Software Development Resource

Creating an Executable

Question: I would like to know how to make an EXE file that I can runit in another computer which does not have Visual Basic Installed. Answer: VB 3 and