problem in sql executeupdate
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   kalum_gajaba
Posted On:   Tuesday, October 15, 2002 11:51 PM

hi im new 2 java & i have problems in inserting values 2 access database. my table has three Integer type data fields & two text type fields. so i worte my sql like this rs=st.executeUpdate (" INSERT INTO Question " + " VALUES ( 6.0 , 'false' , 'flash & w' , 4.0 , 5.0 ) "); when im compiling it gives an error says: incompatible types found:int required :java.sql.ResultSet i belive the problem is in the format i insert values can any one help in this matter thanks in advance kal    More>>

hi

im new 2 java & i have problems in inserting values 2 access database. my table has three Integer type data fields & two text type fields.
so i worte my sql like this




rs=st.executeUpdate (" INSERT INTO Question " + " VALUES ( 6.0 , 'false' , 'flash & w' , 4.0 , 5.0 ) ");


when im compiling it gives an error

says:

incompatible types

found:int

required :java.sql.ResultSet


i belive the problem is in the format i insert values
can any one help in this matter


thanks in advance

kal

   <<Less

Re: problem in sql executeupdate

Posted By:   Simon_Ablett  
Posted On:   Wednesday, October 16, 2002 02:16 AM

What's the schema definition of your table?

Regards.
About | Sitemap | Contact