eduff Posted March 16, 2012 Share Posted March 16, 2012 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?ThanksCode:MID(part.description,8,3) as grade Link to comment Share on other sites More sharing options...
jpauze Posted March 19, 2012 Share Posted March 19, 2012 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 More sharing options...
eduff Posted March 20, 2012 Author Share Posted March 20, 2012 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now