[ANN] Reports, Reports, Reports // Valentina 4.0b7

william humphrey shoreagent at gmail.com
Fri Nov 14 09:12:30 CST 2008


I'm doing everything in Vstudio. My work method is to use Vstudio until I
get exactly what I want and no errors and then switch to RunRev.

I'm still working locally

On 11/14/08, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
>
> On 11/14/08 4:43 PM, "william humphrey" <shoreagent at gmail.com> wrote:
>
> > strike that -- missing comma.
> >
> > SELECT s_voyages_date 'sailed', s_masters_name 'Capt', s_ships_fullname,
> > discharge.s_kcodes_harborname 'discharge',
> > laden.s_kcodes_harborname 'laden'
> > FROM shadow_voyages
> > join shadow_ships on shipname
> > join shadow_masters on mastername
> > join shadow_kcodes as discharge on lastport
> > join shadow_kcodes as laden on portoflading
> > where s_voyages_voyagenumber = 'SS504'
> >
> > this works except after a few seconds you get an error
> > like this
> >
> >  10:42:18 Query time: 0.003 sec
> >  10:42:20 Kernel error: 0x51500.
>
>
>             <SQLSTATE name="51500">
>                 <DESCRIPTION>ERR_DB_IDENTIFIER_NOT_FOUND</DESCRIPTION>
>                 <MESSAGE>Identifier &quot;%S&quot; is not found.</MESSAGE>
>             </SQLSTATE>
>
>
> You make this query from V4REV code?
>     Or Vstudio?
>         In reports?
>
> Working with local db or with VSERVER ?
>
>
> Check also errorString, it should point IDENT which is not found
>
>
>
> --
> 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 mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com


More information about the Valentina mailing list