solved : ODBC Error
lazarus / 16-Databases

----------------------------------------------------------------------
Deepaak · 2017-10-23 03:51

ODBC Error: Incorrect Syntax near the Keyword Join.
MSSQL SERVER

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
Query1.SQL.Add('SELECT Orders.OrderID, Customers.CustomerName,
Orders.OrderDate' +'FROM Orders' +'INNER JOIN Customers ON
Orders.CustomerID=Customers.CustomerID');Query1.Open;

----------------------------------------------------------------------
engkin · 2017-10-23 04:08

Your code will produce the following text:
QuoteSELECT Orders.OrderID, Customers.CustomerName,
Orders.OrderDateFROM OrdersINNER JOIN Customers ON
Orders.CustomerID=Customers.CustomerID
See the problem?  😒

----------------------------------------------------------------------
Deepaak · 2017-10-23 04:27

Thanks.... Got it...