Subject Re: [firebird-support] Righ way of doing that ?
Author Mr. John
Thanks.Sorry,I've answered from my friend account but yahoo delay it,sorry for using "things",english is not my language.I'll take all advices. Many thanks !

----- Original Message ----
From: sasha <selectnull@...>
Sent: Saturday, August 18, 2007 8:24:07 PM
Subject: RE: [firebird-support] Righ way of doing that ?

> Thanks for your advices.

> For my problem "stock management" is management of IN and OUT

> things.

When you say things, and you mean something specific that you have

already modeled in your database but you want to be abstract in your

communication, then it's fine. But, if you really mean literally "things"

in my experience that's recipe for trouble. You do not manage things,

you manage something that is semantically defined.

Of course, I might be completely wrong and you have modeled things

and it works for you, then it's also very fine.

> For stock I'll use a single table.Application has to

> create various reports like "In/out from 01/07/2007 to

> 31/07/2007" that's way I decided to organize stock by moth.

> I'll take a report example :


> In/out from 01/07/2007 to 31/07/2007

> ------------ --------- --------- --------- --------- --

> Id Begin quant.(on.01/ 07/2007) In Out Rest(on 31/07/2007)

> ------------ --------- --------- --------- ---------

> So, the stock is organized by months,it's true that depend of

> I/O of every day.

> Rest = Begin quant+In-Out.


Reporting is very easy if you have done your database model right.

When posting code try to use SQL and not some pseudo .Net code

because this group can really help you with SQL.

Another advice I would give you is to prepare sql scripts to insert random

but meaningfull

data into your tables. It should be set up in a way that enables you to


as many rows in tables as you need. That way you will be able to really test


your application behaves under more or less something that will be used in


That will also enable you to see problems with you SQL code in advance,

since it is very

easy to write SQL that gives you right results, but is totally useless

speed-wise when you

have 500.000 rows in a table. Differently written sql statement will also

give you results

but in much less time.



#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-vitnav a{
padding:0 1px;}
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
font-family:Verdana;font-size:77%;padding:15px 0;}
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
#ygrp-mlmsg #logo{

background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
#ygrp-vital ul li .ct{
#ygrp-vital ul li .cat{
#ygrp-vital a {

#ygrp-vital a:hover{

#ygrp-sponsor #hd{
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
#ygrp-sponsor .ad a{
#ygrp-sponsor .ad a:hover{
#ygrp-sponsor .ad p{
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}

Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.

[Non-text portions of this message have been removed]