Thank you Philip for the answer. regarding option b) ... When I dynamically build the EXECUTE BLOCK it will have different columns number for each execution....
118639
Kok_BG
Jul 4, 2012 10:01 am
... Today i found a 64bit version of rfunk, which I've compiled before couple of years. Then I was unable to get it working on other machines, probably because...
118640
Alexey Kovyazin
alexey.kovyazin
Jul 4, 2012 10:04 am
Hello, There is a maintained fork version of rfunc http://www.assembla.com/wiki/show/audfl_rfunc Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) ... ...
118641
Aldo Caruso
aldo.caruso@...
Jul 4, 2012 3:31 pm
Hi, When I try to restore a backup done in a 2.5 firebird server to a 2.1 firebird server, I get the following error message: gbak:transportable backup -- data...
118642
Thomas Steinmaurer
iblogmanager
Jul 4, 2012 4:56 pm
... Are you using gbak from 2.1 against a 2.5 server and I hope you don't use any new/specific things from 2.5? -- With regards, Thomas Steinmaurer ...
118643
Dmitry Yemanov
dimitr_ex
Jul 4, 2012 5:43 pm
... Backward backup-restore is unlikely to succeed regardless. Dmitry...
118644
Thomas Steinmaurer
iblogmanager
Jul 4, 2012 6:11 pm
... Has this changed for the combination 2.1/2.5? AFAIK people successfully did that with 2.0/2.1? -- With regards, Thomas Steinmaurer http://www.upscene.com/...
118645
Aldo Caruso
aldo.caruso@...
Jul 4, 2012 6:59 pm
To restore, I am using gbak 2.1 against a 2.1 server, but reading a *.fbk backup file that was created using a 2.5 server. AFAIK I'm not using specific things...
118646
Alexandre Benson Smith
thoriblist
Jul 4, 2012 7:04 pm
Did you tried to use 2.1 gbak against 2.5 server to produce the gbk ? see you !...
118647
Aldo Caruso
aldo.caruso@...
Jul 4, 2012 7:11 pm
Good idea, but it is unfeasible for me because the server is remote on Internet (with very high latency), so I have to create the back ups on the server,...
118648
Helen Borrie
helebor
Jul 4, 2012 7:20 pm
... Then it cannot possibly work. Firebird does *not* support back-porting databases. It was found to be possible (sometimes) to backup and restore between...
118649
Leyne, Sean
seanchk_98
Jul 4, 2012 7:50 pm
... You could copy the v2.1 GBAK executable onto the remote machine, into a separate folder from the existing FB install. Then create a local backup using that...
118650
Aldo Caruso
aldo.caruso@...
Jul 4, 2012 8:15 pm
I have the first edition of your book, but nevertheless I got the idea. Thanks for your help. Aldo ... [Non-text portions of this message have been removed]...
118651
Aldo Caruso
aldo.caruso@...
Jul 4, 2012 8:16 pm
Thanks for your idea. Aldo ... [Non-text portions of this message have been removed]...
118652
Sergio
shg_sistemas
Jul 4, 2012 10:11 pm
... Thanks for the answer!! If memory serves, I think I read somewhere a post from Helen Borrie in which she says that is not a good idea... But can't find...
118653
Alexandre Benson Smith
thoriblist
Jul 4, 2012 10:15 pm
Are you sure you are not mixing it with using the database on Pen Drives ?...
118654
Sergio
shg_sistemas
Jul 4, 2012 10:56 pm
... Hi Alexande! thanks for the answer! May be... I'm not sure... But in any case, what would be the difference in having the database file on an USB HDD and a...
118655
trskopo
Jul 5, 2012 4:45 am
On my experience : 1) USB HDD : more reliable, more speed and more space. 2) Pen Drive : more compact. 3) RAM Disk : highest speed but risky and less space. Do...
118656
Alexey Kovyazin
alexey.kovyazin
Jul 5, 2012 4:56 am
Hello All, To let you know our opinion (from the point of view as recovery products ... USDB HDD can be used only for backups. Database should be on RAID1/5/10...
118657
Mahesh Pratihari
mahesh.pratihari@...
Jul 5, 2012 5:22 am
Hi , Could you please let me know for the syntax in FOR XML AUTO, ELEMENTS in SQL , what is the firebird compliance Thanks, Mahesh Pratihari Sonata Software...
118658
Thomas Steinmaurer
iblogmanager
Jul 5, 2012 5:35 am
... This is Microsoft SQL Server specific. There is nothing similar built-in into Firebird. There are tools out there which can help you to export data to XML....
118659
Dmitry Yemanov
dimitr_ex
Jul 5, 2012 8:26 am
... This is v2.5 specific. It was not intended, but it looks being unavoidable either. v2.5 names security classes in a way that prior versions don't accept. ...
118660
Thomas Steinmaurer
iblogmanager
Jul 5, 2012 8:28 am
... Alright. Makes sense. Thanks. -- With regards, Thomas Steinmaurer http://www.upscene.com/...
118661
hanszorn2000
Jul 5, 2012 1:21 pm
Hi, I am wondering if there are any known issues with queries within a trigger, when that query accesses the table on which the trigger fires (before insert,...
118662
mahdoom_a
Jul 5, 2012 1:24 pm
YESSSSSSSSSSSSSSSSSSSSSSSSS after the update to FB 2.5 and then backup & restore its wonderful,, appreciate it everyone svein_erling, iblogmanager,...
118663
Thomas Steinmaurer
iblogmanager
Jul 5, 2012 1:28 pm
... Can you post an example on what you are trying to accomplish? -- With regards, Thomas Steinmaurer http://www.upscene.com/...
118664
trskopo
Jul 5, 2012 1:50 pm
... Yes, Pen Drive is really not reliable, prepare to lost you data if you using this media, that why I said USB Hardisk is more reliable compare to Pen Drive...
118665
hanszorn2000
Jul 5, 2012 2:38 pm
... No problem! This is a simplified version of a trigger that fires Before Insert on table ARTICLE: declare LOCATION integer; declare ARTICLEID varchar(20); ...
118666
unordained
tigereye_philip
Jul 5, 2012 4:43 pm
... From: "un_spoken" <brucedickinson@...> ... You can (and must) dynamically create the returns() clause, to match. Your "template"; would therefore look...
118667
unordained
tigereye_philip
Jul 5, 2012 4:52 pm
... From: "hanszorn2000" <hanszorn@...> ... trigger, when that query accesses the table on which the trigger fires (before insert, so no race condition)....
