|
FORUMS PROFESSIONNELS WINDEV, WEBDEV et WINDEV Mobile |
| | | | | |
| Débuté par gill, 14 juin 2001 23:05 - 3 réponses |
| |
| | | |
|
| |
| Posté le 14 juin 2001 - 23:05 |
hi all from down under.
It must be down under as I have been trying all night to filter a new browse on a composite key.
I learnt a few things, if you change the table key away from the filter key, then the filter fails.
I need to filter on a composite key to get the resulting table into the correct order for my VIPs - users.
The key consists of CLEUNIK+Date+Time and works well by itself on the table, but I can't work our the code to get it to work as a filter, and I'd rather a filter than a view at this point.
I need to only fill the CLEUNIK and then have the table browse in date and time order.
Since I first wrote this message, I have the CLEUNIK available both as an intger and text field to try to make it easier to filter, but still no luck as yet.
Any help is greatly appreciated as always.
Gill |
| |
| |
| | | |
|
| | |
| |
| Posté le 14 juin 2001 - 17:07 |
Hello,
You have to use one of the HConvert* functions to built the correct value of CLEUNIK....
"Gill Davis" <gill@postrans.com> a écrit dans le message news: 3B289A90.BE91FBD6@postrans.com...
hi all from down under.
It must be down under as I have been trying all night to filter a new browse on a composite key.
I learnt a few things, if you change the table key away from the filter key, then the filter fails.
I need to filter on a composite key to get the resulting table into the correct order for my VIPs - users.
The key consists of CLEUNIK+Date+Time and works well by itself on the table, but I can't work our the code to get it to work as a filter, and I'd rather a filter than a view at this point.
I need to only fill the CLEUNIK and then have the table browse in date and time order.
Since I first wrote this message, I have the CLEUNIK available both as an intger and text field to try to make it easier to filter, but still no luck as yet.
Any help is greatly appreciated as always.
Gill
|
| |
| |
| | | |
|
| | |
| |
| Posté le 15 juin 2001 - 14:03 |
Or in 5.5 : Convert
--
Michel HERRSCHER CONSULTANT Trésorier Adjoint WindevAsso Association des développeurs WinDev(c) Mail = mhc@herrscher.fr ; Tél.+33(0)450870912 ; Fax: +33(0)450871741 ; GSM:+33(0)609044711
"BOUDOT Sébastien" <kerovnia@brsystem.com> a écrit dans le message news: 3b29b2e9@news....
Hello, You have to use one of the HConvert* functions to built the correct value of CLEUNIK.... "Gill Davis" <gill@postrans.com> a écrit dans le message news: 3B289A90.BE91FBD6@postrans.com... hi all from down under.
It must be down under as I have been trying all night to filter a new browse on a composite key.
I learnt a few things, if you change the table key away from the filter key, then the filter fails.
I need to filter on a composite key to get the resulting table into the correct order for my VIPs - users.
The key consists of CLEUNIK+Date+Time and works well by itself on the table, but I can't work our the code to get it to work as a filter, and I'd rather a filter than a view at this point.
I need to only fill the CLEUNIK and then have the table browse in date and time order.
Since I first wrote this message, I have the CLEUNIK available both as an intger and text field to try to make it easier to filter, but still no luck as yet.
Any help is greatly appreciated as always.
Gill
|
| |
| |
| | | |
|
| | |
| |
| Posté le 17 juin 2001 - 18:06 |
My thanks to all those who shared their experience in helping me to solve this one.
However, after many failures, I have gone to a filtered table to get the result without days of programming.
My problem was being used to the way another 4GL works with composite keys.
Thanks
Gill |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|