Re: ADOX vs OleDB for DDL of new Procedure objects

Hi,

Your .NET code doesn't work because GetOleDbSchemaTable returns a table
which contains information of the current database. Modifying that table
will not update the database.

As Cor suggested, if you need to create a procedure in the mdb database, we
have to use CREATE PROCEDURE. You can use the same code as Cor has
provided. Just change the CREATE TABLE statement to CREATE PROCEDURE ......

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Relevant Pages

  • [Long] It should have been easy...
    ... My application is a Winforms one, connected to a SQL Server 2000 database; ... I created a single dialog form for adding and modifying entries in both ... tables, since the schema is the same; the form operates on a single DataRow, ... FormCompanyData form = new FormCompanyData; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [Long] It should have been easy...
    ... > My application is a Winforms one, connected to a SQL Server 2000 database; ... > I created a single dialog form for adding and modifying entries in both ... > FormCompanyData form = new FormCompanyData; ... > MyApp.DataSetCustomers.CustomersRow newrow = ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: PowerHouse 4GL question: database locking
    ... The only way I have found of preventing anybody from modifying the data ... Subject: PowerHouse 4GL question: database locking ... The SET LOCK ...
    (comp.sys.hp.mpe)
  • Re: Refresh DataSet - please Help Me :-(
    ... >And than to get more help it probably better to ask this in the newsgroup ... Firstly let me say I agree with Cor, the best approach to a problem ... the usual approach to refreshing a dataset is to have one ... Update the database with any changes made. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Syntax error (missing operator) when delete with Commandbuider
    ... I was already using AcceptChanges etc on the second copy database but not on ... Hawkmoth ... "Cor Ligthert" wrote: ...
    (microsoft.public.dotnet.framework.adonet)