General information
Category:
Coding, syntax & commands
Cindy,
Thanks for your suggestion. But what I'm having is something like the Print Option of MS Word where the user can enter range of pages or page number separated by commas. Then I have a function to add all the punctuations needed and generated a complete string. That will be saving up space on my form becuz using checkboxes of 12 months will take up lot of space , right?
Anyway, thanks for your suggestion. Will be using it somewhere else sooner.
Gan
>Gan,
>
>Having the user type all of that will surely cause problems. No user should be expected to format data so carefully.
>
>Use checkboxes labeled Jan, Feb, etc.
>
>Then do
>
>cMySelectStatement = ;
>[SELECT Whatever FROM Wherever ] + ;
>[WHERE MyMonth IN (]
>
>cMyWhereStatement = ;
>IIF(JanIsChecked, [,"01/1999" ], []) + ;
>IIF(FebIsChecked, [,"02/1999" ], []) + ; && etc.
>
>cMySQL = cMySelectStatement + SUBSTR(cMyWhereStatement, 2)
>&cMySQL
>
>Note the removal of the extra comma on the front of the list of months.
>This saves worrying about whether there is one field or several.
>
>Again, remember the advice you have been given: use a 4-digit year!
>
>>All,
>>
>>I have a SQL SELECT statement for retrieving my data, and one of the major item is the filter condition, as follow:
>>
>>SELECT ................ WHERE mycursor.month IN ("02/99","04/99")
>>
>>However, I need to allow the user the enter the filter condition that he wants in a textbox with the controlsource of the textbox is set to a memory variable (eg, mMonth).
>>
>>Example,
>>The user will type :
>>"02/99","04/99","06"/99"
>>
>>to filter the month of Feb99,Apr99 and Jun99 which are separated by commas.
>>
>>Therefore, I put the statement as WHERE mycursor.month IN (mMonth), but the command treated mMonth as a string.
>>How should I deal with things like this? Suggestion?
>>
>>Thanks,
>>Gan
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only