Recent

Author Topic: solved : ODBC Error  (Read 1909 times)

Deepaak

  • Sr. Member
  • ****
  • Posts: 454
solved : ODBC Error
« on: October 23, 2017, 05:51:35 am »
ODBC Error: Incorrect Syntax near the Keyword Join.
MSSQL SERVER

Code: Pascal  [Select][+][-]
  1. Query1.SQL.Add('SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate' +
  2. 'FROM Orders' +
  3. 'INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID');
  4. Query1.Open;
« Last Edit: October 23, 2017, 05:56:38 am by Deepaak »
Holiday season is online now. :-)

engkin

  • Hero Member
  • *****
  • Posts: 3112
Re: ODBC Error
« Reply #1 on: October 23, 2017, 06:08:41 am »
Your code will produce the following text:
Quote
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDateFROM OrdersINNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID

See the problem?  😒

Deepaak

  • Sr. Member
  • ****
  • Posts: 454
Re: solved : ODBC Error
« Reply #2 on: October 23, 2017, 06:27:40 am »
Thanks.... Got it...
Holiday season is online now. :-)

 

TinyPortal © 2005-2018