CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. December 5th, 2004, 10:00 PM #1
    vipo1
    vipo1 is offline Member
    Join Date
    Nov 2004
    Posts
    32

    Smile multiple sql statments

    hello guys

    i have this important quetion

    i am developing a program which will be used to update product in the access database and i am wondering if i can execuate multiple sql statments in the same procedure, and please give me an example of it

    thanks
    Reply With Quote Reply With Quote
  2. December 5th, 2004, 10:27 PM #2
    Thread1's Avatar
    Thread1
    Thread1 is offline Elite Member
    Join Date
    Jan 2003
    Location
    7,107 Islands
    Posts
    2,487

    Re: multiple sql statments

    This may help http://msdn.microsoft.com/library/de...l/acadvsql.asp
    Busy
    Reply With Quote Reply With Quote
  3. December 6th, 2004, 04:54 PM #3
    cjard's Avatar
    cjard
    cjard is offline Elite Member Power Poster
    Join Date
    Oct 2003
    Location
    .NET2.0 / VS2005 Developer
    Posts
    7,104

    Re: multiple sql statments

    use a transaction..
    "it's a fax from your dog, Mr Dansworth. It looks like your cat" - Gary Larson...DW1: Data Walkthroughs 1.1...DW2: Data Walkthroughs 2.0...DDS: The DataSet Designer Surface...ANO: ADO.NET2 Orientation...DAN: Deeper ADO.NET...DNU...PQ
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured