How to display a Clarion variable in a javascript message

[terryd]

Using MSSQL. I am checking 2 fields. There is a key for the combination of the 2 fields. I can't make the key unique because of the problem with MSSQL whereby a new record creates the 2 fields as empty. If a second person tries to create a record at the same time a duplicate error throws up before any fields can be entered. If the combination of the 2 fields already exists I want to display an alert like this:-
p_web.Script('alert("This waybill exists on trip ' & p_web.GSV('WAYALIAS:TripID') & ' You cannot accept this Waybill");')
Currently the message displays without the value of WAYALIAS:TripID

Can I do it?

[Bruce]

>>  If the combination of the 2 fields already exists I want to display an alert like this:-

p_web.Script('alert("This waybill exists on trip ' & p_web.GSV('WAYALIAS:TripID') & ' You cannot accept this Waybill");')

>> Currently the message displays without the value of WAYALIAS:TripID

what embed point are you embedding this into? and what does your code up to this point look like? Are you using the Alias to search for a record?

Cheers
Bruce

[terryd]

Hi Bruce
This is in a procedure routine which is called from the various Validate::variable routines in 5.Add Server Side Code here
The procedure routine is:
TTestForDuplicate ROUTINE
    IF p_web.GSV('WAY:WaybillNumber') ='' OR  p_web.GSV('WAY:WayCustID') ='0'
        p_web._trace('waybill or custid blank')
    ELSE   
    p_web._trace('waybill Number ' & p_web.GSV('WAY:WaybillNumber')  & ' custid ' &  p_web.GSV('WAY:WayCustID'))
        access:WaybillAlias.Open()
        Access:WaybillAlias.UseFile()
        WAYALIAS:WaybillNumber=p_web.GSV('WAY:WaybillNumber')
        WAYALIAS:WayCustID = p_web.GSV('WAY:WayCustID')
        GET(WaybillAlias,WAYALIAS:KEY_CustomerIDWayBillNumber)
        IF ERRORCODE()
            p_web._trace('not found')
            DuplicateFound=FALSE
        ELSIF WAYALIAS:NoImage=FALSE
            p_web._trace('waybill delivered')
            p_web.Script('alert("This waybill has been delivered.Change the number");')
           WaybillChanged=FALSE
           DuplicateFound=TRUE
         ELSE
            p_web._trace('on another trip ')
            p_web.Script('alert("This waybill exists on trip ' & p_web.GSV('WAYALIAS:TripID') & ' You cannot accept this Waybill");')         
            DuplicateFound=TRUE
        END   
        IF DuplicateFound = TRUE
            p_web.SSV('WAY:WaybillNumber','')
            p_web.SSV('WAY:WayCustID',WAY:WayCustID)
        END
        Access:WaybillAlias.Close()       
    END

[terryd]

Answer
I should not have used  p_web.GSV('WAYALIAS:TripID') since this was a value in a lookup I did in the routine so I should have just used WAYALIAS:TripID