Morning "dice_in_trouble",
If I understand you correctly, you have or wish to have the following:
CLIENT TABLE:
CLIENT
DATE
BALANCE
ADDRESS
COLLECTIONS TABLE:
TIMESTAMP
PAYMENT
CLIENT
BALANCE
And if you update the client table you want the client and/or balance
updated on the collections
--- In firebird-support@yahoogroups.com, Norman Dunbar wrote:
>
> Morning "dice_in_trouble",
>
> If I understand you correctly, you have or wish to have the following:
>
>
> CLIENT TABLE:
>
> CLIENT
> DATE
> BALANCE
> ADDRESS
>
>
> COLLECTIONS TABLE:
>
> TIMESTAMP
> PAYMENT
> CLIENT
> BAL
Hi,
On 02/05/2013 10:47, dice_in_trouble wrote:
>
>
>
...
>
> Thanks Nrom for the reply. I also thought of this idea, wherein I make
> a separate table for the balance then link it up to the other 2
> tables. But I don't know how to make table relations. I am using
> flamerobin to build up my f
On 02/05/13 09:47, dice_in_trouble wrote:
> Thanks Nrom for the reply. I also thought of this idea, wherein I make a
> separate table for the balance then link it up to the other 2 tables. But I
> don't know how to make table relations. I am using flamerobin to build up my
> firebird database.
On 02/05/13 11:07, Norman Dunbar wrote:
> Start FlameRobin and comment to the database with the appropriate user.
Which should, of corse, read:
Start FlameRobin and connect to the database with the appropriate user.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61
--- In firebird-support@yahoogroups.com, "Werner F. Bruhin"
wrote:
>
> Hi,
>
> On 02/05/2013 10:47, dice_in_trouble wrote:
> >
> >
> >
> ...
> >
> > Thanks Nrom for the reply. I also thought of this idea, wherein I make
> > a separate table for the balance then link it up to the other 2
> >
--- In firebird-support@yahoogroups.com, Norman Dunbar wrote:
>
> On 02/05/13 09:47, dice_in_trouble wrote:
>
> > Thanks Nrom for the reply. I also thought of this idea, wherein I make a
> > separate table for the balance then link it up to the other 2 tables. But I
> > don't know how to make
On 02/05/13 11:15, dice_in_trouble wrote:
Hi Cedris,
> Thank you for this wonderful post. Will try this now. Thank you again.
You are welcome.
I suggest you purchase a book on Firebird, as has been suggested, or at
the very least, a decent beginner's guide to database design which will
help you
as I now understand it, if I restore the database with -USE_ALL_SPACE &
then do gfix -use reserve I will have a database which has all the static
data on full pages and the data that does change will quickly go back to
the 80/20 page usage. Something like 90% is static so I'm hoping this will
give
On 02/05/13 15:33, Nick Upson wrote:
> as I now understand it, if I restore the database with -USE_ALL_SPACE &
> then do gfix -use reserve I will have a database which has all the static
> data on full pages and the data that does change will quickly go back to
> the 80/20 page usage. Something lik
> as I now understand it, if I restore the database with -USE_ALL_SPACE &
> then do gfix -use reserve I will have a database which has all the static
> data on full pages and the data that does change will quickly go back to
> the 80/20 page usage. Something like 90% is static so I'm hoping thi
Interesting Ivan
And a cycle backup/restore doesn't force each row to keep in a single page?
If having a row in several pages causes bad performance it has sense trying
to keep that rows as grouped as possible. Or not?
Greetings.
Walter.
On Thu, May 2, 2013 at 11:11 AM, Ivan Přenosil wrote:
On Thu, May 2, 2013 at 11:11 AM, Ivan Přenosil wrote:
Many things that are very true and valuable. I would like to clarify one
thing:
>
> The problem is that UPDATE will never change
>
> record's location, it will stay on "it's" page "forever".
>
>
That is absolutely true, but possibly misleadi
On Thu, May 2, 2013 at 11:23 AM, W O wrote:
>
> And a cycle backup/restore doesn't force each row to keep in a single page?
>
Gbak backup makes a copy of the current version of all data in its backup
file. Gbak
restore creates a new database and populates it with that data. Records
all get new
Thank you very much Ann for your answer.
And I was talking about gbak's task, not mine, sorry for my bad English.
If having each record in one page is better than having a record in two or
more pages then have sense for me that gbak keep each record in just one
page when rebuilding the database w
Hello Ann:
As I understand it when a record is deleted a new primary version with a
mark (a flag) is put on it indicating that fact and the previous version of
the record is copied on another location (same page if there is room or
another page if there is not)
Is that true?
Greetings.
Walter.
Hi all.
I'm having a hard time figuering out - How to run a lengthy maintenance script
with builtin security (read abort option).
Inside an Execute Block I do an
for select do begin
EXECUTE STATEMENT
ON EXTERNAL
end
And I dont want the whole block to abort if it fails ...
Can anyone tell
Hi
I have a field defined as UTF8. In my app I am trying to write and read
data from the field. I am succeeding on some levels but need to need to
confirm that the data being written and read from the field is correct.
I thought I might put some data in using a tool I knew worked properly
I am a developer of accounting software and mostly learned my "trade" by trail
and error and from this forum. (Thanks for all the info and tips I receive
daily on this forum.)
Setup:
Delphi XE2 + DBX + Firebird 2.5x
Firebird mostly running on dual core pentiums, Windows XP/7 Pro.
Workstations
To give you my best answer I would need some more info about then complexity of
the triggers.
But Im going to try anyways.
I dont think the main issue is speed (I know that is what you wrote). But think
about it. Having the complex business rules in code will only slow down your
application -
Am 30.04.2013 14:18, schrieb Lepage, Pierre:
> Hi,
>
> We are using Firebird Client 1.0 on one or a lot of computers in the
> company.
>
> Actually, we analyze the situation because we plan to migrate every
> computers in the company from Windows XP to Windows7 64bits.
>
> We need to know if Firebi
>I am a developer of accounting software and mostly learned my "trade" by trail
>and error and from this forum.
>(Thanks for all the info and tips I receive daily on this forum.)
>
>Setup:
>Delphi XE2 + DBX + Firebird 2.5x
>Firebird mostly running on dual core pentiums, Windows XP/7 Pro.
>Workst
22 matches
Mail list logo