Re: Can you avoid pulling the primary key ID and tstamp with a bound datagrid

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Miha Markic [MVP C#] (miha)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 09:27:24 +0200

Hi Earl,

No, there isn't. How would you otherwise know that the record was modified?
Of course, you can blindy try to delete records but I wouldn't suggest you
this way :-) 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:eVjTxCWbEHA.1656@TK2MSFTNGP09.phx.gbl...
> My delete SPs uses the simple structure of checking for the original
primary
> key and a timestamp. When I use currencymanager to delete a record from
the
> DataGrid, I've noticed that if I do not have the primary key and the
> timestamp in the Select statement to populate the datagrid, I obviously
> cannot delete. Yet I have no need for the primary key or timestamp
otherwise
> when I pull that data. It might seem like splitting hairs, but is there a
> better technique that does not pull across unused data?
>
>

Relevant Pages

  • Can you avoid pulling the primary key ID and tstamp with a bound datagrid
    ... DataGrid, I've noticed that if I do not have the primary key and the ... timestamp in the Select statement to populate the datagrid, ... when I pull that data. ... better technique that does not pull across unused data? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to Sync Relational Data via RDA?
    ... The following code is from our app where we pull data from 3 related ... Indicates that SQL Server CE does not track changes to the pulled table. ... No PRIMARY KEY constraints are created locally. ... If you use "TrackingOffWithIndexes", the primary key and indices will be ...
    (microsoft.public.sqlserver.ce)
  • Re: can you have a collumn roll over with auto_increment
    ... doesn't require a primary key, and I could just track quantities in ... I don't really need deviceid nor timestamp. ... The perltime field, time, is so that I can count ... the number to 1 when the max int was reached. ...
    (perl.dbi.users)
  • Re: [VB6] Best practise: Datensatzaggregierung und Anzeige
    ... Create Table AggMinutes( ... TimeStamp INTEGER PRIMARY KEY, ...
    (de.comp.lang.misc)
  • Re: How can I access a MySQL from Access 2003?
    ... be a translation in the driver. ... If the primary key is a data type that Access/Jet doesn't have an exact match ... Even DateTime or Timestamp can cause this ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)