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 SkipVought 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. hilfendorf

    Turn variable into a string

    Try this. I'm not sure it works but it should. WHERE (MONAT EQ EDIT(&MONAT)) OR (MONAT EQ EDIT(&MONAT1)) The simple EDIT() (with no mask) turns numeric to character and vice-versa. Not sure if it works with &parameters.
  2. hilfendorf

    Multiple ODBC data sources

    Try this in a fex when you sart a session or at any time in a focexec when you need it : SQL SQLODBC SET USER ODBC1 SQL SQLODBC SET USER ODBC2 SQL SQLODBC SET USER ODBC3 -RUN; where THE ODBC1/2/3 are DSNAMES implemented via Control Panel / Data Source(odbc) in Windows
  3. hilfendorf

    Single display of Multiple reports

    1/ Save them in HTMLTABLE format 1ST REPORT "ON TABLE HOLD AS 'XXX' FORMAT HTMLTABLE" 2nd REPORT "ON TABLE HOLD AS 'YYY' FORMAT HTMLTABLE" 2/ AT THE END PUT THESE LINES WHERE abcdef IS AN HTML FILE NAMED abcdef.htm END -RUN; -HTMLFORM abcdef abcdef.htm is a usual html...

Part and Inventory Search

Back
Top