PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → [hfilter on comp keys]
[hfilter on comp keys]
Débuté par Gill Davis, 14 juin 2001 23:05 - 3 réponses
#1
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
#2
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
#3
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


#4
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
→ Revenir à WINDEV 2024