Re: Recall Record

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

QaiserMehmood <qaiserme@xxxxxxxxxxx> wrote:

Sir How to recall a record using sql statement

You can not. recall is an xBASE command. SQL does not have the
concept of deleted records that can be recalled.

If you want to be able to do something like this in SQL, you
could add a delete status column and refer to that column in all of
your selects and updates. Messy!

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
.

Relevant Pages

  • Re: Considerations migrating from Access 97 mdb to Access 2003 (or up)?
    ... I don't recall if you're using ... string), when I walk through the code it hits this and goes to my ... assuming no ODBC connect string is specified in the SQL passed to ... but would also be able to resolve expressions that db.Execute ...
    (comp.databases.ms-access)
  • Re: G430 RAIM failure
    ... Jon Carlson wrote: ... SQL) and sounds like almost the same point. ... It all came back after about 15 seconds, the RAIM flag went away. ... I don't recall whether I was still in approach mode or not, but like you I broke out about the time I was figuring out my next move. ...
    (rec.aviation.ifr)
  • Re: Merge Replication Architecture Planning Guidance
    ... I don't recall such a presentation. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Access maybe, Sql no **WARNING: MALICIOUS SITE **
    ... the terms 'relational' and sql as synonyms. ... The marketing people, maybe, ... I seem to recall a David W. Fenton. ... except that set theory is useful in modelling ...
    (microsoft.public.access.queries)
  • SSIS Package importing deleted records from Visual Foxpro tables
    ... I have a SQL Server 2005 SSIS package that imports data from VFP tables ... I know that the default for the VFP OLEDB provider is ... preview results that exclude deleted records, ...
    (microsoft.public.sqlserver.dts)