// ------------------ Return Input Statement
function _GenInput(iRow)
	{
	if (this.types == "") return "Error:Unable to generate SQL. Types not defined."
	var sql1 = ""
	var sql2 = ""
	var val
	var oTypes = this.types
	for (var a=1;a<oTypes.length;a++)
		{
		if (sql1 != "") 
			{
			sql1 += ","
			sql2 += ","
			}
		sql1 += this.data[0][a]
		val = String(this.data[iRow][a])
		val = val.replace(/\'/g,"''");
		switch (oTypes[a])
			{
			case "C":
			case "D":
				if (String(val) == "undefined") val = ""
				sql2 += "'" + val + "'";
				break;
			case "N":
				if (String(val) == "undefined") val = "0"
				if (String(val) == "") val = "0"
				sql2 += val;
				break;
			}
		}
	return "\2" + sql1 + "\3" + sql2;
	}
	Table.prototype.genInput = _GenInput;

// ------------------ Return Input Statement
function _GenUpdate(iRow)
	{
	if (this.types == "") return "Error:Unable to generate SQL. Types not defined."
	var sql1 = ""
	var val
	var oTypes = this.types.split(",")
	for (var a=0;a<oTypes.length;a++)
		{
		if (a > 0) 
			{
			sql1 += ", "
			}
		sql1 += this.data[0][a] + " = "
		val = this.data[iRow][a]
		switch (oTypes[a])
			{
			case "C":
			case "D":
				if (String(val) == "undefined") val = ""
				sql1 += "'" + val + "'";
				break;
			case "N":
				if (String(val) == "undefined") val = "0"
				if (String(val) == "") val = "0"
				sql1 += val;
				break;
			}
		}
	return "\2" + sql1
	}
	Table.prototype.genUpdate = _GenUpdate;