I've started implementing the bulk of the database logic in our
current software project, and while trying to get the select statement
to work in populating the datagrid in one window upon creation, I keep
running into this error every time the SQL statement tries to execute.
It keeps saying that the table I'm trying to get the data from doesn't
exit, when it clearly does in the database the application creates in
the event it doesn't already exist. I've checked the spelling, and
fixed my select statement, but it still says that the table doesn't
exist. Here is the code I'm using:
//Functions to load the proper window depending on what window is open
//Imported Stuff
import MatMgr.DataManager;
import flash.data.SQLConnection;
import flash.data.SQLResult;
import flash.data.SQLStatement;
import flash.display.NativeWindow;
import flash.events.SQLErrorEvent;
import flash.events.SQLEvent;
//Code to load either the new Repair Order or new Purchase Order window
//Declared variables used in more than just one function
private var dataManager:DataManager = new DataManager();
private var loadRO:Repair_Order = new Repair_Order();
private var loadPO:PurchaseOrder = new PurchaseOrder();
private var sqlText:String;
private var selectStatement:SQLStatement;
private var conn:SQLConnection;
//Form Initialization
private function init():void
{
var appWindow:NativeWindow = this.stage.nativeWindow;
var winTitle:String = appWindow.title;
//Alert.show(winTitle, "The title of the window is...");
switch(winTitle)
{
case "Repair Orders": setSelectData(winTitle);
break;
case "Purchase Orders": setSelectData(winTitle);
break;
}
}
//Select functions to populate the datagrid
private function setSelectData(windowTitle:String):void
{
var selectedROHeaderColumns:String = "ROID, BillID, RODate, Status";
var selectedPOHeaderColumns:String = "POID, PODate, TechID, Status";
switch(windowTitle)
{
case "Repair Orders": sqlText = "SELECT " + selectedROHeaderColumns +
" FROM Up18ROHeader";
executeSQL(sqlText);
break;
case "Purchase Orders": sqlText = "SELECT " + selectedPOHeaderColumns
+ " FROM Up18POHeader";
executeSQL(sqlText);
break;
}
}
private function executeSQL(selectSQL:String):void
{
selectStatement = new SQLStatement();
conn = new SQLConnection();
selectStatement.sqlConnection = conn;
conn.open();
selectStatement.addEventListener(SQLEvent.RESULT, selectResult);
selectStatement.addEventListener(SQLErrorEvent.ERROR,
dataManager.errorHandler);
selectStatement.text = selectSQL;
selectStatement.execute();
}
private function selectResult(event:SQLEvent):void
{
var result:SQLResult = selectStatement.getResult();
dgOrders.dataProvider = result.data;
}
