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

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

From: Earl (brikshoe_at_newsgroups.nospam)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 02:17:13 -0500

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

  • qx// vs File commands..
    ... and I need to pull the recent three of each of those files to pwd and ... rename them with timestamp.. ...
    (perl.beginners)
  • Re: Can you avoid pulling the primary key ID and tstamp with a bound datagrid
    ... > timestamp in the Select statement to populate the datagrid, ... Yet I have no need for the primary key or timestamp ... > when I pull that data. ... > better technique that does not pull across unused data? ...
    (microsoft.public.dotnet.framework.adonet)
  • Timestamps
    ... Does anyone know how to pull the date and the time from a timestamp ... field in msaccess? ... i would then like to be able to sort the time. ...
    (comp.databases.ms-access)
  • Frozen TimeStamps
    ... I have a database in which users update information and ... When I query this data, I use a select query to pull the ... last update (Timestamp) only. ...
    (microsoft.public.access.forms)
  • Re: Synchronisation von Datenbeständen zw.Client und Server mit Webser
    ... Wenn man offline einen TimeStamp updated, ... Wer hat dann "Recht"? ... Insofern sind die roten Ausrufezeichen im DataGrid ... Dipl.Inf. Frank Dzaebel ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)