Erro no such table

Mobile
#1

Pessoal, estou fazendo a rotina abaixo.

public class Main extends Activity implements Runnable{
	ProgressDialog pgd;
	Cursor cursor;
	SQLiteDatabase db;
	String error = "";

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		
		SQLiteDatabase db = openOrCreateDatabase("vendas.db", Context.MODE_PRIVATE, null);
		
		StringBuilder sqlprodutos = new StringBuilder();
		sqlprodutos.append("Create table if not exists[produtos](");
		sqlprodutos.append("[_id] INTEGER PRIMARY KEY AUTOINCREMENT, ");
		sqlprodutos.append("nome varchar(100), ");
		sqlprodutos.append("preco DOUBLE(10,2)); ");
		db.execSQL(sqlprodutos.toString());
		//db.execSQL("delete from  produtos");
		db.execSQL("Insert into produtos(nome, preco) values('Coca Cola',2.50 )");
		//db.execSQL("Insert into produtos(nome, preco) values('Fanta',4.50 )");
		
		for(int i = 0; i < 100; i++){
        	db.execSQL("INSERT INTO vendas(produto, preco, la, lo) VALUES(1, '6.50', '223', '23232')");
                }

		StringBuilder sqlvendas = new StringBuilder();
		sqlvendas.append("Create table if not exists[vendas](");
		sqlvendas.append("[_id] INTEGER PRIMARY KEY AUTOINCREMENT, ");
		sqlvendas.append("produto integer, ");
		sqlvendas.append("preco DOUBLE(10,2), ");
		sqlvendas.append("la DOUBLE(10,2), ");
		sqlvendas.append("lo DOUBLE(10,2)); ");
		db.execSQL(sqlvendas.toString());
		db.close();
	}
}

porem esta dando o erro abaixo:

07-17 13:02:31.809: E/AndroidRuntime(894): FATAL EXCEPTION: main
07-17 13:02:31.809: E/AndroidRuntime(894): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.vendas/com.example.vendas.Main}: android.database.sqlite.SQLiteException: no such table: vendas (code 1): , while compiling: INSERT INTO vendas(produto, preco, la, lo) VALUES(1, ‘6.50’, ‘223’, ‘23232’)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.ActivityThread.access$600(ActivityThread.java:141)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.os.Handler.dispatchMessage(Handler.java:99)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.os.Looper.loop(Looper.java:137)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.ActivityThread.main(ActivityThread.java:5041)
07-17 13:02:31.809: E/AndroidRuntime(894): at java.lang.reflect.Method.invokeNative(Native Method)
07-17 13:02:31.809: E/AndroidRuntime(894): at java.lang.reflect.Method.invoke(Method.java:511)
07-17 13:02:31.809: E/AndroidRuntime(894): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
07-17 13:02:31.809: E/AndroidRuntime(894): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
07-17 13:02:31.809: E/AndroidRuntime(894): at dalvik.system.NativeStart.main(Native Method)
07-17 13:02:31.809: E/AndroidRuntime(894): Caused by: android.database.sqlite.SQLiteException: no such table: vendas (code 1): , while compiling: INSERT INTO vendas(produto, preco, la, lo) VALUES(1, ‘6.50’, ‘223’, ‘23232’)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
07-17 13:02:31.809: E/AndroidRuntime(894): at com.example.vendas.Main.onCreate(Main.java:58)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.Activity.performCreate(Activity.java:5104)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
07-17 13:02:31.809: E/AndroidRuntime(894): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
07-17 13:02:31.809: E/AndroidRuntime(894): … 11 more

#2

Olá
Você está tentando inserir em vendas antes de criar a tabela.

#3