crash when doing search now database won't open

[william humphrey]

NOT GETTING ANYWHERE. I have about ten boolean fields in that table. Some
select statements on some of the boolean fields cause crashes some do not.
I cannot figure out what is the difference between the ones that cause the
crash and the ones that don't. I found out that If I use a local database
for testing instead of one in the server than all I have to do is restart
vStudio and I can use the database again.  This EOF crash is horribly
frustrating.

The database can be cloned and it makes no difference.  There is no
indication that there is anything wrong with the database but there must be
something wrong with it.

On Thu, Jul 19, 2012 at 5:17 PM, william humphrey <
bill at bluewatermaritime.com> wrote:

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



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