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 TouchToneTommy 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: *

  • Users: lvdm
  • Order by date
  1. lvdm

    Topspeed ODBC and SQL query

    No problem. I saw that this is a general problem with Topspeed/Clarion, they never provide any help or example when it comes to things like this. You pay a lot of money for the TPS ODBC drivers, but with NO HELP... go figure. I used Clarion for the last 5 years successfully, but with LOTS OF...
  2. lvdm

    Topspeed ODBC and SQL query

    Hi, This should do the trick... Added a bit more just to show whats possible. Select i.invdate, {fn dayofyear(i.Invdate)} AS B, {fn CurDate()} as Date , OrdH.OrdNo FROM Invh i,{OJ OrdH LEFT OUTER JOIN Invh ON Invh.OrdNo = OrdH.OrdNo} Where i.Invdate = {d'2003-06-05'}

Part and Inventory Search

Back
Top