PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → [hfilter on comp keys]
[hfilter on comp keys]
Started by gill, Jun., 14 2001 11:05 PM - 3 replies
Posted on June, 14 2001 - 11:05 PM
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
Posted on June, 14 2001 - 5:07 PM
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
Posted on June, 15 2001 - 2:03 PM
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


Posted on June, 17 2001 - 6:06 PM
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