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 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. wolfen1842

    ODBC Error when reading with Dates.

    Never mind. I figured it out. The formating on the date HAS to be yyyy-MM-dd. I had one digit for the month and for the date.
  2. wolfen1842

    ODBC Error when reading with Dates.

    HEre is the select statement I am using: SELECT SUM(Amount) AS Paid FROM PR_23PerptHistoryDetail WHERE Dept = '99' AND EmployeeNumber = 'BARTKIM' AND (CheckDate > {d '2007-2-4'} AND CheckDate < {d '2007-2-11'} ) AND (EarningCode = '90' OR EarningCode = '97') When this code runs, I get an...
  3. wolfen1842

    Reading MAS 200 table in VB using Dates

    I am trying to read a MAS 200 table in a VB.Net program to create a report. If I include the date in the "Where" statement, I get an error. If I don't include the date, I get data, and then have to go through each record to find the particular date I need. Is there a way to read for the date in VB?
  4. wolfen1842

    Error when reading Mas 200 table in VB .Net

    I am trying to pull some data from Mas200 into a report that is generated in VB .Net. This report will have a separate line for each agent and each week. Here is the code I am using for the read: dsEmp.Clear() lsEmp = "SELECT SUM(Amount) AS Paid " & _ "FROM PR_23PerptHistoryDetail " & _...

Part and Inventory Search

Back
Top