crash when doing search now database won't open

[william humphrey]

yes right now! Please I hope Ivan can solve it. I spent all day and got
nowhere.

On Thu, Jul 19, 2012 at 6:46 PM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> wrote:

> On 7/20/12 12:17 AM, "william humphrey" <bill at bluewatermaritime.com>
> wrote:
>
> Hi William,
>
> > Getting somewhere. The source of the error is anytime I do a SQL search
> with a
> > Boolean ( = TRUE) then I get the EOF file error.  You recover from that
> by
> > unregistering the database, quitting vStudio, re-starting vStudio and
> > re-registering the database.  But since these a SQL statements that I
> used to
> > use all the time without causing this problem I'm still working to
> figure out
> > why.
> >
> > OK - for some reason you can use this SQL:
> >
> > SELECT i_clients_companyname, i_clients_IsShipper FROM info_clients
> > WHERE i_clients_IsShipper = 'FALSE'
> >
> > but if you use:
> >
> > SELECT i_clients_companyname, i_clients_IsShipper FROM info_clients
> > WHERE i_clients_IsShipper = FALSE
> >
> > without the single quotes you will get EOF error and lots of problems.
>
> 1) I THINK, that if you look into logs of VSERVER,
>      you will see some ERROR CODE and MSG about this query.
>
>    EOF is secondary problem, because connection was lost
>
>
> 2) are we talking about latest 5.0 beta?
>
>
> 3) can you send ZIP of this db to Ivan or put into mantis if it is not
> huge,
> Then Ivan must be able
>
>  - put db under VSERVER
>   - connect from Vstudio
>   - execute above query
>    -- see problem
>
> Right?
>
>
>
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20120719/cf7a6a92/attachment.html>