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.
<div><br></div><div>OK - for some reason you can use this SQL:</div><div><br></div><div><div>SELECT i_clients_companyname, i_clients_IsShipper FROM info_clients</div><div>WHERE i_clients_IsShipper = 'FALSE'</div>
</div><div><br></div><div>but if you use:</div><div><br></div><div><div>SELECT i_clients_companyname, i_clients_IsShipper FROM info_clients</div><div>WHERE i_clients_IsShipper = FALSE</div></div><div><br></div><div>without the single quotes you will get EOF error and lots of problems.</div>