|
| Searching for a value in the complete HFSQLServer database ? |
| Iniciado por software, 15,feb. 2016 12:05 - 6 respuestas |
| |
| | | |
|
| |
Miembro registrado
27 mensajes |
|
| Publicado el 15,febrero 2016 - 12:05 |
Hello,
I want to search for a specific value in the whole HFSQLServer database and want to know in which table and column of the database the search value is found .
Any suggestions ?
Kind regards,
Eric |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
204 mensajes |
|
| Publicado el 15,febrero 2016 - 15:09 |
Loop all table with HListFile
for each table loop all column with HlistItem
If you found something with HReadSeek in the column, do your code.
But I'm curious to know why you need something like that. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
27 mensajes |
|
| Publicado el 15,febrero 2016 - 15:45 |
Mathieu BROUSSEAU wrote:
Loop all table with HListFile
for each table loop all column with HlistItem
If you found something with HReadSeek in the column, do your code.
But I'm curious to know why you need something like that.
Thank you Mathieu, i will try your suggestion.
Why i need this, is that we use a software package written in Windev and has a lot of tables.
But some columns are optional and has no meaning names. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
27 mensajes |
|
| Publicado el 15,febrero 2016 - 15:49 |
ERICS wrote:
Mathieu BROUSSEAU wrote:
Loop all table with HListFile
for each table loop all column with HlistItem
If you found something with HReadSeek in the column, do your code.
But I'm curious to know why you need something like that.
Thank you Mathieu, i will try your suggestion.
Why i need this, is that we use a software package written in Windev and has a lot of tables.
But some columns are optional and has no meaning names.
In fact i am searching a sql script to search for a certain value in the whole database ! |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
204 mensajes |
|
| Publicado el 15,febrero 2016 - 16:20 |
| If you are looking for a sql script, why ask in a windev forum ? |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
27 mensajes |
|
| Publicado el 15,febrero 2016 - 16:50 |
Mathieu BROUSSEAU wrote:
> If you are looking for a sql script, why ask in a windev forum ?
I am using the HFSQL Control center tocreate a new sql query. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
102 mensajes |
|
| Publicado el 16,febrero 2016 - 12:44 |
I don't have an answer. So just for your information, in real SQL client server databases you can search in all column names like this:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
SELECT * FROM ALL_TAB_COLUMNS
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
--
http://arnoldconsult.de
WinDev 20 with Oracle, WinDevMobile Android Apps and Motorola Windows CE Mobile Barcode Scanners, Python 3 with Oracle and MySQL |
| |
| |
| | | |
|
| | | | |
| | |
|