Date from UserForm as input to SQL Query

BrianBaldwin1 — Thu, 06 Jun 2013 18:53:32 GMT

I am just wondering how to place the values from my userform into the IQueryDescription SQL code. I know this is a pretty entry question, but am just held up at this last step. Currently, the FM_DATE has hard values in it, but I want to replace these with the TimeStart and TimeEnd userform input.

 
Dim TimeStart As Date
Dim TimeEnd As Date

TimeStart = Me.Time1.Value
TimeEnd = Me.Time2.Value

        Dim queryDescription As IQueryDescription = sqlWorkspace.GetQueryDescription("SELECT DCS_Fact.FM_DATE FROM DCS_Fact INNER JOIN TIBURON.INMAST ON DCS_Fact.DR = TIBURON.INMAST.IM_DR WHERE (DCS_Fact.FM_DATE >= '2012-01-01') AND (DCS_Fact.FM_DATE <= '2012-12-31')")
        Dim queryClass As ITable = sqlWorkspace.OpenQueryClass("Parcels", queryDescription)

Re: Date from UserForm as input to SQL Query

BrianBaldwin1 — Thu, 06 Jun 2013 19:04:07 GMT

Looks like I just had to read in my old Getting to Know Arc Objects for 5 Seconds...

Just had to split the string where the date was and insert " & TimeStart & "

topic Date from UserForm as input to SQL Query in ArcObjects SDK Questions

Date from UserForm as input to SQL Query

Re: Date from UserForm as input to SQL Query