[SQL] V4MD 2 - Version 2.0.2

[Ruslan Zasukhin]

On 4/28/05 1:31 AM, "Christopher Bishop" <CBishop at alfred.com> wrote:

> To add more to it, I use the following statements:
> 
> Valentina = new (Xtra("Valentina"))
> Valentina.InitClient()
> set gDB = new(xtra"VDatabase", #kClient, "localhost", "sa", "sa", 15432,
> 5, "")
> gDB.create("newdatabase", 1)
> gDB.createtable("testtable")
> gDB.table("testtable").createStringField( "row1", 20 )
> 
>   Works fine.  Creates a new file, adds the table, adds the field.
> 
>   I close out and try to add a record.
> 
> Valentina = new (Xtra("Valentina"))
> Valentina.InitClient()
> set gDB = new(xtra"VDatabase", #kClient, "localhost", "sa", "sa", 15432,
> 5, "")
> gDB.open("newdatabase")
> sqlexecute(gDB, "insert into testtable values ('test2')")
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Should it be 

    insert into testtable (fldName) values ('test2')



>   Message window gives me
>    * V4MD *: VDatabase.sqlExecute()...ERROR: 394504
> 
>   VServer_NT.exe debugger window gives me
>    15:29:00.361000 (3876): Client has been suddenly disconnected (380)
>    15:29:00.361000 (3876): Closing connection (380)

-- 
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]