urgent help requrieed ORA-00936: missing expression oracle probelm please help

Posts   
 
    
buckd30
User
Posts: 15
Joined: 20-May-2009
# Posted on: 23-Jun-2009 16:14:36   

I have this new project and for first time i am using oracle with llbgen now I have having a problem on saviong a record i getting the error

ORA-00936: missing expression

this is my save code

    mysickline.IsNew = True

    mysickline.PersonalId = userId
    mysickline.SickleaveType = leave
    mysickline.StartDate = start
    mysickline.EndDate = endDt

    mysickline.Reason = reasonStr

    mysickline.SubmittedBy = subBy
    mysickline.Comments = comms
    mysickline.AuthUser = ntid()
    If leave <> "LTS" Then
        mysickline.LtsMoveDate = lts
    End If

    mysickline.LastModified = Convert.ToDateTime(System.DateTime.Now())

    mysickline.LastModifiedBy = ntid()
    mysickline.WebDate = Convert.ToDateTime(System.DateTime.Now())

    mysickline.Save()
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39859
Joined: 17-Aug-2003
# Posted on: 23-Jun-2009 16:32:43   

And what's your llblgen pro version number and runtime build nr you're using? ->http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7722

Also, enable tracing (see 'troubleshooting and debugging' on the Oracle DQE to see the generated SQL

Frans Bouma | Lead developer LLBLGen Pro