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 Andrzejek 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. IanKidd

    Retreiving part of decimal in SQL Select

    I have a field that is a decimal - how do I use a SELECT SQL statement to retrieve only the amount before/after the decimal point? i.e. value is 4.55 I want to select "4" and "55". Thanks.
  2. IanKidd

    Corruption in onstat command

    Trying to investigate a problem with a program. When I look at the output from the "onstat" command, the "Last Parsed SQL Statement" display is corrupted. The output is "Last parsed SQL statement : 1 Õect " rather than showing an SQL statement. Any ideas...
  3. IanKidd

    Informix Date Comparison

    Yes, DBDATE is set to DMY4/
  4. IanKidd

    Informix Date Comparison

    No, the variable dteODueDate is definately a unique name.
  5. IanKidd

    Informix Date Comparison

    The following query within i4gl is not functioning correctly. The "dteOdueDate" variable is set to "31/05/2002" yet this query still returns a row where the prem_prmdue field is "24/07/2002". If I enter the query in the iSQL tool it works. It is 4GL that gives...

Part and Inventory Search

Back
Top