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