Search options (Page 1 of 4)

hello Dmitry,  Mathias

Dmitry,

as noted before you dont understand my project so to include the whole thing would probably be fruitless. i do include a screen shot of the form i have questions about so you can get an idea of what i am talking about. as you can see, names appear several times down the list.  i want to clean the list up and show only the latest occurrence of a name.

Mathias,

is that a line i would put in the filter area of the tablegrid settings?

thanks for your help
lee

#10 and #13 are ascii for line feed and carriage return

lee

hi again Mathias

i dont know if this is what you want or not but its what i use and i think thats what its doing.

asset_name := SQLExecute('SELECT IFNULL(MAX(asset.asset_name),0)  FROM asset WHERE asset.id = 30000');

lee

and then think of a way all of us with below poverty level incomes are going to pay for all of it.

just my two cents

try changing line 23: futurval := Power((futurval DIV initialval),period) -1;
to read: futurval := Power((futurval DIV initialval),(1 DIV period)) -1;  he was using period and your formula calls for the reciprocal of period

Hi.
i think it should be OutputFuturevalue := InitalValue * Power((1 + GrowthRate), Periods);

the other way included initalvalue in the power and i dont think that is what he wanted.

lee

not going to be much hepin the coding department. i will try and get you started but you will have to look up the syntax of the for loop. i am assuming the ^ notation is a power like a number squared or cubed etc. anyway that is what the for loop does is take a number to a certain power.

set s = 1+r
set j = 1+r

for p= 1 to x-1
        n = j * s
         j = n
next p

y = a(j)

OutputFutureValue := InitialValue * (1 + GrowthRate) ^ Periods;

//CALCULATIONS
procedure Form1_Button3_OnClick (Sender: string; var Cancel: boolean);
var    //---> First declare your variables (pay attention to the type, integers take no decimals, real can have decimals and so on ...)

    //INPUT VARIABLES
    InitialValue : Currency;
    Periods, GrowthRate,s, j, n, p : Real;

    //OUTPUT VARIABLES
    OutputFutureValue : Currency;

begin
    //---> Second, assign the variables you have declared to your edit fields
    //Input Variables
    InitialValue := Form1.EdInitialValue.Value;
    Periods := Form1.EdPeriods.Value;
    GrowthRate := Form1.EdGrowthRate.Value;

    if (Trim(Form1.EdInitialValue.Text) = '') OR  (Trim(Form1.EdPeriods.Text) = '') OR  (Trim(Form1.EdGrowthRate.Text) = '') then //if any of the field is empty
        begin
            Cancel := True; //Stop the operation
            ShowMessage('All fields marked with an asterisk (*) are required. Calculation can only be performed when all required fields are filled.'); //display the warning
        end

    else //None of the fields are empty, let's continue
        begin

            //---> Third, perform your calculations
                        s := 1 + GrowthRate;
                        j := 1 + GrowthRate;
                        for p := 1 to (periods - 1)
                                  n := j * s
                                   j := n
                         next p;
                         OutputFutureValue := InitialValue * j;
//like i said, i am not sure of the coding and i am assuming ^ is a power symbol. i dont recal having run ito it before so i am not sure. hope this was of some help

lee
                        OutputFutureValue := InitialValue * (1 + GrowthRate) ^ Periods;
                        Form1.EdOutputFutureValue.Value := OutputFutureValue;

i have a table venue. i use this command>;
sqlexecute('insert into venue values ("'+8 Ball+'")');
i get an error ) expected at 5:47
where am i going wrong?

lee

hello again Dmitry

my project in its basic form is not all that complicate and would apply to almost any sport. almost every sport has a national organization running it. under it are the various areas represented (my leagues). each area represented has its teams that play and the members that play on the team. there are reports of all the team members, the team statistics and player statistics. my project in a nutshell manages everything from the area to the reports. i submitted my erd the way i thought it should be. if that met with your approval i could get on with my project and my  questions could be more specific to a particular problem i am having at the time.

thank you again for your help for me and the others

lee

can i get a answer to my last post