SQL with form variables?

[Flamer]

I have two calendar controls on my form and i want to use the dates they enter from the form to an Sql statement I'm creating in the SQL builder.
I tried putting the variable names in the criteria and it says "frdate not an expression in this query"
I made the variable global and it still didnt work..?

Any ideas on what i'm missing?
it would be greatly appreciated..
thank you ahead of time for all or any help
~Jason

[Bigley]

Show us some code there!

[Flamer]

Okay
Basically I created a Data Environment, configured the connection to my sql server, then added a command to the connection. In the properties of my command there is an option to use the SQL builder, which is what I used to make the sql statement.

this is basically the sql statement I want.. using the frdate and todate from the calendar controls on the form.

SELECT ARN_InvHistoryHeader.InvoiceNumber, ARN_InvHistoryHeader.HeaderSeqNumber, ARO_InvHistoryDetail.SOQtyShipped, ARN_InvHistoryHeader.SOShipDate FROM ARN_InvHistoryHeader, ARO_InvHistoryDetail WHERE
AND ARN_InvHistoryHeader.SOShipDate IN (frdate) TO (todate)

and the code for my form is here..


Public ltr As String
Public todate, frdate As Date

Private Sub cmdexit_Click()
End
End Sub

Private Sub cmdrun_Click()
'Calendar Controls
calfrom.Value = frdate
calto.Value = todate
'Exporting my sql report

DataReport1.ExportReport rptKeyText, "c:\windows\desktop\test.txt", True
End Sub

Private Sub Form_Load()
Open "C:\Setup.ini" For Input As #1
Line Input #1, ltr
Close #1
End Sub

I hope that helps.. thanks again