Results 1 to 2 of 2

Thread: SQL in Dataenvironment

  1. 08-18-2003, 10:39 AM #1
    bill haven
    bill haven is offline Registered User
    Join Date
    Aug 2003
    Posts
    2

    SQL in Dataenvironment

    I am trying to use a select statement in the vb6 dataenvironment. I am trying to use a between statement to retrieve records between two dates inputed into text boxes.
    ex: select *
    from expenses
    where [date]between '"txtdate1.text'" and '"txtdate2.text'"
    This will not work, and I have tried different ways to express the text boxes with no results. ANY answers??
    Reply With Quote Reply With Quote
  2. 08-21-2003, 02:26 PM #2
    Corruptor
    Corruptor is offline Registered User
    Join Date
    Aug 2003
    Location
    In a galaxy far, far away...
    Posts
    28
    Yeah.

    Please note that the .text property is set to NULL when the focus is not on the specified control. When the focus has been moved from a textbox the .value property is set.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules