Re: [firebird-support] Can Firebird coexist with Microsoft SQL Server 2005 Express?

2012-10-23 Thread Alexey Kovyazin
Hello Marc, Yes, Firebird can live with MSSQL. If you plan also to install there MS Exchange, I'd recommend to limit store.exe's memory consumption. Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) I have a piece of software that requires Microsoft SQL Server 2005 Express, and I am

[firebird-support] View output differs from straight SELECT output

2012-10-23 Thread Reinier Olislagers
Hi list, Firebird 2.5RC3 (Debian version) on Debian Squeeze Trying to calculate percentages and totals (and hoping I'm getting the expression right): SELECT runs.id, count(rv.name), ((count(tr.resultvalue))*100)/(SELECT COUNT(resultvalue) FROM testresults where testresults.testrun=runs.id) from

RE: [firebird-support] migrate mysql 5 php script to firebird 2.5

2012-10-23 Thread Hans
//Get records from database $result = mysql_query(SELECT * FROM people;); //Add all records to an array $rows = array(); while($row = mysql_fetch_array($result)) { $rows[] = $row; }

[firebird-support] Cannot restore a database because of failed unique key index

2012-10-23 Thread sir_wally_lewis
Hi, We use Firebird 2.5.1 on Linux 64 bit Firebird fails to restore because of a unique constraint( see below ). However when interrogating the data, no duplicate is found. ( see below SQL, unique key is on the grouped by fields ) How can this be? Kind Regards, Robert. SELECT ID_VN,