V4MD 2.0.3fc5

[Christopher Bishop]

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:

gDB.createStringField( "field1")
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>


And the newest Valentina Studio for Windows will not open any server
databases without freezing.  (Anything with a table.)  I can't open the
table created by Table_CreateDrop.

It will open if you have only master.vdb, but if you create a new
database then create a table, the program suddenly quits, and the Server
log says 

 14:52:17.035000 (144): (312) Creating 'Table1' table: OK
 14:52:17.050000 (144): (312) TABLE(Table1): Getting record count #0: OK
 14:52:17.097000 (2388): Client has been suddenly disconnected (312)
 14:52:17.097000 (2388): Closing connection (312)

Then if I try to open VStudio and connect to the server, the Server log
gets the following:

14:52:37.816000 (144): Connection established with 'localhost:2013'
(368)
 14:52:37.816000 (2388): (368) Database: <none>; User: sa: OK
 14:52:37.832000 (4084): (368) Database: untitled; User: sa: OK

But VStudio is now frozen.


Christopher,

Can I ask you download 2.0.3 release ?

		-----Original Message-----
		From: Christopher Bishop 
		Sent: Thursday, May 05, 2005 1:18 PM
		To: 'valentina at lists.macserve.net'
		Subject: RE: V4MD 2.0.3fc5

		I am using Windows XP Pro with a Pentium 4 computer with
512 RAM.
		I'm using Director MX, now using 2.0.3FC5 Server and
V4MD.


		Your example Table_CreateDrop 
		I changed variable gClient = true

		This example immediately crashes Director if gClient =
true, but not if gClient = false.

		The commands crashing were:
		Valentina.logToMessageWindow = false
		Valentina.logToFile(true, false)

		So I got rid of these commands.


		Then when it gets to the command 
		gDb.create(path, #kDsc_Dat_Blb_Ind)

		I get a Director Alert Box:
		ERROR: ERR_CONNECTION_ERROR()

		In the message window it reports:
		* V4MD *: Valentina.new()...done
		* V4MD *: Valentina.initClient()...done
		* V4MD *: new VDatabase...done
		* V4MD *: VDatabase.create()...ERROR: 532480

		In the VServer_NT.exe debug box (log from server), I get
nothing but the opening stuff:
		Thu May  5 2005 12:38:25.687000 Valentina Embedded
Server
		(2.0, Protocol 2.0, Kernel 2.0.3fc5)
		Maximum number of connections: 5

		 12:38:25.733000 (640): Database engine inited
		 12:38:25.858000 (640): Server started at 15433 port

		________________________________

		On 5/5/05 3:31 AM, "Christopher Bishop" <CBishop AT
alfred .DO.T com> wrote:
		
		> I am so frustrated with Version 2. I cannot do
anything in Client /
		> Server mode, even with the latest fc5 candidate Server
and V4MD Xtra.
		> 
		> All sqlselect statements are returning VOID, and when
I use Valentina
		> Studio v5 to add any data into a table, it crashes
immediately.
		> 
		> I didn't have these problems with V1 client, and I
wish I could go back
		> to using it. However, I need the functionality of
fromfile and tofile!
		> 
		> 
		> I have been spending the last month just trying to get
it to work with
		> no luck. Do you think it is installed incorrectly? I
turned off my
		> firewall, I am getting connections to the debug
window, and I can use
		> some of the functions, like creating tables. There has
to be a problem
		> with how it is set up, since it works fine with your
other clients,
		> right?
		
		Hi Christopher,
		
		We need more info from you:
		
		- platform?
		- have you run our examples?
		does they work ?
		
		- can you show log from Server?
		
		- can you show log from client ?
		
		And so on.