|
| [WM23 Express] Unable to add new field in database |
| Iniciado por RobertLEO, jul., 24 2019 12:17 PM - 4 respostas |
| |
| | | |
|
| |
Membro registado
36 mensagems |
|
| Publicado em julho, 24 2019 - 12:17 PM |
| Hello everyone, first time posting here for Windev, so I am currently facing a situation here with Windev 23 Mobile (Express). I successfully imported a database using excel into Windev converted into HFSQL, inside the analysis pane, it appears as a blue mark with an OLEDB label below it, I added a new field named Photo using Sound, Image, Binary format, but when I try to edit the DB using "Edit With WDMap" the new field I wrote didn't appear in it, after attempting to push the field upwards it finally appears but all of my data inside that DB disappears, does anyone know on why this happened and what should I do to make it work? |
| |
| |
| | | |
|
| | |
| |
Membro registado
514 mensagems |
|
| Publicado em julho, 24 2019 - 3:29 PM |
Hi RobertLEO
I want to know
Do you want to be the tables HFSQL Classic?
or Do you want to be OLEDB with the Excel?
because if you want to be on OLEDB using WDMap will be difficult to add data from there, the only way it's using where the table it's in this case on excel.
if you convert the table for HFSQL Classic with will be more easy to add, delete or modify the data.
--
Best Regards
ARV |
| |
| |
| | | |
|
| | |
| |
Membro registado
36 mensagems |
|
| Publicado em julho, 25 2019 - 4:52 AM |
ARV wrote:
Hi RobertLEO
I want to know
Do you want to be the tables HFSQL Classic?
or Do you want to be OLEDB with the Excel?
because if you want to be on OLEDB using WDMap will be difficult to add data from there, the only way it's using where the table it's in this case on excel.
if you convert the table for HFSQL Classic with will be more easy to add, delete or modify the data.
--
Best Regards
ARV
Here is the thing, I am not sure if I saw it right or not but my employee tried converting it into a HFSQL classic (By choosing the "Convert to HFSQL" option after choosing the excel), but after it finishes it's conversion it appears as OLEDB instead, would it be possible to convert existing DB in WM to HFSQL or should I ask him to try again? |
| |
| |
| | | |
|
| | |
| |
Membro registado
514 mensagems |
|
| Publicado em julho, 25 2019 - 6:18 PM |
Hi RobertLEO
Try it again and make sure it select the option "Convert to HFSQL Classic"
if for somereason (that in my case never happend) it show like OLEDB then try to change it to HFSQL
Go to the description of the table file, then on the option of "TYPE" change it to HFSQL Classic
Then select Generation (the flag) to confirm the change on Windev.
with that the table will be HFSQL Classic and if you want to put it on a server like HFSQL C/S, create your .fic of the table and then import it on your server.
with this change the data will be on the .fic
--
Best Regards
ARV |
| |
| |
| | | |
|
| | |
| |
Membro registado
36 mensagems |
|
| Publicado em julho, 26 2019 - 10:05 AM |
ARV wrote:
Hi RobertLEO
Try it again and make sure it select the option "Convert to HFSQL Classic"
if for somereason (that in my case never happend) it show like OLEDB then try to change it to HFSQL
Go to the description of the table file, then on the option of "TYPE" change it to HFSQL Classic
Then select Generation (the flag) to confirm the change on Windev.
with that the table will be HFSQL Classic and if you want to put it on a server like HFSQL C/S, create your .fic of the table and then import it on your server.
with this change the data will be on the .fic
--
Best Regards
ARV
Thanks for the tip, I will be sure to try it out and get back to you on how it goes
Sincerely,
RobertLeo |
| |
| |
| | | |
|
| | | | |
| | |
|