I’ve encountered similar errors where the database you are accessing isn’t
compatible with Firebird version you are running. It appears like the database
is a ODS (on disk structure) 10.0, which is Interbase 6/Firebird 1.0 and the
installed Firebird version is 12.2, which is a version of
Thanks for the help. That syntax worked.
Also, I hadn’t thought about the city possibly having a space in the name… At
least for now, it appears the data doesn’t have a city with more than one word.
Thank you!
From: firebird-support@yahoogroups.com
Sent: Thursday, October 10, 2019 7:17 AM
Hello All,
I could use some help/direction with splitting (or extracting data between
certain characters in) an existing string. This is generally a simple task in
code using IndexOf, LastIndexOf, etc. but I can't seem to figure out the syntax
in Firebird SQL (and it has to be done in SQL
