在创建sqlite表格的时候出现statement.text not set?为什么会出现这个问题?

0 0

在创建sqlite表格的时候出现statement.text not set?为什么会出现这个问题?3

源代码如下:

private function getSQLFile():void{
			//get sql file 
			trace(File.applicationDirectory.nativePath+"/db.db");
			var _f:File = new File(File.applicationDirectory.nativePath+"/db.db");
			if(!_f.exists){
				initdb(_f);  //if file is not existed create
				initTable();  //if table is not existed create
			}
			else
			{
				initdb(_f);
			}
		}

private function initdb(_file:File):void{
			try{
				conn = new SQLConnection();
				conn.open(_file);
				stmt = new SQLStatement();
				stmt.addEventListener(SQLEvent.RESULT,getResult);
				stmt.addEventListener(SQLErrorEvent.ERROR,resultErr);
				stmt.sqlConnection = conn;
			}catch(ex:SQLError){
				trace("init the database error:"+ex.message);
			}
		}

private function initTable():void{
			try{
				//create table for note party note_title=title note_content = content statas(0:commond 1:delete )
				var 1_table:String = "CREATE TABLE IF NOT EXISTS t_aa("
				                         +"id INTEGER PRIMARY KEY AUTOINCREMENT,"
				                         +"title TEXT," 
				                         +"content TEXT,"
				                         +"time TEXT,"
				                         +"statas NUMERIC"
				                         +")";
				stmt.text = 1_table;
				stmt.execute();
				//create table for account book  account_title=title account_money = money statas(0:salay 1:cost  description description)
				var 2_table:String = "CREATE TABLE IF NOT EXISTS t_bb(id INTEGER PRIMARY KEY AUTOINCREMENT,title text,aa numeric,bb numeric,dcc text,dd text)";
				if(stmt == null){
					this.initdb(new File(File.applicationDirectory.nativePath+"/db.db"));
				}
				stmt.text = 2_table;
				stmt.execute();
			}catch(ex:SQLError){
				trace("init table error:"+ex.message);
			}
			//stmt.cancel();
		}

结果在程序运行初始化的时候出现了个出错如下:

[color=red]Error: Error #3108: Operation is not permitted when the SQLStatement.text proper
ty is not set.
	at Error$/throwError()
	at flash.data::SQLStatement/checkAllowed()
	at flash.data::SQLStatement/checkReady()
	at flash.data::SQLStatement/execute()
	at db::SQLLiteConntion/getResult()[E:\project\Adobe\flex\NoteBook\src\db\SQLLit
eConntion.as:156]
	at flash.data::SQLStatement/internalExecute()
	at flash.data::SQLStatement/execute()
	at db::SQLLiteConntion/initTable()[E:\project\Adobe\flex\NoteBook\src\db\SQLLit
eConntion.as:114]
	at db::SQLLiteConntion/getSQLFile()[E:\project\Adobe\flex\NoteBook\src\db\SQLLi
teConntion.as:76]
	at db::SQLLiteConntion()[E:\project\Adobe\flex\NoteBook\src\db\SQLLiteConntion.
as:65]
	at NoteBook/init()[E:\project\Adobe\flex\NoteBook\src\NoteBook.mxml:99]
	at NoteBook/___NoteBook_WindowedApplication1_creationComplete()[E:\project\Adob
e\flex\NoteBook\src\NoteBook.mxml:2]
	at flash.events::EventDispatcher/dispatchEventFunction()
	at flash.events::EventDispatcher/dispatchEvent()
	at mx.core::UIComponent/dispatchEvent()[C:\autobuild\3.2.0\frameworks\projects\
framework\src\mx\core\UIComponent.as:9298]
	at mx.core::UIComponent/set initialized()[C:\autobuild\3.2.0\frameworks\project
s\framework\src\mx\core\UIComponent.as:1169]
	at mx.managers::LayoutManager/doPhasedInstantiation()[C:\autobuild\3.2.0\framew
orks\projects\framework\src\mx\managers\LayoutManager.as:718]
	at Function/http://adobe.com/AS3/2006/builtin::apply()
	at mx.core::UIComponent/callLaterDispatcher2()[C:\autobuild\3.2.0\frameworks\pr
ojects\framework\src\mx\core\UIComponent.as:8628]
	at mx.core::UIComponent/callLaterDispatcher()[C:\autobuild\3.2.0\frameworks\pro
jects\framework\src\mx\core\UIComponent.as:8568][/color]

哪位兄弟帮忙瞅瞅...明明我设置了 stmt.text= 1_table...可是却报没有设置.很杯具...