coyote999
Posts: 22
|
Posted: 06/28/2011, 5:31 AM |
|
Hello Forum!
I have a record form with a listbox which shows values filtered by WHERE status=1.
Okay, I only can select values where status = 1 for inserting new records.
After I changed the status of a value to status=2 it's not shown in the listbox. (Of course)
But also for old records. (Shows then "select value)
How can I manually add this special record with status=2 used in the dataset?
Hope I explained it clearly.
Greetings from germany
Martin
|
|
|
datadoit
|
Posted: 06/28/2011, 6:16 AM |
|
Martin, see if this is what you're looking for.
http://docs.codecharge.com/studio40/html/ProgrammingTec...Clause.html?toc
|
|
|
coyote999
Posts: 22
|
Posted: 06/28/2011, 10:38 AM |
|
Dear datadoit,
thanks you helped me alot.
I created a custom SQL-Query with the before select-Event where I filtered the data and select the value of the selected record.
Thank you for your quick answer.
Martin
|
|
|
mamboBROWN
Posts: 1713
|
Posted: 07/03/2011, 9:47 AM |
|
coyote999,
Please don't forget to put RESOLVED in the header. Thanks.
|
|
|
|