Re: Getting Error when selecting tables in data view ...
Hi All,
Im using ReportBuilder 10.02 with Borland Development Studio 2006.
Installed Componets: InfoPower Studio 2006 and Raize Components 4.1.
I seem to be having an issue when i select tables and setup there
relationship from within the data view.
Then when i press OK to confirm the tables i want to use and the
relationship i have setup i get this error.
Invailid SQL statement.
Incorrect Syntax near the keyword 'FROM'
I also get this error if i select one table and no relationship.
Ca someone please help because i have reloaded y delphi environment twice
and i cant work out whats going on.
Regards,
Trevor
Im using ReportBuilder 10.02 with Borland Development Studio 2006.
Installed Componets: InfoPower Studio 2006 and Raize Components 4.1.
I seem to be having an issue when i select tables and setup there
relationship from within the data view.
Then when i press OK to confirm the tables i want to use and the
relationship i have setup i get this error.
Invailid SQL statement.
Incorrect Syntax near the keyword 'FROM'
I also get this error if i select one table and no relationship.
Ca someone please help because i have reloaded y delphi environment twice
and i cant work out whats going on.
Regards,
Trevor
This discussion has been closed.
Comments
You need to be sure you select at least one field from each table you select
in order to have a valid SQL statement.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com