Recent content by CoolDudeeh

currently our century parameter is set to -yy 1920. This is starting to create some issues in our software(QAD) What do I need to do to get to the default of -yy 1950 Is it just a matter of changing the client scripts? Do I have to recompile all the code?

Thanks for the reply. Here is what I am getting. I am thinking that there are records that once the special characters are out, it is matching a record that already exists? Any suggestions? or ideas? Have tried that and I get a message like SQL execution error Executed statement: Update parts...

I am trying to replace certain characters in a column that happens to be the primary key for the table. Here is some data 123-123-4576 asd qwert qawer asd/lkjljk asd'wert-zxcv I would like to eliminate the " " "/" "'" and "-". I am ok with running the query multiple times - once for each special...

Say I had some code like this that is reading the flat file below if entry(5,recordin,",") = "e" then assign entry(5,recordin,",") = "z". on record 2, I get an error something like "entry 5 is outside the range ..." Is there a way to test for the existence of an entry or the number of...

I am importing a stream(instr) from a flat file that might look like this. A*12*2*3*4 B*1*22*3*4 C*1*2*3 D*11*2*33*4 Record A,B,D all process fine. Record C does not seem to do the if or else. I am looking for a way to handle. Any suggestions? (index?) In my program I have something like if...

HelloMike, Thanks for the information. Very much appreciated.

Does anyone know a quick way to prompt user for a file with "file manager" type screen so the user can select a file. Like in the character progress editor(File Open). 91e character on UNIX

Thanks for the replies so far. In response to the replies so far. 1. The report containts lots of legitimate _ so the scan and replace option will not work. 2. The file in not being ftp'd .... it is being emailed in the body of the email from the unix box. The copy and pasted into word. When...

Here is the situation. I receive emailed reports from a UNIX box. The reports have the unix formfeed character which shows up as a small character box() in notepad or a reverse image FF in some other editor I have. Decimal = 12 Hex = C Octal = 014 When I open the report in Word, it converts...

I am receiving this progress error from a progress application(progress v9.1E). I was under the impression the progress had removed the 2Gb limit with progress version 9. For example, I do have database extents that are 4Gb in size. Is there maybe a limit to an individual table being 2Gb...

I am trying to compare records in 2 databases. The table names and fields names are the same in both. For example. Lets say db1 and db2. I want to go through db1, table1 and find the same record in db2 table1. If the record is not found in db2, I want the record used to find it displayed. I...

Background info Windows server 2003 Arcserve 11.1 Alert v7.1 Alert Service seems to be working. I am trying to get some alerts to work. In the alert log, i see sending broadcast Failed to send broadcast(2273) or sending SMTP Failed to send SMTP(80000001) Does anyone have any ideas

Pascal, Thank you for your response. I have actually replicated the server NAB to my local drive already. It is still frustrating with a huge(60,000+ entries) NAB For example ..... say I work locally with a Bob Jones ..... so I type Jones into the "to" of new memo and it starts suggesting 1 of...

Does anyone know if there is a way to get all the contacts in a group on a domino server, to the individual contacts in my local contacts list. Example ...... group on server has 100 names in it. I want 100 individual names in my personal contacts not just the group contact . Notes 6.5.2 Should...

Thank you skip and PH!!!!! Worked like a charm.