[ADODB's]INSERT INTO can't work well?

[Vista]

var tid=new String(record.RecordCount+1);
var tname="test2";
var tage=2;
var tsex="male";
var tscore=2;
var sql = "insert into student (id,name,age,sex,score) values ('"+tid+"','"+tname+"','"+tage+"','"+tsex+"','"+ts core+"')";
conn.Execute(sql);
trace("sql:"+sql)
//////////the codes above can't insert a record into the student mdb in your official database sample

var sql = "insert into student (id,name,age,sex,score) values ('8','test1','11','male','60')";
conn.Execute(sql);
trace("sql:"+sql)
//////////but these codes above can work well

why??

And how to write codes Recordset.AddNew in FFish?
Thanks!

[Vista]

In another word,database's connection is no problem from your official database sample.
But how to insert a record into a mdb?
Can you make a help to me?

[SWFKit]

Please send the files to support@swfkit.com, we will check it for you.

[Vista]

how to make a search function in FFish with mdb?
what's wrong with the codes below?they can't work?

var sql = "select * from student where id=" + 5;
tt = conn.Execute(sql);
trace(tt.RecordCount); //trace=-1 why???
for(i=0;i<tt.RecordCount;i++){
trace(tt.Fields(1).Value+"|"+tt.eof);
tt.MoveNext();
if (tt.eof) return;
}

[SWFKit]

Please be careful of the cursor type,

http://msdn.microsoft.com/library/de...cursortype.asp

Some type of cursors do not support the RecordCount feature.