Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: BrunoDelFrate
- Order by date
-
Update with unpredictable results... please help!!!
Hi foxbox, Yes, your syntax of course works perfectly... but I was just trying to understand why that Update method didn't work properly - and why it worked perfectly with one more field in the SELECT! :-( I've also tried to put a "response.write rs("rownumber") " before and...- BrunoDelFrate
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
Update with unpredictable results... please help!!!
Hi Fengshui1998, and thanks for your reply. Unfortunately the record updated outside my recordset are on the same table, and not on different tables with the same column name... Bruno Del Frate- BrunoDelFrate
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Update with unpredictable results... please help!!!
Hello, I'm using a piece of code like this one, with SQL Server 7.0: <% query = "SELECT rownumber FROM database WHERE ordernumber = 'XXX'" rs.open query do until rs.eof rs("rownumber") = newvalue rs.update rs.movenext loop %> It works... BUT it also updates some...- BrunoDelFrate
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
-
Synchronizing changes between Access and SQL Server with JRO
Hello, I need to synchronize a MS Access database (97 or 2000, it doesn't matter) with a SQL Server 7.0 publication. I've tried the JetSQLSync routine located at http://msdn.microsoft.com/library/techart/JRORep.htm ... but it does not work: I keep getting a "File not found" message for...- BrunoDelFrate
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
