vCOM Create Table

[Brandon Warlick]

Hmm, now it seems the code runs but no table is generated. Can someone test
the sample code and see if it works? If it does then I will figure out what
I am doing wrong.

    Dim V As New Valentina
    V.Init 9 * 1048576      
    
    Dim Db As New VDataBase
    
    Db.Create "c:\temp\sample.vdb"
    
    Dim sql As String
    sql = "CREATE TABLE tbl1 ("
    sql = sql + "fldString string(20, 'ASCII') NOT NULL) "
    Debug.Print sql
    Db.SqlExecute sql
    Db.Close
        
    V.ShutDown

Thanks,

Brandon

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Brandon Warlick
Sent: Wednesday, December 13, 2006 12:48 PM
To: 'Valentina Developers'
Subject: RE: vCOM Create Table


I re-downloaded vcom. Sorry. I think I downloaded an older version. I will
re-try my tests.

Brandon

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Brandon Warlick
Sent: Wednesday, December 13, 2006 12:14 PM
To: 'Valentina Developers'
Subject: RE: vCOM Create Table


Hi Joakim,

Actually, I have been using RealBasic up to today. I am just testing an idea
to connect to Valentina using VB. Actually, I am using VBA which is part of
MS Access. 

Regards, 

Brandon

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Joakim Schramm
Sent: Wednesday, December 13, 2006 9:49 AM
To: 'Valentina Developers'
Subject: RE: vCOM Create Table


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
> 

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina