Diane, How about a select statement searching the records for your doc number and putting the record no into a variable , and then issue your property table <tablename> <recno> since this command always works quickly for you.
So code for the button doing a search based on document number could be like set var vrecno, vdocno integer = null Dialog ' Enter the Document Number to search for' vdocno select recno into vrecno from tabllename where docno = .vdocno endif PROPERTY TABLE <tablename> .vrecno -- Frank Taylor, Information Technologies Administrator -- F.J. O'Hara Corp - Araho Transfer -- Boston, MA. Miami, FL -- [email protected]<mailto:[email protected]> -- Direct Dial:617-790-3093 ________________________________ From: [email protected] [[email protected]] On Behalf Of [email protected] [[email protected]] Sent: Friday, January 30, 2009 3:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Searching on a Column in a Form (Oops, the e-mail got sent before I signed it!! Here it is again...) Hi, all, I have a form based on a table having about 25,000 records with a key field called "DocNo". The form has several subtables on it. On the form, I have the normal navigation bar; I also have a button "Jump to Rec#" that uses "PROPERTY TABLE <tablename> <record no. to jump to>" to jump to a particular record# in the recordset. This button works well. I also have a button "Jump to Doc#" where I'd like the user to be able to enter the "DocNo" value, and the form would skip to the record whose "DocNo" field has the value specified by the user. I've tried the command: PROPERTY TABLE 'FormTableName->SEARCH->FormColumnName->' varname where "varname" is the DocNo specified by the user. This command will ultimately find the record, but the form is repainted for each record along the way and it takes seconds or minutes to arrive at the specified record. I've tried using PROPERTY RBASE_FORM alphablendvalue "0" and PROPERTY RBASE_FORM alphablendvalue "255" to hide the form until the record is found (and then display the form), but it still can take forever to arrive at the selected record, and the screen periodically blinks during the processing. Does anyone have any ideas as to how I can do a search on a column in the recordset that the form is based on, and 1) have it be quick and 2) not have the screen repainted over and over again through the recordset while the column is being searched? Thanks, Diane DeMers [email protected] DeKalb, IL ________________________________ A Good Credit Score is 700 or Above. See yours in just 2 easy steps!<http://pr.atwola.com/promoclk/100000075x1215855013x1201028747/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072%26hmpgID=62%26bcd=DecemailfooterNO62> _______________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. If you need assistance, please contact the Systems Administrator, Frank Taylor at [email protected] - 617-790-3093. ** REMEMBER NEVER OPEN AN ATTACHMENT UNLESS YOU ARE SURE OF IT'S CONTENT AND SENDER ** _______________________________________________________________________ --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
