Tip Bank

Question: When using the following commands to modify a dbf file, I find the file is not accessible for modification: USE MODIFY STRUCTURE How do I modify the file structure?

Question: Can I get a list of the columns and datatypes that are returned from a stored procedure without executing the procedure? Answer: There’s no way of doing this using

Question: How do I place a text box on a pageframe (or anything for that matter)? Answer: Right click the pageframe in the form designer or class designer and choose

Question: I am having to reformat data for addition to a database. My current struggle involves an identification field for certain records. In the new database it needs to be

Question: Is there a 2.5 patch for running on fast computers? Answer: The only patch that I am aware of is the 2.6 patch.

Question: What causes the error message”Invalid seek offset”? Answer: This message is often a symptom of a corrupted index. You may want to rebuild the indices of whatever table you

Question: I need to pass the @TheVar variable to the stored procedure’s IN statement but I keep getting zero records. If I type this statement into the SQL… WHERE Name

Question: Every time I try to use a wizard, I get the following error message: “Cannot find the Wizard Program.” The wizards are located in the same folder that I

Question: I have a field that stores lots of data (up to 8,000 characters). I thought that I could maybe save disk space if I stored this data as varbinary