V4MD 2.0.3fc5

[Christopher Bishop]

OK, by following that tutorial on the web site, I was able to get a
little farther.

				dbCursor = gDB.sqlSelect( "select * from
Table1", #kClientSide, #kReadOnly )

				When I changed this to this:


				dbCursor = gDB.sqlSelect( "select * from
Table1" )

				I was able to get a recordcount and read
the results.  I cannot get any results if I use any combination of
things after the selection string.  What do you think could be
happening?




					


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

		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.