[firebird-support] Inserting/Updating new records with data from previous records

2017-03-24 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
Hi all, I hope you can help me with this. I have a customer who scans barcodes to produce delivery notes. There may be several barcodes per part to produce one line on the delivery note. The quantities can vary - if there is insufficient raw material or their customer needs them immediately.

RE: [firebird-support] Firebird Backups on Google Compute Engine

2017-03-24 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> We are considering moving our systems to GCE and trying to figure the best > approach to backup our many firebird databases. > Firebird is not VSS aware so we can't use shadow copying. Not completely true. 1- Firebird uses careful write order, so a VSS snapshot should be a valid database

[firebird-support] Firebird Backups on Google Compute Engine

2017-03-24 Thread rud...@gmail.com [firebird-support]
We are considering moving our systems to GCE and trying to figure the best approach to backup our many firebird databases. Firebird is not VSS aware so we can't use shadow copying. On our current host, we create backups of every single database with gbak daily - which consumes a lot of time

Re: [firebird-support] using a stored procedure to return the value for an existing field in the table

2017-03-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.03.2017 17:26, av...@telusplanet.net [firebird-support] wrote: > is there a way i can write a StoredProcedure or trigger to have the "code" in > the database > return that value i want for the existing column and not just return the > table data for > that column? Create a new table, pump

RE: [firebird-support] reset sysdba password without loose existing users

2017-03-24 Thread startx252...@yahoo.fr [firebird-support]
OK that's sound me more clear. just another question : can i modify de sysdba password in this case with gsec ?

RE: [firebird-support] reset sysdba password without loose existing users

2017-03-24 Thread startx252...@yahoo.fr [firebird-support]
Ok, so must i need to download an ambeded firebird server ? - I just read the documentation and it's seems a little bit complexe to install

RE: [firebird-support] reset sysdba password without loose existing users

2017-03-24 Thread talorigo...@yahoo.co.uk [firebird-support]
What you'll need to do is to download the firebird embedded edition and unzip it into a folder. If you are going to try to change the password from the command prompt you'll need to copy the isql.exe file from your original installation into the folder where you unzipped the embedded version.

Re: [firebird-support] Ryzen R7 vs Kaby Lake 7700K, which one to choose?

2017-03-24 Thread Daniel Rail dan...@accra.ca [firebird-support]
Hi, At March 24, 2017, 5:22 AM, Doychin Bondzhev doyc...@dsoft-bg.com [firebird-support] wrote: > Hi, > I just got my last piece (the motherboard) for my new Ryzen system. I'll > install all the software during the next few days and will write back > here about my experience with FB. > I'm

Re: [firebird-support] Ryzen R7 vs Kaby Lake 7700K, which one to choose?

2017-03-24 Thread Doychin Bondzhev doyc...@dsoft-bg.com [firebird-support]
Hi, I just got my last piece (the motherboard) for my new Ryzen system. I'll install all the software during the next few days and will write back here about my experience with FB. I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the storage (RAID 10 with 6 HDD) so I