vserver problem

[Robert Nichols]

Still wrestling with this problem. Can't select records using object  
pointer field as criteria. The select effort works within Valentina  
Studio. I am now using version 3 of Studio and Server.

One possible clue: Within my table, I have 4 object pointer fields.  
The table has 215 records. According to Studio, the "size" of 3 of  
the pointer fields is 16.84 kb. The size of the 4th field, is 9052.  
The field of size 9052 is the one against which I am unable to select  
records.

I'm thinking of deleting then recreating the field. I can find a way  
to preserve the data.

Does the size discrepancy indicate anything?


On May 16, 2007, at 9:49 PM, Robert Nichols wrote:

> Ivan,
>
> Thanks for your response.
>
> I am using v4rb 2.5.10. Perhaps the problem is vserver 2.5.10? This  
> code worked with much earlier versions - vserver 2.0 and also when  
> I tested with 2.5.6. When I said the SQL search worked with Studio,  
> that is when I open the database as a local file. I can't seem to  
> get Studio to connect to vserver (ERROR 0x82514: Received packet's  
> version is inconsistent. ). Is Studio 3.0 able to connect to server  
> 2.5.10?
>
> Whole project is large with a lot of dependencies. Snippet follow:
>
>
>  START CODE
>   d = new cDate
>
>   d.month = d.month-3
>   ds = "slips.flddate > '" + d.shortdate + "' "
>
>
>   s = "select slips.flddate,projects.fullname,exptypes.shortname, "
>   s = s + "slips.description,slips.rate,slips.duration,slips.recid "
>   s = s + "from slips,exptypes,projects where exp = 1 and "
>   s = s + ds
>   s = s  + "order by flddate desc"
>
>   cur = new cvCursor 
> (s,evCursorLocation.kServerSide,evLockType.kNoLocks,evCursorDirection. 
> kRandom)
>
>  END CODE
>
> Obviously this code, which I believe is clean, could be having  
> trouble with the app's state established elsewhere, but I really  
> believe I haven't changed anything significant since AI had it  
> working with 2.5.6. I suspect v4rb or vserver
>
> On May 16, 2007, at 6:57 PM, Robert Nichols wrote:
>
>
> Begin forwarded message:
> From: Ivan Smahin <IvanSmahin at public.kherson.ua>
> Date: May 16, 2007 8:10:10 AM EDT
> To: Valentina Developers <valentina at lists.macserve.net>
> Subject: Re: vserver problem
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
>
> Hello Robert,
>
> Wednesday, May 16, 2007, 2:12:25 PM, you wrote:
>
> RN> I'm using 2.5.10 office server and v4rb. I have a query that works
> RN> fine in Studio, but chokes in my application environment. The
> RN> exception indicates error number 394504, with no description.
>
> <SQLSTATE name="60508">
> <DESCRIPTION>ERR_STREAM_EOF</DESCRIPTION>
> <MESSAGE>Stream EOF reached.</MESSAGE>
> </SQLSTATE>
>
> Seems, client has been disconnected. It could be a various reasons.
>
>
> RN> As I
> RN> said, Valentina Studio has no problem with the query. The query  
> also
> RN> worked with earlier versions of vserver.
>
> RN> How to troubleshoot?
>
> That is strange. What V4RB version do you use?
> Could  I  take  a  look  at  that  problematic  code snippet (or whole
> project)?
>
> Commonly  I  would say: if it works with VStudio then something is  
> wrong
> with your project or V4RB self.
>
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
> ______________________________________________________________________ 
> _______
>
> robert nichols
>
> formwork design llc
> 114 3rd st ne | charlottesville, va 22902 | 434.296.2223 |  
> www.formworkdesign.com
>
>
>
>
> ______________________________________________________________________ 
> _______
>
> robert nichols
>
> formwork design llc | 114 3rd st ne | charlottesville, va 22902 |  
> www.formworkdesign.com
>
>
>
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

________________________________________________________________________ 
_____

robert nichols

formwork design llc | 114 3rd st ne | charlottesville, va 22902 |  
www.formworkdesign.com