Search results for query: *

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.

Ok ..... here is my situation. I have an excel spreadsheet with data in it from A1-X700 I found the below macro to put out the cells with " around the data in each cell. The below macro works great ...... but I would like to modify it not to put " around data in certain columns. For example I...

Thanks for the reply jocasio ...... I have done exactly what you said already ..... that is what I was trying to describe ..... what I am trying to do is improve my piping and redirection skills ..... I am of the belief that the script I put in this post could be done in one command(with piping...

Can anyone tell me how to do this little script on the command line in one command? Its function is to find files containing certain text that is passed to it and the "ll" the files. Say this script is called "fnd" its usage is fnd text ---------------------------------------...

This database was designed in Access97 some time ago ..... it recently hit the 1Gb limit and crashed ..... I basically created a new database in Access2000 .... transferred the data etc ..... had to change a couple of design issues and all is good so far except that this autonumber is not...

anybody know an easy way to set an autonumber field to a specific value? I searched MS, and found some info, but have not been able to get it to work. Access 2000 ..... autonumber field is primary index of table.