HFCS and Queries.

Hi all,

I have an application that i'm converting from Classic to HFCS. In this application I made heavy use of hFilter. I'm very new to queries and I've noticed a large speedgain against hFilter when using HFCS.

Behind every table with hFilter is a form where I can add, delete or modify records in the standard Windev way. When using queries, the forms are not filled anymore with data from the table.

Can anybody suggest any easy solution, where I can use queries/hfcs and keep the structure of my table/form application.

Thanx in advance for any hints.


Regards,

Aad

Hello Aad...

Before opening the form, read the desired record with a hreadseek(FileName, UNikIDReturnedByTheQuery), and it will work as it was before

best regards

Fabrice Harari
WinDev, WebDev, WinDev Mobile consulting

Hello Fabrice,

Thank for your reply. I don't exactly know what you mean by UNikIDReturnedByTheQuery), what syntax to use. When I use hReadseek(Customer,CustomerId,Customer.ID) I get the same result on every tableline. By the way, the tables are filled with several records meeting the query. So when i choose the first line in the table, i get the same result on the form, as when i choose the last line.
I hope i've made myself clear.

Thanks for your help.


Regards,

Aad

Hello Aad...

what I mean is that you have to modify your query to have it return not only displayable information for your table, but also the unique ID of each record (can be an automatic ID or anything else declared as a unique key in the file)...

This information should be stored in the table (visible column or not) ith the rest of the query results...

So when the user ask for a record form, you just have to read the record FROM THE FILE, using the value of the unik ID that was returned by the query and stored in the table...

So if the ID column is col_ID, and the table is MyTable, you should do something like
<code>
if hreadseek(MyFile, UniqueIDKey, col_ID[TableSelect(MyTable)]) = true then
open the form
else
display a message saying that the record was probably deleted by another user
end
</code>

Best regards

Fabrice Harari
WinDev, WebDev, WinDev Mobile consulting

Hi Fabrice,

Works great. Thank you for your trouble.


Regards,

Aad