Hi, I am currently looking at dbForms, and am running a small pilot project. With the Search form (based on the viewTable), the behaviour seems to be:
1. retrieve all rows from the table. 2. display the first set of rows. 3. apply search criteria to filter the rows, then redisplay. The problem I have is that the table has 2.5 million rows. Is there any way to change the behaviour so that: 1. the user enters the search criteria into the form. 2. the database is queried using the entered criteria, resulting in a lot smaller number of rows being returned. 3. display the smaller result set. Thanks, Steve Watson --------------------------------------------------------------------- This email is from Civica Pty Limited and it, together with any attachments, is confidential to the intended recipient(s) and the contents may be legally privileged or contain proprietary and private information. It is intended solely for the person to whom it is addressed. If you are not an intended recipient, you may not review, copy or distribute this email. If received in error, please notify the sender and delete the message from your system immediately.Any views or opinions expressed in this email and any files transmitted with it are those of the author only and may not necessarily reflect the views of Civica and do not create any legally binding rights or obligations whatsoever. Unless otherwise pre-agreed by exchange of hard copy documents signed by duly authorised representatives, contracts may not be concluded on behalf of Civica by email. Please note that neither Civica nor the sender accepts any responsibility for any viruses and it is your responsibility to scan the email and the attachments (if any). All email received and sent by Civica may be monitored to protect the business interests of Civica. --------------------------------------------------------------------- ------------------------------------------------------- This SF.net email is sponsored by: The Definitive IT and Networking Event. Be There! NetWorld+Interop Las Vegas 2003 -- Register today! http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
