Possible VServer Bug?? on V4MD

[Ruslan Zasukhin]

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
-------------------------------------------------------------