We found the best way is to have all the logic in databasic. Call a subroutine to return the data you want. This can be tested before it is used within VB.
Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: 02 June 2008 22:44 To: u2-users@listserver.u2ug.org Subject: [U2] UV objects question We have a VB process that looks for a record in a set of files PRINT.TODAY (today's file), PRINT.HIST.0508, PRINT.HIST.0408 etc. If the record is not in those files it reads a file called INTERIM.LETTERS. Once the data is found a IE html document is displayed to screen. We keep the date in the record id, so a record written today would first try the PRINT.TODAY file, then the PRINT.HIST.0608 (which does not get created until after 5 pm on the first business day of the month), then the INTERIM.LETTERS file. Each night after 5 pm all data in the file PRINT.TODAY is moved to current month year file. Tonight it would be the PRIINT.HIST.0608 file, normally it would find that the file isn't there and create it. On the first business day of the month, this file has not yet been created and when the process gets to that file something is happening that causes the next file INTERIM.LETTERS to be skipped. When they decided the problem must be that the file is not there yet and had me create the file, the problem went away. Our VB programmers say they have checked every error they can think of and the process is not returning an error that they can recognize. What error would be returned when a program tries via UV Objects to read a file that does not exist? Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ <html> <head> <meta http-equiv="Content-type" content="text/html; charset=UTF-8"> </head> <body> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. </SPAN></P> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. </SPAN></P> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. </SPAN></P> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. </SPAN></P> </BODY> </HTML> ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/