[Gambas-user] Add field

[R. Stormo]

I want to add one more field to a table , on the fly, without using database
manager. How is this done?
My thinking was.
dim r as result
dim htable as table

try r = $conn.exec("select checkfield from mytable")
if error.code <>0 then
    htable= $conn.tables["mytable"]
    htable.fields.add("checkfield",gb.integer)
    htable.update()
end if

This is not working as it should , I get error "Table already exist"


-- 
Regards
	Rohnny Stormo


-----------------------------------------
Gambas brings Basic to Linux.
My Gambas Community http://forum.stormweb.no
--
View this message in context: http://www.nabble.com/Add-field-t1224081.html#a3237785
Sent from the gambas-user forum at Nabble.com.