Updating ONE record in a grid

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi all,

is there a way to programmaticaly update the first record between those
displayed in a grid (the grid source is a view with SQL updates sent to
the base table) without any other information to identify the record?

Let's say the grid shows 3 records at the moment, and column Cost
displays 33.33 for each of them (it's obvioiusly the result of a
division).
I need to update cell Cost of the first record to 33.34, identifying
that record via some grid properties and not via another SQL query.


thanks for help

.

Relevant Pages

  • Re: First cell in a datagrid control gets emptied??
    ... > I'm using an ADO database and a datagrid control which shows a series of ... > in the grid is selected and this causes the cell to be emptied on screen. ...
    (microsoft.public.vb.database)
  • Re: vcr Next button dont work correctly on my form
    ... you mean the VFP "Form Wizard" button set that ship in Home+ ... I've a 'one-to-many' form which has fields on the upper part retrieving from the purchase table, and the lower part has a grid that is populated by the purchase_details table. ... When the record is not the first record and the grid has only one row, then press next, it will move to the next record. ... So, some thing in the form that is causing this behaviour, any idea what is causing it? ...
    (microsoft.public.fox.vfp.forms)
  • Re: TMS Software TDBAdvStringGrid: need help
    ... BTW: I think i found a bug... ... gets the data from the very first record in the grid and the very first ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: vcr Next button dont work correctly on my form
    ... "Hii Sing Chung" wrote: ... This is a common problem when a grid is displaying records from ... When the record is not the first record and the grid has only ...
    (microsoft.public.fox.vfp.forms)
  • Re: vcr Next button dont work correctly on my form
    ... This is a common problem when a grid is displaying records from another workarea. ... When the record is not the first record and the grid has only one ... So, some thing in the form that is causing this behaviour, any idea ...
    (microsoft.public.fox.vfp.forms)