\r\n\r\n
Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > General > Adding new records...


\r\n \r\n
 
 
Thread Tools Display Modes

\r\n\r\n\r\n
Is ti possible to add more than one record at a time in a table with an .addnew/.update structure???
\r\n
\r\nAnd if no what should I use to do it??
\n
\n
\r\n \r\n\r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n
\r\n __________________
\r\n There is no good and no bad, just perspective and opinion.\r\n
\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n'; pd[24553] = '\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n \r\n\r\n\r\n \r\n \r\n\r\n
\r\n
\r\n  \r\n #2  \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Old\r\n \r\n 06-04-2001, 08:31 AM\r\n \r\n \r\n \r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n ANUNEZ\r\n \r\n
\r\n\r\n
Guest
\r\n \r\n \r\n\r\n
 \r\n\r\n
\r\n \r\n \r\n \r\n
\r\n Posts: n/a\r\n
\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n\r\n
\r\n \r\n
\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n
\r\n Default\r\n Re: Adding new records...\r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n\r\n \r\n\r\n\r\n
I don\'t know if I got you right, but yes you can do it. It something like this:
\r\n
\r\nCreate a loop to iterate a many times as you or the user one. for example this could be use to pass all the records from one recordset to another:
\r\n
\r\n
\r\nrstSource.movefirst
\r\n
\r\ndo while not rstSource.eof
\r\n
\r\n rstTarget.addnew
\r\n rstTarget![ID] = rstSource![ID]
\r\n rstTarget.update
\r\n
\r\n rstSource.movenext
\r\n
\r\n
\r\nloop
\r\n
\r\n
\r\nYou must initialize the recoldsets and close them at the end
\r\n
\r\nI hope this help.
\n
\n
\r\n \r\n\r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n \r\n
\r\n
\r\n
\r\n\r\n\r\n\r\n'; pd[24554] = '\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n
\r\n
\r\n  \r\n #3  \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Old\r\n \r\n 06-04-2001, 09:12 AM\r\n \r\n \r\n \r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n anhmytran\r\n anhmytran is offline\r\n\r\n\r\n
Prev Previous Post   Next Post Next
  #1  
Old 06-04-2001, 08:11 AM
Nemu Nemu is offline
Regular
 
Join Date: May 2001
Location: Montreal, Quebec, Canada
Posts: 85
Question Adding new records...


Is ti possible to add more than one record at a time in a table with an .addnew/.update structure???

And if no what should I use to do it??

__________________
There is no good and no bad, just perspective and opinion.
Reply With Quote
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->