Help with Syntax error

[Former Member]

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.

[chris_keating]

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.

[Former Member]

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.

[VolkerBarth]

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

select dba.fn_GetShpLbCostPart...

[Chris26]

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'))

[Breck_Carter]

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!

[Breck_Carter]

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