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!

  • Congratulations strongm 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. alastair3

    Weird glitches with high-detail ps file

    There's a fault with the code not the previewer. It appears that the angles have to work out to be more than one degree and of course there are 360 degrees in a circle, hence your max value is 359 lines.
  2. alastair3

    Another String Splitting Issue

    If you can find out what the character value of your box character is, something along the following lines should do the trick. There may be some bits which need tidying up as it's a relatively long piece of untested code. If the value of the character is say 7, then replace "?" with chr(7) and...
  3. alastair3

    Using Report footer formula in group

    Place the line whileprintingrecords; at the start of the formula and see if this gives you the results you are expecting.
  4. alastair3

    Duration Parameter

    If you want to use the start/end date parameters, all you would need to do is to set the duration to a default value such as "Unused" or "Use Start/End Date", then use the record selection formula as groggle suggested with the following addition: if {?Duration} = "Daily" then {DateField} >...
  5. alastair3

    Currency type conversion from SQL

    I'm aware that there are any number of tools and ways for obtaining data type information from the database, but that isn't the problem. The problem is the the type they get translated to in Crystal and how that is determined. We run the reports against a number of databases, with an automatic...
  6. alastair3

    Currency type conversion from SQL

    I know there's a particular problem with this one field. I was interested to find out from how Crystal interpreted SQL data types to alert me if there were any other fields which might have a problem. That would have been useful as we have a very complicated schema and 100's of reports that are...
  7. alastair3

    Currency type conversion from SQL

    Thanks for the suggestion. That would certainly be more effective. Does anyone have any idea how Crystal determines it's own 'field type' for a given field?
  8. alastair3

    Currency type conversion from SQL

    I have two SQL databases, which are supposed to be identical, however there is a subtle difference with the schema definitions during initialization, which means that in one database, one particular field is type "money" and in the other it is "dt_money_gr_cy" In Crystal 9 these are viewed when...
  9. alastair3

    Mirroring Drives on a SunBlade 150

    If you're doing manual duplicating via a cron, then it's a lot quicker to use rdist than dd.
  10. alastair3

    Assigning command returns to a variable

    Why bother with a variable? You can always just run the command vi `ls -rt | tail -1` to edit the most recent file in a directory. If that's all you want to do you could set that up as a script or even as an alias.
  11. alastair3

    Permanent creation of Alias

    If you're running a C shell (csh) rather than a Bourne (sh) or Korn (ksh) shell, then you'll need to put them in .cshrc instead of .profile in your home directory.
  12. alastair3

    Solaris Keyboard Behavior

    So you're using the same keyboard on both Solaris boxes? Suprising, Solaris is normally pretty good at detecting the right keyboard layout to use, but I guess not in this case. To remap the keys on one of the systems you'll need to use xmodmap. You can pick up the current keycodes that are set...
  13. alastair3

    output of vi during RSC or tip session

    Whenever I hit terminal type problems with a cu/tip connection on the editing front, I just use the standard line editor 'ed' rather than vi.

Part and Inventory Search

Back
Top