General information
Category:
Coding, syntax & commands
Is SET ANSI OFF?
HTH
>In vfp5 I use a view I tried to put the SQL code here, but I couldn't post the message that has a parameter for beginning date, ending date and select doctor code stored in gcDocID.
>
>The user is presented with a for where they select the date range mq_start,mq_end and select the doctor from a drop down list. The drop down is based off cursor with a list of all the doctors available. Thinking I was smarter than I am, I added a doctor to the drop down called ALL. I placed a space in front of the A so it would be sorted to the top of the list. If the user selects ALL, I thought I would replace the gcDocID with a space and then issue the requery and get all the records. It didn't work for me. Selecting any other doctor, brings up the correct records, but selecting ALL returns 0 records. I'm kinda sure I'm on the right track here, but...I'm not there yet.
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