vCOM Create Table

[Joakim Schramm]

Hi Brandon,

I also use VCOM with VB6 - nice to see I'm not the only one ;-)

Just my advice, get started by using the API way, it's much easier, more
powerful and faster, and just use sql were it comes handy. Actually, I
haven't had to touched the sql at all so far, but I think if you use it you
have to srat with creating a coursor - I think, but as I said I haven't used
sql at all so far.

Also about yout .Init below a value of 10 is just 10 bytes, not much of a
cache ;-)

/Joakim 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Brandon Warlick
> Sent: 13 December 2006 20:28
> To: 'Valentina Developers'
> Subject: vCOM Create Table
> 
> 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
>     
>     Dim Db As New VDataBase
>     
>     Db.Create "C:\temp\sample"
>     
>     Dim sql As String
>     sql = "CREATE TABLE tbl1 ("
>     sql = sql + "fldString string(20, 'ASCII') NOT NULL) "
>     Debug.Print sql
>     Db.SqlExecute sql
>         
>     V.ShutDown
> 
> Thanks,
> 
> Brandon
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>