[firebird-support] update Firebird 2.1 to 2.5

2015-04-01 Thread miromiros...@yahoo.com [firebird-support]
Hi, I have to update my FB 2.1 to 2.5. (32 bit, win xp sp3). So, I did it. Now I have some problems with metadata update, any ideas how to resolve this, please. Invalid modify request. unsuccessful metadata update DEFINE FUNCTION failed attempt to store duplicate value (visible to active

Re: [firebird-support] Character sets. (Again.)

2015-04-01 Thread Tim Ward t...@telensa.com [firebird-support]
On 31/03/2015 20:00, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: On Mar 30, 2015, at 7:01 AM, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: Sorry about this, but I really can't work out what's going on here, and could do with some

[firebird-support] SQL Creation question

2015-04-01 Thread michael.vilhelm...@microcom.dk [firebird-support]
Hi I have two tables. They are not related in anyway. One table contains groups and the other contains suppliers Lets say they have this content GROUP = Group 1 Group 2 SUPPLIER Supplier 1 Supplier 2 Can I create a SELECT statement, which will

[firebird-support] Firebird, ODBC, MSACCESS

2015-04-01 Thread 'checkmail' check_m...@satron.de [firebird-support]
Hello @ll, I have already a big Problem with this combination, msaccess (all versions) and firebird 2 (testet with 2, 2.1, 2.5) and the actually odbc driver. First the constellation: Table a Primary Key year and number, so 2015 1, 2015 2, unique with main data for orders, one field is

Re: [firebird-support] Scope of uniqueness constraint?

2015-04-01 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Tim, Firebird constraints are evaluated immediately for the transaction. So that means that during constraint validation, it doesn't see other transactions, and due to it's immediate evaluation, you can't temporarily ignore validation for your transaction either. (eg: increase all PK

Re: [firebird-support] update Firebird 2.1 to 2.5

2015-04-01 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 09:28 p.m. 1/04/2015, miromiros...@yahoo.com [firebird-support] wrote: Hi, I have to update my FB 2.1 to 2.5. (32 bit, win xp sp3). So, I did it. Now I have some problems with metadata update, any ideas how to resolve this, please. Invalid modify request. unsuccessful metadata update

Re: [firebird-support] Character sets. (Again.)

2015-04-01 Thread Tim Ward t...@telensa.com [firebird-support]
On 31/03/2015 20:24, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: The problem is mainly that when the connection character set is UTF8, and the field character set is anything other than NONE or OCTETS, the server will return the field as UTF8. The length of a field in UTF8

RE: [firebird-support] SQL Creation question

2015-04-01 Thread michael.vilhelm...@microcom.dk [firebird-support]
So simple. Thank you

Re: [firebird-support] Scope of uniqueness constraint?

2015-04-01 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 1, 2015, at 5:51 AM, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: (1) Transaction 1 - check for EXXON, find it doesn't exist (2) Transaction 1 - create EXXON (3) Transaction 2 - check for EXXON, find it doesn't exist (because it can't see