Re: update store procedure via vb exe

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jeff Johnson [MVP: VB] (i.get_at_enough.spam)
Date: 02/10/04 

Date: Tue, 10 Feb 2004 11:10:48 -0500

"kriste" <kriste_l@hotmail.com> wrote in message
news:ujxpYe77DHA.1948@TK2MSFTNGP12.phx.gbl...

> Is there anyway store procedure can be update via a vb exe program?

Just use the Execute method of the Connection object (you ARE using ADO,
right?) to run an ALTER PROCEDURE statement.

Relevant Pages

  • Re: Nz Problem in ADO execute
    ... Previous tests have used the Execute method of the Connection object. ... dbo_Orders WHERE Freight IS NOT NULL") ... both ADO and DAO see the result of the NZfunction as text. ...
    (microsoft.public.access.modulesdaovba)
  • Re: update store procedure via vb exe
    ... Just use the Execute method of the Connection object (you ARE using ADO, ... to run an ALTER PROCEDURE statement. ...
    (microsoft.public.vb.database)
  • VB6 ADO SQL2005 problem
    ... I use ADO to update data in SQL2005 db from vb application. ... It updates about 400 records with Execute method from Connection object ...
    (microsoft.public.vb.database.ado)
  • Re: add records to table through ado
    ... Does that syntax use ADO? ... I'd suggest the Execute method of the ADO ... Connection object: ...
    (microsoft.public.access.formscoding)
  • Re: ping DelM: coInitialize
    ... that if an ADO connection object exists, ... never had to actively call coinit or couninit in any of my ISAPI programs. ...
    (borland.public.delphi.database.ado)