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

[Ruslan Zasukhin]

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]