| |
| Publicado el 18,mayo 2015 - 11:33 |
Hello All.
I need some help. Is it possible to create a query based on file_1 and then use the same query on file_2. Both files have the same structure?
I am working with two sets of files. One set for current period and another set for history. Ideally I would like to use the same query on the current file as well as the history file without having to create two separate queries.
Eg. Query on File_1 = findinvoice_qry. I would like to use the same query (findinvoice_qry) on file_2 when I need it without creating a specific query for file_2.
I trust I get some help soon.
Thanks in advance.
Sam |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,mayo 2015 - 12:03 |
Hi Sam
AFAIK, the query editor dosn't have this option, but you can also do that by using a text query...
Or you can reuse the sql text (..sqlcode if I remember correctely) of an existing query and search replace the file name in it
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,mayo 2015 - 12:32 |
Thank you Fabrice. I suggest this be given consideration in newer edition.
Sam |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,mayo 2015 - 15:50 |
You can use HChangeName for that.
<a class="ExternalLink" rel="nofollow" target="_blank" href="http://doc.windev.com/en-US/index.awp?3044141">http://doc.windev.com/en-US/index.awp…</a> |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,mayo 2015 - 20:41 |
| Thanks Paulo. I will explore it. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,mayo 2015 - 02:29 |
| Might also look at HAlias. |
| |
| |
| | | |
|
| | |