Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Unable to locate field workdate in table bxbillable

Posted on by Microsoft Employee

Hello Community,

I am learning dynamics sl development and going through tutorials i got from the internet.

Set up two levels ;Customer and Billable hours.

Here is the sql create table.

Create Table XBillable
(
custID char(15),
Descr    char(60),
Hours   float,
LineNbr  smallint,
NoteId smallint,
SlsperID char(10),
WorkDate smalldatetime

)
go

Create unique index xBillable0
 on dbo.XBillable(Custid,LineNbr)
 go

 Create proc xBillable_p1
 @parml varchar(15),
 @parm2min smallint,
 @parm2max smallint

 as
 select * from XBillable
 where custID=@parml
 and LineNbr between @parm2min and @parm2max
 order by custID,LineNbr
 go
 

I also created DH file

Option Explicit On
Imports Solomon.Kernel
Module sdoXBillable
    Public Class XBillable
        Inherits SolomonDataObject
        < _
          DataBinding(PropertyIndex:=0, StringSize:=15) _
          > _
        Public Property CustID() As String

            Get
                Return Me.GetPropertyValue("CustID")
            End Get

            Set(ByVal setval As String)
                Me.SetPropertyValue("CustID", setval)
            End Set

        End Property
        < _
         DataBinding(PropertyIndex:=1, StringSize:=60) _
         > _
        Public Property Descr() As String

            Get
                Return Me.GetPropertyValue("Descr")
            End Get

            Set(ByVal setval As String)
                Me.SetPropertyValue("Descr", setval)
            End Set

        End Property
        < _
         DataBinding(PropertyIndex:=2) _
         > _
        Public Property Hours() As Double

            Get
                Return Me.GetPropertyValue("Hours")
            End Get

            Set(ByVal setval As Double)
                Me.SetPropertyValue("Hours", setval)
            End Set

        End Property
        < _
         DataBinding(PropertyIndex:=3) _
         > _
        Public Property LineNbr() As Integer

            Get
                Return Me.GetPropertyValue("LineNbr")
            End Get

            Set(ByVal setval As Integer)
                Me.SetPropertyValue("LineNbr", setval)
            End Set

        End Property
        < _
         DataBinding(PropertyIndex:=4) _
         > _
        Public Property NoteId() As Integer

            Get
                Return Me.GetPropertyValue("NoteId")
            End Get

            Set(ByVal setval As Integer)
                Me.SetPropertyValue("NoteId", setval)
            End Set

        End Property
        < _
         DataBinding(PropertyIndex:=5, StringSize:=10) _
         > _
        Public Property SlsperID() As String

            Get
                Return Me.GetPropertyValue("SlsperID")
            End Get

            Set(ByVal setval As String)
                Me.SetPropertyValue("SlsperID", setval)
            End Set

        End Property
        < _
           DataBinding(PropertyIndex:=6) _
           > _
        Public Property WorkDate() As Integer

            Get
                Return Me.GetPropertyValue("WorkDate")
            End Get

            Set(ByVal setval As Integer)
                Me.SetPropertyValue("WorkDate", setval)
            End Set

        End Property

    End Class
    Public bXBillable As XBillable = New XBillable, nXBillable As XBillable = New XBillable
End Module


On form1 Udate1 control i added two levels: Customer;N,XBillable ;D

I added all controls...and their levels.

why getting the above error?

I have attached my project .

Please kindly review and assist.

ST26000.zip

Ronald.



 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to locate field workdate in table bxbillable

    Hello Perumalsamy,

    I have done as instructed and still get same error....

    Any more suggestion.

    RK

  • Suggested answer
    Ram Peru Profile Picture
    Ram Peru 2,830 on at
    RE: Unable to locate field workdate in table bxbillable

    Hello RK,

    you have add the timestamp column in the custom table. below is the field syntax.

    [tstamp] [timestamp] NOT NULL,

    Please close & reopen the Dynamics SL after the Modified table script executed in SQL server.

    Hope this will solve your issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans