|
| Inicio → WINDEV 2024 → wd19: How to read/list a hyperfile .fic structure with NO ANALYSIS ever built |
| wd19: How to read/list a hyperfile .fic structure with NO ANALYSIS ever built |
| Iniciado por guest, 25,mar. 2015 18:48 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 25,marzo 2015 - 18:48 |
Hi All
I managed successfully to create a freeStanding.fic table and import data from excel2010.xlsx by reading 1st row as all columnNames for creating hyperfile columns dynamically with HDescribeFile(AFile), HCreation...
But accidentally, I deleted the excel file and I couldn't find out any functions to
to open the .fic with NO ANALYSIS at all unless to use wdmap.exe.
Any help would be appreciated?
Cheers
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,marzo 2015 - 19:04 |
HDeclareExternal is your friend.
<a class="ExternalLink" rel="nofollow" target="_blank" href="http://doc.windev.com/en-US/index.awp?3044204">http://doc.windev.com/en-US/index.awp…</a> |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,marzo 2015 - 19:08 |
Hi Kingdr,
1. You can HDeclareExternal() the file you want to read. Then HExecuteSQLQuery() with SELECT * FROM YourExternalFileAlias. (The quick way.)
http://doc.windev.com/en-US/…
http://doc.windev.com/en-US/…
2. You can HDescribeFile() to the application so that it can be used with H* functions directly on the file. (The long way.)
<a class="ExternalLink" rel="nofollow" target="_blank" href="http://doc.windev.com/en-US/?3044206">http://doc.windev.com/en-US/…</a>
Best regards,
Alexandre Leclerc |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,marzo 2015 - 20:58 |
Cool, that works out for me and I don't need to install wdmap to customers' w/s
instead.
Thx again <img src="/NG2013_WEB/ui/smiley/1.gif" align=absmiddle border=0 alt=":)">
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 26,marzo 2015 - 10:18 |
If you are going to use HDeclareExternal in multi-user environment use Hmode after the HDeclareExternal, in some versions (at least in WD14) the file was declared in single-user mode.
<a class="ExternalLink" rel="nofollow" target="_blank" href="http://doc.windev.com/en-US/?3044039">http://doc.windev.com/en-US/…</a> |
| |
| |
| | | |
|
| | | | |
| | |
|