Tip Bank

Question: I’m working on a company intranet and need to predefine the ?subject and ?body in an e-mail link. When I do, the text always defaults to lowercase. Is there

Question: How do I prevent corrupt indexes or automate the rebuilding of corrupt indexes? Answer: Prevent corrupt indexes by taking steps to prevent the crash of an application: 1. Consider

Question: How can I put a variable in a SQL string? For example: input:=edit1.text;query1.sql.add(‘select * from address where name like ‘); Answer: Since SQL.Add takes a string, all you need

Question: Is there a simple way to ascertain the names of all the controls on a particular form at run time? Answer: Every TComponent descendant has two properties, ComponentCount and

Question: In your answer to my previously posted topic, “Changing label captions in FOR loop,” you suggested I use “Sleep.” When I used it, the loop slowed down but didn’t

Question: My executable takes almost a minute to run. How can I speed up the process? I am not running any queries at this point?I wait until I actually show

Question: I need a summary-select which summaries cumulative values. This one works in Microsoft Access: SELECT s.nl_item_id, s.nl_value, ( SELECT sum(sub.nl_value) FROM TABLE1 sub WHERE sub.nl_item_id

Question: I have been developing software in Foxpro 2.5 for DOS for many years. I have just bought a licensed VFP 6.0, I want to know what is new in

Question: I have a Delphi 3 application running on a Novell network, that uses Paradox tables. For some reason, some of the users get the following message every once in