New topic: Update Attached Database Using RecordSet?
<http://forums.realsoftware.com/viewtopic.php?t=45587> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message capaho Post subject: Update Attached Database Using RecordSet?Posted: Thu Oct 11, 2012 10:45 pm Joined: Fri Jul 21, 2006 12:28 am Posts: 470 I am trying to find a way to update a record in an attached database. If I update using SQLExecute it works as long as the updated data is text, but doesn't work with a binary string. If I try to update using RecordSet like this: RecordSet = DataBase.SQLSelect("select SomeColumn from SomeTable where SomeIndex='SomeValue'") I get an error message saying "no such column: SomeColumn." Since it finds the correct column using SQLExecute but not using SQLSelect for a RecordSet, I can only assume that my SQLSelect statement is not correct for an attached database. Is it possible to update an attached database using RecordSet? _________________ Regards, Carl Capaho Web http://www.capaho.com Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
