Prev: Views - Ado with Access databases
Next: Windows 7 .. Manifest ??
From: Carlos Rocha on 20 Mar 2010 01:49
Never mind, I found it using AdoX:

oAdoCatalog:Views:Item(sView):Command:CommandText


> Hi,
>
> I need to use Ado (Vo2Ado) to import an Access database (mdb) to a
> SQLite database.
> In SQLite there is a system table called SQLITE_MASTER that holds some
> of the relevant information about the database.
> In this table there is a column named SQL that stores the DDL used to
> create the Tables and Views.
> I need the DDL used to create the Views in the mdb to recreate them in
> SQLite, but can't find nothing in their system tables.
> I know the DDL is there, somewhere, because I download a program that
> takes it out from a mdb, but I need to do it from my program.
> Does anyone know a way to do it?
>
> Thanks

--
Carlos Rocha
 | 
Pages: 1
Prev: Views - Ado with Access databases
Next: Windows 7 .. Manifest ??