Once again thank you. I am very sorry it has taken me so long to reply.
On 20/05/15 21:19, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
1) Re the separate database: nobody said you shouild do it from your
own. I'd do it in the client, once the original data has been ins
On 20/05/15 21:15, Alexandre Benson Smith ibl...@thorsoftware.com.br
[firebird-support] wrote:
In this way wouldn't the SP have the same problem that was mentioned
by Louis, namely that only the index from the first table in the
query would be used?
I did not read it in full details...
B
You welcone :)
A few points:
1) Re the separate database: nobody said you shouild do it from your own.
I'd do it in the client, once the original data has been inserted.
2) Security: rule 1 is *TRUST NO-ONE*.
3) How many blobs *per user* are you going to have?
4) Once you have downloaded the blo
On 20/5/2015 16:03, Mike Ro miker...@gmail.com [firebird-support] wrote:
Thank you for your response.
On 20/05/15 11:25, Alan J Davies alan.dav...@aldis-systems.co.uk
[firebird-support] wrote:
Another way of doing what you want would be to use SPs instead of Views.
Then if you "select * fro
Thank you for your reply!
On 20/05/15 11:12, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
On the other hand, having all fields in all tables means you do not
have to do a join, which means you can have a richer and
more complete overview of something directly on your main
Thank you for your response.
On 20/05/15 11:25, Alan J Davies alan.dav...@aldis-systems.co.uk
[firebird-support] wrote:
Another way of doing what you want would be to use SPs instead of Views.
Then if you "select * from SP" and hide it as below, no-one can see what
you are doing with the data.
Another way of doing what you want would be to use SPs instead of Views.
Then if you "select * from SP" and hide it as below, no-one can see what
you are doing with the data.
This works well and I drop this into every new database I work on. To
repeat the warning though - make sure you have a c
Hi!
Here are my opinions; please feel free to point out any inaccuracies.
On Tue, May 19, 2015 at 11:35 PM, Mike Ro miker...@gmail.com
[firebird-support] wrote:
>
>
> I am creating a database that consists of 30 - 40 tables.
>
> Each table stores a specific set of data which has a specific set
Thank you for this very useful response.
On 20/05/2015 08:17, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] wrote:
Yes FB is a RDBMS and not OO DB. In a previous project I used
‘inheritance’ where I put common fields in a ‘base’ table and other
fields in a ‘derived’ table and then
Q1: We have an application with around 400 table and we use this structure for
all tables. I.e. apart from the payload columns, all tables have these
housekeeping fields. However our app framework populates these tables as the
app logs in with it’s own single user. Due to a complex security and
10 matches
Mail list logo