Board index » delphi » Calculate difference between a row and its row immediatly following it

nom...@nowhere.nospam (EBR)

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Calculate difference between a row and its row immediatly following it

Every time I need to do similar things, I don't use SQL. You must
write a procedural code.

SQL is wonderful in 90% of the cases, but there are situations where
SQL is not enough. Sometimes I create mixed solutions, with some SQL
statements and procedural code.

EBR

On Fri, 15 Aug 1997 08:48:01 GMT, aca...@wabang.com (Andrew Cates)
wrote:

Quote

>Well the subject isn't entirely clear.  What I would like to do is
>subtract a record from the record just below the first record and
>place the result in a resutl column in the first record that was
>subtracted.  I am just getting started in SQL and was wondering if
>anyone had any ideas.

>Andrew Cates
>Software Developer
>Wabang Creative Technology
>aca...@wabang.com

 
Andrew Cat

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Calculate difference between a row and its row immediatly following it


Well the subject isn't entirely clear.  What I would like to do is
subtract a record from the record just below the first record and
place the result in a resutl column in the first record that was
subtracted.  I am just getting started in SQL and was wondering if
anyone had any ideas.

Andrew Cates
Software Developer
Wabang Creative Technology
aca...@wabang.com

Other Threads

1. Row handle referred to a deleted row or a row marked for deletion

2. Row handle referred to a deleted row or a row marked for deletion

3. Moving current record to match row in SQL result table row

4. capture move from row to row in grid

5. capture move from row to row in grid

6. row in dataset from row in dbgrid

7. Extracting values from a dbgrid row by row

8. Updating master row when detail row is modified

9. Simple Query only returning ODBC Row Buffer Size rows

10. Can Query Insert records row by row