V4MD 2.0.3fc5

Christopher Bishop CBishop at alfred.com
Mon May 2 13:10:03 CDT 2005


I'm still having problems using Valentina 2 Server with V4MD, even with
the new 2.0.3fc5 update.  It is the same problem, where I can create and
open databases, but I can't insert data, and I can't get any results
using SQL statements.

After executing a sqlselect command like:

gDB.sqlSelect( "select * from eduacc", #kClientSide, #kReadOnly )

it returns void, but the error reporting

if ( Valentina.lastError <> 0 ) then
   return Valentina.lastErrorSymbol
else
   return 0
end if

returns 0.


__________________


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')")

  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)




More information about the Valentina mailing list