Ok, thanks for clarifying. I will give D.Record a try. Since I will only have to use it once at the start of the file processing I don't suspect it will slow things down that much for me.
Thanks for you help today! Orlando Maldonado Systems Financial Analyst Central Accounting Office Methodist Healthcare System Tel: 210.575.0293 Fax: 210.510.6444 Mail: [email protected] From: [email protected] [mailto:[email protected]] Sent: Monday, January 20, 2014 3:47 PM To: [email protected] Subject: RE:[talkbws] Datastation Record Navigation For what you are describing, yes it does since you're jumping backwards. If I was writing something that needed to process something like what you describe, I'd store the fields in variables as opposed to jumping back and forth - especially if this was time sensitive thing - e.g. needed maximum speed. Thom C. Blackwell, VP Technical Services Boston Software Systems, Inc. Phone: 866.653.5105 x807 Mobile: 508.423.8463 Fax: 508.319.3015 www.bostonsoftwaresystems.com<http://www.bostonsoftwaresystems.com/> Healthcare Automation - Revolutionizing How You Work. The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Monday, January 20, 2014 4:13 PM To: Talk Subject: RE:[talkbws] Datastation Record Navigation Thanks Thom, That is a useful tip. Does the note in the help file apply with this approach? "However if you set the Record property to a value that is lower than the current Record, the file is closed, re-opened, and then scanned to the requested record number." My script is reading from Excel file and first needs to key the value located in G3 into my Rumba application. So I used D.Next to get to record three. Now I need it to go back to the second record to continue keying the rest of data which sits in columns A-F. I was concerned that using D.Record will hinder script performance if it has to close and reopen the file. Orlando Maldonado Systems Financial Analyst Central Accounting Office Methodist Healthcare System Tel: 210.575.0293 Fax: 210.510.6444 Mail: [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Monday, January 20, 2014 2:59 PM To: [email protected]<mailto:[email protected]> Subject: RE:[talkbws] Datastation Record Navigation Hi, D.Record will tell you what record you are currently on, but you can also set D.Record in order to jump to a particular record. e.g D.Record=10 would jump to record 10. So if I was on a record of interest, I could store D.Record F("MyInterestingRecord")=D.Record Do any number of D.Next_ 's And go back using D.Record= F("MyInterestingRecord") Regards, Thom Thom C. Blackwell, VP Technical Services Boston Software Systems, Inc. Phone: 866.653.5105 x807 Mobile: 508.423.8463 Fax: 508.319.3015 www.bostonsoftwaresystems.com<http://www.bostonsoftwaresystems.com/> Healthcare Automation - Revolutionizing How You Work. The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Monday, January 20, 2014 3:54 PM To: Talk Subject: [talkbws] Datastation Record Navigation I know D.Next takes you to the next record in your datastation. But how do you navigate back to a specific record or specific number of records in the datastation? I am using a Rules Based Script that connects to Rumba (HLLAPI). Thanks, Orlando Maldonado Systems Financial Analyst Central Accounting Office Methodist Healthcare System Tel: 210.575.0293 Fax: 210.510.6444 Mail: [email protected]<mailto:[email protected]> --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx
