For many of us English not native tongue :)

----- Original Message -----
From: "Mr. John" <mr_johnmr@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, August 18, 2007 11:01 PM
Subject: Re: [firebird-support] Righ way of doing that ?


> 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@...>
> To: firebird-support@yahoogroups.com
> 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
>
> generate
>
> as many rows in tables as you need. That way you will be able to really
> test
>
> how
>
> your application behaves under more or less something that will be used in
>
> production.
>
> 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.
>
>
>
> Sasha
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> <!--
>
> #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{
> font-family:Georgia;
> }
> #ygrp-text p{
> margin:0 0 1em 0;}
> #ygrp-tpmsgs{
> font-family:Arial;
> clear:both;}
> #ygrp-vitnav{
> padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
> #ygrp-vitnav a{
> padding:0 1px;}
> #ygrp-actbar{
> clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
> #ygrp-actbar .left{
> float:left;white-space:nowrap;}
> .bld{font-weight:bold;}
> #ygrp-grft{
> font-family:Verdana;font-size:77%;padding:15px 0;}
> #ygrp-ft{
> font-family:verdana;font-size:77%;border-top:1px solid #666;
> padding:5px 0;
> }
> #ygrp-mlmsg #logo{
> padding-bottom:10px;}
>
> #ygrp-vital{
> background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
> #ygrp-vital #vithd{
> font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
> #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{
> font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
> #ygrp-vital ul li .cat{
> font-weight:bold;}
> #ygrp-vital a {
> text-decoration:none;}
>
> #ygrp-vital a:hover{
> text-decoration:underline;}
>
> #ygrp-sponsor #hd{
> color:#999;font-size:77%;}
> #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{
> text-decoration:none;font-size:130%;}
> #ygrp-sponsor #nc {
> background-color:#eee;margin-bottom:20px;padding:0 8px;}
> #ygrp-sponsor .ad{
> padding:8px 0;}
> #ygrp-sponsor .ad #hd1{
> font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
> #ygrp-sponsor .ad a{
> text-decoration:none;}
> #ygrp-sponsor .ad a:hover{
> text-decoration:underline;}
> #ygrp-sponsor .ad p{
> margin:0;}
> o {font-size:0;}
> .MsoNormal {
> margin:0 0 0 0;}
> #ygrp-text tt{
> font-size:120%;}
> 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.
> http://autos.yahoo.com/carfinder/
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>