|
|||
|
As well known Access MDB has 2GB size limit,
I can't find Ado methed to check current size of MDB, then I use File object's size property. and code like follwoing ..... var mdb = new File(mfd); trace(mdb.size) ..... Before Conn atcivated, it works OK, while after Conn activated mdb.size returns 0(zero)! I wonder why, could you kindly give me some suggestion? |
|
|||
|
I also tried to use FileStream:
var mfd = appPath+"test.mdb" //var mdb = new File(mfd); var mdb = new FileStream(mfd, "r"); var siz = mdb.length trace(mfd+"\n"+siz) // unchanged! mdb.close(); the FileStream.length keep unchanged as the initial MDB size. |
|
|||
|
The FileStream.length should work. Whereas, in the File.size property, there is a bug when a file has already been opened in swfkit. It has been fixed, and we will upload the upgrade patch in several days.
|
|
|||
|
.......
rs.open(sql) ....... rs.moveFirst while (!rs.eof){ var stm = rs.fields(1).value // fields(1) is a Blob ......... stm.putPos = stm.length stm.write("appending") // append someting ......... rs.fields(1).value = stm // write back to DM rs.update(); var mfd = appPath+"test.mdb" //var mdb = new File(mfd); var mdb = new FileStream(mfd, "r"); var siz = mdb.length trace(mfd+"\n"+siz) // unchanged! mdb.close(); rs.moveNext() } the FileStream.length keep unchanged as the initial MDB size. whileas check in windows resource manager the MDB's size has been changed! |
|
|||
|
Don't know why, maybe the data in memory hasn't been flushed to the mdb file. The FileStream object should have no same bug as the File.size method. Please wait for our patch for swfkit, in which the bug of the File.size method has been fixed.
|
|
|||
|
I bypassed the problem with use both Flash AS and FFish, handle the several record(eg. 5 rec.s) each time.
when these records finished, keep the break point with Global Var. and trigger the Flash listener to show the message, when the message is shown on the Flash Form, the Flash signal next request to FFish...... Thanks anyway! |
![]() |
Was this information helpful? Yes No
| Thread Tools | |
| Display Modes | |
|
|