On Fri, 13 Aug 1999 14:07:18 -0300, "Giovanni Machado"
In what specific way is it not working? Are you getting an error? If so,
>1) Using a table, with the primary index 'COSTUMER_CODE', with the fields
>COSTUMER_CODE, COSTUMER_NAME, COSTUMER_PHONE and COSTUMER_CONTACT. I know
>how to use the Findkey metodh ( or property, I don't know ) . But, suppose I
>have one secondary index file ( called INDEX ) with two order keys,
>COSTUMER_CODE and COSTUMER_NAME. How do I change the order of the table ?
>Somebody told me I should use table1.IndexName:='INDEX', but it doesen't
>seem to work.
what exception type? What error message? If not, then how is it not
Which part is not working? Setting the TTable.IndexName property to the
name of the index? Or the subsequent use of an index-based search method?
What is the database type? Local or remote? Accessed through the BDE, ODBC,
a third-party replacement database engine, or ... ?
To total the value of a column, use the SQL function SUM on that column. To
Quote:>2) Supose I have a table with the folowing fields : Code, Name, Country,
>Phone and Debit ( this last, a money type ). How do I subtotalize this
>report by country ? I know I must use a Query component, but how ?
then make the totalling occur once for each logical group of rows, add a
GROUP BY clause the the SQL statement, the clause specifying the column on
which the subtotalling is to be based. The grouping column also needs to
appear in the SELECT clause of the SQL statement. For example:
SELECT Country, SUM(Debit)
GROUP BY Country
To create a variable that is global to the application, add a new unit and
Quote:>3) The first module of my application requests the user password. That
>password is validated in a Table of users, wich has the acess permition os
>each user ( who can do what in the system ). I would like to define some
>variables in that first module and use them along the execution of the
>applicattion. Just like a did in CLipper, publishing a variable and just
>using it in any other module.
define all such variables in the Interface section of that unit. For
example, a global variable named GlobalVar:
Any other unit that then includes this unit in its Uses section will then
be able to "see" the variable, set its value, and get its value.
Steve Koterski "You may already be a loser."
Felton, CA -- Form letter received by