Jump to content
Changes to the Jaspersoft community edition download ×

SQL Functions


eduff

Recommended Posts

Need help,  Trying to use MID or SUBSTRING function in SQL query on Fishbowl database and it's telling me the function is unknown.  I can use LEFT and RIGHT functions with no problems. 

If I connect to an Microsoft Access database the functions work.

I am connecting to fishbowl use Firebird driver,  org.firebirdsql.jdbc.FBDriver.

Is there any other settings that need to be added?

Thanks

Code:
MID(part.description,8,3) as grade
Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Not familiar with Fishbowl but I know that MID is a function available in Access but not part of the ANSI standard (to the best of my knowledge) so at least with MS-SQL you would use the SUBSTRING Function which does the same thing.  Why SUBSTRING doesn't work in your case I can't comment on but the MID would be explainable.   Do you have a link to a site for any docs on Fishbowl?  I could take a look for you and see if i can figure anything out.

Jeff

 

Link to comment
Share on other sites

 Jeff,

Thank-you for your response.

 I found out yesterday I must only use Firdbird SQL commands, and MID is not included.  With SUBSTRING you must use the FROM and FOR syntax not commas.  It feels good to stop hitting my head against the wall. 

Edie

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...