Possible VServer Bug?? on V4MD

[X Y]

Hi Ruslan,
I am not using UPDATE/INSERT queries but using cursor
updates instead.
I have used local version of the program (meaning the
non client/server) and everything works fine.
I will try to make a mini project of this behavior.

--- Ruslan Zasukhin <sunshine at public.kherson.ua>
wrote:
> On 7/20/04 10:01 PM, "X Y" <xyzabc1010 at yahoo.com>
> wrote:
> 
> Hi,
> 
> 1) check your UPDATE and INSERT query using viSQL or
> Valentina Studio again
> LOCAL database.
> 
> Btw, using Valentina Studio you can do SQL query and
> immidiatly check result
> using table browser.
> 
> 2) if LOCAL version correctly do that queries then
> problem really in
> client/server. I think will be good if you will send
> simple V4MD project
> that do this 2 queries and show problem.
> 
> 
> 
> > Hi All,
> > I have downloaded the latest version of VServer
> and
> > have been running into the following situation.
> > Everytime I insert a record the id of the newly
> > inserted record is set to 0 instead of the
> parameter
> > that I passed. In addition, Updates does not
> update
> > for integers.
> > 
> > Running in a Windows environment, everything works
> > well; however. running in an OSX (where both
> client &
> > server are OSX) I get the  above error.
> > 
> > I set the log to verbose and received no errors
> > whatsoever. Here is the output log from the
> server:
> > 
> > 14:51:52.181996 (2684358124): Database kernel
> inited
> > 14:51:52.228586 (2684358124): Server started at
> 15432
> > port
> > 14:52:17.904112 (379600): Connection established
> with
> > '10.250.8.159:49201' (13)
> > 14:52:17.910929 (381280): (13) Database: <none>;
> > User: sa: OK
> > 14:52:17.915180 (381280): Closing connection (13)
> > 14:52:23.462202 (379600): Connection established
> with
> > '10.250.8.159:49202' (13)
> > 14:52:23.587759 (380400): (13) Database:
> > lexiadatamanager; User: sa: OK
> > 14:52:31.157682 (380400): (13) SQL: select
> group_id
> > from Group  WHERE group_name = 'Phonics Based
> Reading'
> > AND group_tag = 'PBR'; # of records: 0
> > 14:52:38.685274 (380400): (13) SQL: select max_id
> > from TableMaxID where table_name = 'Group'; # of
> > records: 1
> > 14:52:38.687287 (382080): (13) CURSOR(0xC5AF60):
> > FirstRecord : OK
> > 14:52:38.689383 (379600): (13) CURSOR(0xC5AF60):
> > Updating record #1: OK
> > 14:53:10.746429 (379600): (13) SQL: SELECT * FROM
> > Group; # of records: 0
> > 14:53:10.750093 (380400): (13) CURSOR(0xC5AF60):
> > Adding record #1: OK
> > 14:53:10.756437 (382080): (13) Flushing
> > 'lexiadatamanager' database: OK
> > 14:53:17.242184 (380400): (13) SQL: select recId,
> > group_id, group_tag, group_name, serial_no from
> Group
> > where Group.group_id = 24; # of records: 0
> > 
> > Any help would be much appreciated.
> 
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need
> for speed ]
>
-------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
> 
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 



	
		
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/