PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → Search  for value in column of table
Search for value in column of table
Débuté par John Marrone, 10 aoû. 2004 23:26 - 1 réponse
Posté le 10 août 2004 - 23:26
Hi
Does anybody know how you would search for a value in a table column. I am not using memory tables.
When a user clicks on a record I want to get the value of a column in that record, which I know how to do.
I then want to search a column in an other table and get the row number of the record it finds.
The value I get from the table that was clicked on will always be in one of the records in the other table.
Thanks for any help in this.
John Marrone
Posté le 11 août 2004 - 04:39
G'day John
The problem is that Windev only does a partial fetch for a browse table so it only fills the available lines and gets more when you page up or down, so the record you want may not be in the table.
You would need to do a hreadseek() in the second file and then refill the second table from that point in the file or simply display the data in linked controls on the screen rather than in a table format
It would be much simpler if the second table was a memtable
Regards
Al