Begin transaction

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



Hi,

How do I use begin trans, rollback, commit in a query with VB? I know the
concepts, but cannot find the right syntax to use.


Thanks,


Luiz Horacio


.



Relevant Pages

  • RE: EXISTS reserved word in FROM clause
    ... we make a good pair because I know Access SQL ... from what you described the query syntax that I ... >The subquery should return the records: ...
    (microsoft.public.access.queries)
  • Re: Exclusive Form
    ... You're using the syntax for an UPDATE query, ... "'", dbFailOnError ... I created a new table called FormLock with one field named ...
    (microsoft.public.access.formscoding)
  • Re: Bizarre subquery syntax problem
    ... With Access, the official syntax for a subquery always requires an alias, so ... SELECT p.AS UID, p.Firstname AS Firstname, p.Lastname AS Lastname, ... I am seeing bizarre problems with a subquery. ... core query runs fine- ...
    (microsoft.public.access.queries)
  • Re: PSP
    ... I'd be interested in your opinions on syntax of PSP... ... Furthermore, if a query fails, it does not ... > look like it allows the programmer to directly mix the Prolog and HTML. ... Another downside is that predicates cannot be ...
    (comp.lang.prolog)
  • Re: Update top n records
    ... Whenever I'm having problems with the correct syntax, ... to the query design window to see the code. ... "Jeff Boyce" wrote: ... All widgets have a number and are in numerical order in inventory. ...
    (microsoft.public.access.formscoding)