Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CoolDudeeh

    Century Parameter

    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?
  2. CoolDudeeh

    Replace certain characters in column that is primary key

    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...
  3. CoolDudeeh

    Replace certain characters in column that is primary key

    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...
  4. CoolDudeeh

    "entry" question - does entry exist?

    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...
  5. CoolDudeeh

    Looking for Suggestion how to handle

    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...
  6. CoolDudeeh

    "File Manager/File Selection"

    HelloMike, Thanks for the information. Very much appreciated.
  7. CoolDudeeh

    "File Manager/File Selection"

    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
  8. CoolDudeeh

    convert UNIX formfeed to word page break?

    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...
  9. CoolDudeeh

    convert UNIX formfeed to word page break?

    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...
  10. CoolDudeeh

    Unix maximum file size exceeded (303)

    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...
  11. CoolDudeeh

    Comparing tables ---- I thought this would be easy

    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...
  12. CoolDudeeh

    Problems with Alert

    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
  13. CoolDudeeh

    Question Regarding Contacts

    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...
  14. CoolDudeeh

    Question Regarding Contacts

    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...
  15. CoolDudeeh

    Excel Macro Help

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

    Excel Macro Help

    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...
  17. CoolDudeeh

    trying to improve my pipes and redirection

    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...
  18. CoolDudeeh

    trying to improve my pipes and redirection

    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 ---------------------------------------...
  19. CoolDudeeh

    re-setting autonumber fields

    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...
  20. CoolDudeeh

    re-setting autonumber fields

    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.

Part and Inventory Search

Back
Top