vCOM Create Table

[Ivan Smahin]

Hello Brandon,

Wednesday, December 13, 2006, 9:28:06 PM, you wrote:

> I am experimenting with vcom using vb. When I create a db it is created on
> the hard drive. When I attempt to open it with vStudio nothing happens. No
> error, just no database appears after it is opened. 

> Here is the test code:
>       
>     Dim V As New Valentina
>     V.Init 10

      10 is too small cache.
      
      V.Init 4 * 1024 * 1024
>     
>     Dim Db As New VDataBase
>     
>     Db.Create "C:\temp\sample"

      Db.Create "C:\temp\sample.vdb"
>     
>     Dim sql As String
>     sql = "CREATE TABLE tbl1 ("
>     sql = sql + "fldString string(20, 'ASCII') NOT NULL) "

>     sql = sql + "fldString string(20) NOT NULL) "

>     Debug.Print sql
>     Db.SqlExecute sql
>
      You forget:
      Db.Close
      
>     V.ShutDown

> Thanks,

> Brandon

> _______________________________________________
> Valentina mailing list
> Valentina ÎÁ lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina


-- 
Best regards,
 Ivan                            mailto:ivan_smahin ÎÁ valentina-db.com