Hi,
Could you please make FileMaker accept comments in calculated SQL function?
I just spent an hour trying to figure out why my 50 lines of SQL code was not working until I remove all comments.
Thank you
(Error: "The multi-part identifier could not be bound") for every fields in the SELECT)
copy/paste of the SQL instruction in the "Microsoft SQL Management Server" was working
David1060:
Our Development and Testing departments are aware of this limitation. The workaround is to add a carriage return and/or line feed to the embedded comment. For example:
ExecuteSQL ( "SELECT * FROM <table> -- This is a comment" & Char (13) ; "" ; "" )
I have added your post to the original report. When more information becomes available, I will post again.
TSGal
FileMaker, Inc.
Thank you! Do you know if that applies to multi-line comments as well:
" SELECT * FROM myTable /*comment goes here
and here*/" & Char(13)
OTOH, I usually make the comments outside the ExecuteSQL(), but since I may test by commenting out parts of the query, this is handy!
Beverly
Multi line comment has no problem, since it can be in line.
ExecuteSQL ( "
SELECT * /*get all fields*/
FROM Filemaker_fields
" ; "" ; "" )
But if use double dash
ExecuteSQL ( "
SELECT * --get all fields
FROM Filemaker_fields
" ; "" ; "" )
it become "syntax error", this is simple mistake writing text literal, there is no line break.
Using List() is a way to insert line break.
ExecuteSQL (
List (
"SELECT * --get all fields" ;
"FROM Filemaker_fields --from system table";
" ")
; "" ; "" )
I wondered that last comment also need CR. (So add a space in List() function)
OP looks not using ExecuteSQL function, ODBC to MSSQL. (then the error message is different)
It would help all of us test if you provide the following:
Product and version (e.g. FileMaker Pro 14.0.3)
OS and version
Browser and version (for WebDirect only)
Hardware
Description
How to replicate
Workaround (if any)
Posting the exact calculations would also help you get better answers.
Thank you,
Beverly