V4MD 2.0.3

[Ruslan Zasukhin]

On 5/6/05 1:09 AM, "Christopher Bishop" <CBishop at alfred.com> wrote:

Hi Christopher,

> I tried 2.0.3.
> 
> The example Table_CreateDrop now seems to work like it did before.  I
> was always able to create tables and databases, but I still cannot run
> sqlselect statements on databases.


> After running the Table_CreateDrop cast, I run the following:

Do you type this in the Message window of director ???

 
> gDB.createStringField( "field1")
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    but CreateStringField() this is method of VTable.


> gDB.sqlexecute("INSERT INTO Table1 (field1) VALUES ( 'teststring' )" )
> --OR
> gDB.sqlexecute("INSERT INTO Table1 VALUES ( 'teststring' )" )
> --either one works
> 
> Everything is fine, but then -
> 
> dbCursor = gDB.sqlSelect( "select * from Table1", #kClientSide,
> #kReadOnly )
> -- **** VStudio Debug Area **** SQL: <Not available>; # of records: 1
> put dbCursor
> -- <Xtra child "VCursor" 2 24346c>
> put dbCursor.recordCount
> -- <void>

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]