RE: [EXT] [firebird-support] Re: Unrecognized Service Parameter Block during FbBackup.Execute

2019-11-19 Thread Ron Pillar ron.pil...@in-synch.com [firebird-support] 
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 Firebird 3.x.  
Generally, the database will need backed up (GBak) at version 10.0 (Firebird 
1.0) and restored at version 12.x (Firebird 3.0) to function properly.  The sub 
versions generally don’t matter.  E.g – a database at Firebird 2.1.3 can be 
backed up/restored at Firebird 2.1.7 without issues.

Here are two website explaining more:

http://www.firebirdfaq.org/faq80/

https://www.ibexpert.net/ibe/pmwiki.php?n=Doc.ODSVersion

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Monday, November 18, 2019 3:13 PM
To: firebird-support@yahoogroups.com
Subject: [EXT] [firebird-support] Re: Unrecognized Service Parameter Block 
during FbBackup.Execute


thanks for the hint!
I've installed version 3.0 and now I'm getting:

unsupported on-disk structure for file C:\DATA\DATABASE.FDB; found 10.0, 
support 12.2
IProvider::attachDatabase failed when loading mapping cache
No message for error code 336330835 found

from  FirebirdSql.Data.FirebirdClient.

nice improvement… :)

what's this error now?

HELP!

RE: [EXT] Re: [firebird-support] Help with splitting a string in Firebird SQL

2019-10-11 Thread Ron Pillar ron.pil...@in-synch.com [firebird-support] 
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
To: firebird-support@yahoogroups.com
Subject: [EXT] Re: [firebird-support] Help with splitting a string in Firebird 
SQL


Simple,

replace(reverse(substring(reverse(i.location) from position(' ', 
reverse(i.location, ' / - ', ' AT ' )

Though splitting on the last space would be a problem with cities having spaces 
in their names, e.g. New York (USA) or St Albans (England).

HTH,
Set

ons. 9. okt. 2019 kl. 00:14 skrev Ron Pillar 
ron.pil...@in-synch.com [firebird-support] 
mailto:firebird-support@yahoogroups.com>>:

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 unfortunately).  The string is 
stored in one field called “Location” and the results are being split into two 
columns (which are basically “ADDRESS” and “CITY”).

Here is an example of the data:  202 CLARENCE RAY DR CITYNAME

So far I’ve written this SQL (might be a better way to do this):
reverse(substring(reverse(i.location) from position(' ', reverse(i.location

Which returns:  202 CLARENCE RAY DR

And this SQL:
right(i.incident_location, position(' ', reverse(i.incident_location)))

Which returns:  CITYNAME

I thought that I had solved the problem…  Upon looking through the data for the 
“Location” field, I noticed that there appears to be intersections as well 
address information.  The intersections format is where I’m encountering the 
most trouble.  Here is an example of the intersection format:

- OLD HWY 11 / - OAK GROVE RD CITYNAME

I need to convert this data into a format like:   OLD HWY 11 AT OAK GROVE RD in 
one column and CITYNAME in a second column.  My right(i.incident_location, 
position(' ', reverse(i.incident_location))) should be sufficient for the 
CITYNAME, but I have no idea how to write the syntax to convert the first 
column.

Any help would be greatly appreciated!

[firebird-support] Help with splitting a string in Firebird SQL

2019-10-08 Thread Ron Pillar ron.pil...@in-synch.com [firebird-support] 
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 unfortunately).  The string is 
stored in one field called "Location" and the results are being split into two 
columns (which are basically "ADDRESS" and "CITY").

Here is an example of the data:  202 CLARENCE RAY DR CITYNAME

So far I've written this SQL (might be a better way to do this):
reverse(substring(reverse(i.location) from position(' ', reverse(i.location

Which returns:  202 CLARENCE RAY DR

And this SQL:
right(i.incident_location, position(' ', reverse(i.incident_location)))

Which returns:  CITYNAME

I thought that I had solved the problem...  Upon looking through the data for 
the "Location" field, I noticed that there appears to be intersections as well 
address information.  The intersections format is where I'm encountering the 
most trouble.  Here is an example of the intersection format:

- OLD HWY 11 / - OAK GROVE RD CITYNAME

I need to convert this data into a format like:   OLD HWY 11 AT OAK GROVE RD in 
one column and CITYNAME in a second column.  My right(i.incident_location, 
position(' ', reverse(i.incident_location))) should be sufficient for the 
CITYNAME, but I have no idea how to write the syntax to convert the first 
column.

Any help would be greatly appreciated!