Re: [firebird-support] Rename table

this was the solution I proposed in first instance. Else what's in a name ? , if not what the table contains ? The VCL BATCHMOVE does it fast a seemlessly in one click, if field names are the same or if different then use the EMS components !!! 2017-07-17 11:48

Re: [firebird-support] Rename table

ertan.kucuko...@1nar.com.tr [firebird-support] <firebird-support@yahoogroups.com>: > > > > Sent from my iPhone > > On 16 Jul 2017, at 11:58, Alain Bastien alainbast...@gmail.com > [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > > Else *

Re: [firebird-support] Rename table

? Would there be ? regards 2017-07-16 11:41 GMT+04:00 Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support] <firebird-support@yahoogroups.com>: > > > > Sent from my iPhone > > On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com > [firebird

Re: [firebird-support] Rename table

ds > > > 2017-07-16 11:41 GMT+04:00 Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr > [firebird-support] <firebird-support@yahoogroups.com>: > >> >> >> >> Sent from my iPhone >> >> On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com >>

[firebird-support] Rename table

Create a new table with same structure from METADATA Use "Batchmove" (In Delphi VCL) with Delete Source enabled Connect the two tables, MOVE DATA Drop the empty table. COMMIT!!! This would take merely 15 minutes Alain Bastien 34, Dr Ross Avenue ROSE HILL 72102 MAURITIUS Skype:

[firebird-support] Connection rejected by remote interface

Hi, I have learn this bitter experience, Never MIGRATE unless the superior version has a feature which resolves a major issue. Alain Bastien 34, Dr Ross Avenue ROSE HILL 72102 MAURITIUS Skype: alainbastien Phone: 230 57 19 30 30 Res :230 464 68 30 Sent from iPhone Le 14 juil. 2017

Re: [firebird-support] Entity Relationship Diagram

https://www.idera.com/er-studio-data-architect-software On Sat, Apr 15, 2017 at 8:20 AM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Hello everyone > > Excuse me if it is an off-topic. > > Do you know some good

Re: [firebird-support] New auto-increment column, existing data

Use generators *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Tue, Nov 15, 2016 at 11:58 PM, 'Some One' anotherpersonsomewh...@mail.com [firebird-support]

Re: [firebird-support] Number of concurrent user connections

...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 29.10.2016 13:25, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: > > WEB application uses a BROWSER that's all > >No, they don't. Web-applications are executed on web-server. There i

Re: [firebird-support] Number of concurrent user connections

WEB application uses a BROWSER that's all It can connect to Static data or to a DATABASE *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Fri, Oct 28, 2016 at 8:15 PM, Elmar Haneke

Re: {Disarmed} Re: [firebird-support] Number of concurrent user connections

One thing is for sure YOU can't login FACEBOOK with two different IDs from the SAME PC at the same TIME. Or even (correct if I'm wrong) SAME ID on to different PCs There should be a UNIQUE field such MAC ADDRESS + IP + ID managed by the DATABASE in a TABLE !!! So there is a TABLE *Kind

Re: [firebird-support] Number of concurrent user connections

Skype:alainbastien* *Viber: 7320143* On Fri, Oct 28, 2016 at 1:33 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 28.10.2016 11:29, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: > &

Re: [firebird-support] Number of concurrent user connections

016 15:45, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: > > Isn't the connection the same ? > >No, they are completely unrelated. > > > Behind the WEB PAGE, if there is a login and Password, there is a > DATABASE > >Not necessary. Everything

Re: [firebird-support] Number of concurrent user connections

: 7320143* On Thu, Oct 27, 2016 at 5:39 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 27.10.2016 15:28, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: > > I was looking on FaceBook 'sDATA

Re: [firebird-support] Number of concurrent user connections

, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 27.10.2016 15:11, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: > > Is this factor the MAIN difference between DATABASE flavors ? > >No. Knowledge

Re: [firebird-support] Number of concurrent user connections

, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 27.10.2016 14:57, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: > > And in a WAN ? > >TCP/IP has no difference between LAN and WA

Re: [firebird-support] Number of concurrent user connections

com> wrote: > 27.10.2016 13:48, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: > > How many concurrent users can connect to a FireBird database on a > Windows 2003 Std Server > > (Pentium III 666Mhz) 2GB RAM ? > &g

[firebird-support] Number of concurrent user connections

Hi, How many concurrent users can connect to a FireBird database on a Windows 2003 Std Server (Pentium III 666Mhz) 2GB RAM ? *AlainBastien*

Re: [firebird-support] Looking for detailed documentation on the new Firebird 3 security authentication process.

And what about ROLES ? You can maintain USERS easily, else I never delete a USER since it might break referential integrity, just a FLAG (BOOL) active or inactive. *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien*

Re: [firebird-support] PR6036 - Win10 Firebird compatibility w/ Win 10

*Server System or Desktop Machine* Let's suppose I install Firebird 2.5 Server on a OcKel Sirius A (4GB LPDDR3-1600 RAM and 64GB of internal storage) Will there be a difference in performance and reliability if I use a Compaq

Fwd: [firebird-support] PR6036 - Win10 Firebird compatibility w/ Win 10

I would really advice ...IF you have real issues with Win 7 then do it on a Test Windows 10. Otherwise stay on Win 7 or Best of all Use Ubuntu 14.04 LTS or Ubuntu 16.04 LTS 64bit server and FLAMEROBINthese are great couples. *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill

Re: [firebird-support] GBAk - Restoring only data

better try Batch Move *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Wed, Sep 21, 2016 at 5:51 PM, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:

Re: [firebird-support] deploy Windows Application to access Firebird database

Hi, When I connect under my IDE RAD using FireDAC driver the syntax "compaq-proliant:c\DATA\MyData.fdb" works Only in FlameRobin it does not work. *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber:

Re: [firebird-support] deploy Windows Application to access Firebird database

for a local access with FlameRobin what is the syntax to connect to a LOCAL server *I can't get the right syntax under Windows !!* *I can PING, I can browse shared folders but can't connect to the firebird database* *the machine Server name is "compaq-proliant"* *OS is WIndows Server

Re: [firebird-support] Number of Firebird Users

I have INSERT about 10 records in a Table, the size of the FB Database grew up to 15MB I DELETE the records the size remains 15MB. After BACKUP and RESTORE thru FlameRobin then the size was reduce to 788Kb Is this normal ? or can it me done automatically within the settings and configs

Re: [firebird-support] Number of Firebird Users

ABout 100 simultaneous remote users may log in and insert data in a table via a stored procedure. Pentium III 667/133 Mhz 1.GB Ram WIll it be OK ? *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143*

Re: [firebird-support] deploy Windows Application to access Firebird database

Does it apply to remote servers also such as www.myserver.com:/opt/database/fbdata.fdb The release note README file in the embbeded zip says: // 2.2. Database access Client access can be only via the local protocol, i.e. *NOT a TCP/IP connection string that includesthe server

Re: [firebird-support] Number of Firebird Users

It has Windows 2003 R2 Server 6 x 18 GB SCSI Raid 4-5 *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Sat, Aug 27, 2016 at 9:12 PM, 'Leyne, Sean' s...@broadviewsoftware.com

[firebird-support] Number of Firebird Users

How many concurrent users may be created and connect to a FireBird database on such a Server * ?* *Compaq Proliant ML 370 G1* *Pentium III 667/133 Mhz 1.2GB RAM 256MB Cache * *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30*

[firebird-support] deploy Windows Application to access Firebird database

Hi What;s requred for the Windows app to access a remote Firebird database ? The minimal installation Thanks -- *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143*