V4MD 2.0.3fc5

[Christopher Bishop]

Could you guys come up with an example for me to try that basically does
the following:

creates a new database
creates a table
creates a field
inserts data into the field
run a sqlselect() command
report the recordcount

I cannot even get this far, and I have given you the code I used, and
you said to check the examples.  I can't find an example that uses
sqlselect with Client/Server.


Chris


		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.