View Single Post
  #6 (permalink)  
Old 11-21-2006, 03:15 AM
SWFKit SWFKit is offline
Senior Member
 
Join Date: Dec 2002
Posts: 2,015
Default Re:How to connecting to databases using SWFKit(SWFKit 2 and SWFKit Pro 2)

The table name in your update statement "update stud set age = 30 where Id = 1" is incorrect. The table name should be "student" not "stud". Hence, the "execute" method will return an empty recordset, which does not contain an "age" field. When you try to get the value of the "age" field, it will say that the field cannot be found.
Reply With Quote