Language: ChineseGermanSpanishFrenchDutchItalianRussian
123 Flash Chat Forums

Go Back   TOPCMM Community > SWFKit > SWFKit Support

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-26-2007, 04:40 AM
Member
 
Join Date: Oct 2005
Posts: 87
Default How too Dynamic check Access MDB size

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?
Reply With Quote
  #2 (permalink)  
Old 04-26-2007, 05:17 PM
Member
 
Join Date: Oct 2005
Posts: 87
Default Re:How too Dynamic check Access MDB size

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.
Reply With Quote
  #3 (permalink)  
Old 04-27-2007, 02:10 AM
Senior Member
 
Join Date: Dec 2002
Posts: 2,015
Default Re:How too Dynamic check Access 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.
Reply With Quote
  #4 (permalink)  
Old 04-27-2007, 02:54 AM
Member
 
Join Date: Oct 2005
Posts: 87
Default Re:How too Dynamic check Access MDB size

.......
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!
Reply With Quote
  #5 (permalink)  
Old 04-29-2007, 11:46 AM
Senior Member
 
Join Date: Dec 2002
Posts: 2,015
Default Re:How too Dynamic check Access MDB size

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.
Reply With Quote
  #6 (permalink)  
Old 05-05-2007, 03:02 PM
Member
 
Join Date: Oct 2005
Posts: 87
Default Re:How too Dynamic check Access MDB size

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!
Reply With Quote
Reply

Was this information helpful?    Yes No



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 04:16 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.