Re: Replacing stored procedure

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

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 16:24:01 -0400

It's essentially the same, you just use a Paramaterized sql statement (in
oledb it's ? instead or "@VariableName"). So you'll have an insert command,
update command, delete command and select command - for the first three
you'll declare the params the same way you do with a Stored proc specifying
the column mapping so the adapter will know what to pass to what field. 

-- 
W.G. Ryan, eMVP
Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups
"John" <john@nospam.infovis.co.uk> wrote in message
news:uXuiB4tXEHA.2908@TK2MSFTNGP10.phx.gbl...
> Hi
>
> I need to insert a new record in an access table with values for various
> fields provided. In sql server you have an insert stored  procedure to
which
> you pass the field values as parameters. How do you do something like this
> in access using oledb & vb.net? Whatever is easiest.
>
> Thanks
>
> Regards
>
>

Relevant Pages

  • Re: VFP Updates?
    ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: OLEDB Newbie - how to ignore deleted rows?
    ... Try sending the command "SET DELETED ON" through VFPOledb ... > I've attached six screen shots which are the dialog and properties ... I create a task moving data from FoxPro to SQL, ... > I can change the type of command I execute on the OLEDB source to be ...
    (microsoft.public.fox.vfp.dbc)
  • Re: TADOQuery slow inserts in Oracle
    ... try to use another OLEDB ... provider. ... >> Or, even better, use prepared ADO command with parameters. ... > INSERT command, and that kept the Parameters from filling in). ...
    (borland.public.delphi.database.ado)
  • Re: Replacing stored procedure
    ... Regards ... you just use a Paramaterized sql statement (in ... > update command, delete command and select command - for the first three ... > Have an opinion on the effectiveness of Microsoft Embedded newsgroups? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: oledb date/time insert command format
    ... I'm still receiving a syntax error in "insert into" command ... I never used Access and Oledb, ... > Microsoft Access 2000 ...
    (microsoft.public.dotnet.languages.vc)