Question Re: Help with Syntax error in Technology Q&A

Help with Syntax error

Former Member — Thu, 16 Aug 2018 10:27:59 GMT

Sorry if this first post isn't enough information to go on, I'm a bit out of my element so please forgive my lack of protocol.

I'm trying to research a problem we have run into and as no one here has any sybase knowledge we just are unsure where to turn to in order to find a resolution. So the basic outline is we are trying to use an odbc connection that we setup using the sqlanywhere 16 driver, we can get the data we need via the tables, so the connection works. Now here is where we are lost, there is a need to use a function that is on the server, when we do so we get a syntax error near 'dba' on line 1.
"dba.fn_GetShpLbrCostPart(" & "'" & {company.company_code} & "'" & ", " & ToText({shp_line.pks_num},0,"") & ", " & ToText({shp_line_src.cust_po_line_num},0,"") & ", " & "'L');";

Regrettably we are in a jam over this and just hoping someone out there can throw us a preserver if you will.

Re: Help with Syntax error

chris_keating — Thu, 16 Aug 2018 11:29:20 GMT

Have you tried:

select * from dba.fn_GetShpLbCostPart...

-or-

set var = dba.fn_GetShpLbCostPart

where var is declared as a valid return type for the function.

Re: Help with Syntax error

Former Member — Thu, 16 Aug 2018 14:33:01 GMT

I have probably left out something here, the formula above returns dba.fn_GetShpLbrCostPart('1', 57398, 1, 'L'); so the returned data ('1', 57398, 1, 'L') is from the data and would need to be used by the function in order to do its job and return a cost number.

Re: Help with Syntax error

VolkerBarth — Thu, 16 Aug 2018 14:33:43 GMT

If this is a stored function, not a stored procedure, I would try to call

select dba.fn_GetShpLbCostPart...

Re: Help with Syntax error

Chris26 — Fri, 17 Aug 2018 02:14:58 GMT

Then maybe you need something like this

select *
  from company
       join shp_line on ....
       join shp_line_src on ... ,
       lateral(select ... from dba.fn_GetShpLbrCostPart(" & "'" & {company.company_code} & "'" & ", " &     ToText({shp_line.pks_num},0,"") & ", " & ToText({shp_line_src.cust_po_line_num},0,"") & ", " & "'L'))

Re: Help with Syntax error

Breck_Carter — Mon, 20 Aug 2018 09:00:29 GMT

What language is this? Crystal Reports?

Please show us the exact code, with the surrounding context, that is having the problem. Use copy and paste, do not re-type it.

Please show the entire exact error message, with the surrounding context. Use copy and paste, do not re-type it.

Thanks!

Re: Help with Syntax error

Breck_Carter — Mon, 20 Aug 2018 09:03:11 GMT

What language is this select written in? ...because in SQL Anywhere syntax the & operator is bitwise AND 🙂