PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → [WD8] query and table
[WD8] query and table
Started by Christoph Erdmann, Jun., 22 2004 1:15 PM - 5 replies
Posted on June, 22 2004 - 1:15 PM
Hallo,
hexecutequery(anfrage)
//works perfect with hreadfirst, hreadnext
TableDisplay(tabelle)
// nothing happend
Any Idea ? Can´t find anything in help or examples.
Christoph
Posted on June, 22 2004 - 1:49 PM
Hi Christoph,
Try
HexecuteQuery(Query)
TableDeleteAll(Table)
TableDisplay(Table, tainit)
Regards,
Peter
Posted on June, 22 2004 - 1:59 PM
Hi Peter,
sorry, but then the table is empty.
I use a browsing table linked to the file.
Must i link the table to the query - nothing found for this ?
Christoph
Hi Christoph,
Try
HexecuteQuery(Query)
TableDeleteAll(Table)
TableDisplay(Table, tainit)
Regards,
Peter
Posted on June, 22 2004 - 2:18 PM
Must i link the table to the query - nothing found for this ?
Christoph

Hi Christoph,
Yes, you should link teh table to the query.
Select the properties window of teh table and select the query as data source.
Next, you will need to link each individual column to the respective field of the query again.
Do this by selecting each column in the table properties window and selecting the respective field from the query as linked item.
If you don't have any logic added to the table yet, it might be faster to regenerate the table with the query as data source.
Regards,
Peter
Posted on June, 22 2004 - 2:55 PM
Hi Peter,
thanks for help. Now it works fine.
I have also found - filetomemorytable - it works too.
Christoph

Must i link the table to the query - nothing found for this ?
Christoph
Hi Christoph,

Yes, you should link teh table to the query.
Select the properties window of teh table and select the query as data source.
Next, you will need to link each individual column to the respective field of the query again.
Do this by selecting each column in the table properties window and selecting the respective field from the query as linked item.
If you don't have any logic added to the table yet, it might be faster to regenerate the table with the query as data source.
Regards,
Peter
Posted on June, 22 2004 - 3:18 PM
Chrisoph,
just in case you are wanting to do the same as me, look at
http://www.f16.parsimony.net/forum28986/messages/13131.htm
with a possible problem with tables and queries
Regards,
Andy

Hallo,
hexecutequery(anfrage)
//works perfect with hreadfirst, hreadnext
TableDisplay(tabelle)
// nothing happend
Any Idea ? Can´t find anything in help or examples.
Christoph