PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV Mobile 22 → Analysis doesn't show
Analysis doesn't show
Débuté par Mirte VANBERGHEN, 26 juin 2018 12:10 - 6 réponses
Membre enregistré
6 messages
Posté le 26 juin 2018 - 12:10
Hi everyone!

I've managed to do something very strange and annoying ...
I changed a lot in my analysis because a lot of fields were the wrong size or type and I needed to add some.
I did this by creating duplicates of the tables I needed to change and made the changes in the new tables. Occasionally I would save and I was prompted to make the changes in the project. At the end of the day I always made sure I confirmed.
After that I started to change my code to use the other tables.

During my test I came across an error that stated that the description of the analysis didn't match that of the project. (It could have been a bit differently put, I can't recreate the error ...)

I tried generating the analysis, but this caused for the data files to disappear!! It said there were no data files and there weren't any tables showing in the analysis.
After a lot of searching and trying, I managed to undo this somewhat by cancelling the last generation. Now there's 19 files again and they show in my project explorer, but when I go to the analysis there still aren't any tables so I can't make any changes to the tables any more ...
When I go to modifications/generation errors it says "deleting file" for every file and there doesn't seem to be a way to avoid this ...

Can anybody help me in restoring my analysis? I have no idea why this happened ... I didn't create this analysis originally, I'm still very much new to Windev (which I probably proved by managing something so stupid.)

I hope there's a way to fix this, other than creating a new analysis ... This can be done though because I created documentation about the latest modifications so I won't necessarily lose a lot of work, just a lot of time. If there's a different way to fix this, I would love the hear it!! Any tips on how to prevent this in the future would also be very welcome!!!!

Kind regards


Mirte
Membre enregistré
154 messages
Posté le 26 juin 2018 - 15:32
Hi Mirte VANBERGHEN

maybe the loss of data could be like you want to change a type that doesn't match with the new type of the column of the file, I still don't know

for now answer to me this:

What type of files are?
They are Classic file? or they are C/S (Client server for short)?

--
Best Regards
Jose
Posté le 26 juin 2018 - 16:06
Hi Mirte,

THis is my understanding :
1- you copied files and changed the new one
2- you deleted the old files structures from the analysis
3- your renamed the new files with the old files names, thinking that
they wold REPLACE the old one

if that is what you did then the result is exactly as desired:

ALL CHANGES done to the analysis are made on the physical files during
the genration, so point 2 above means that the physical files will be
deleted, and points 1+3 thaty NEW/EMPTY files created and renamed

THat said, this is what you need to do:

- in the analysis, there is a tool allowing you to ROLL BACK to any
previous versions... Use it to go bakc to a time before ANY of the
changes above
- when it's done, restore a backup of your physical files matching that
structure
- then start MODiFYING the EXISTING files, so that your changes will be
reflected on your physical files...

The main point to understand about all this is that each file is
identiied by a GUID, and NOT by it's name. So creating a new file and
renaming it will not make the analysios think it's the old file.

Best regards


--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Free Video Courses, free WXShowroom.com, open source WXReplication, open
source WXEDM.

More information on http://www.fabriceharari.com

Contact me at:
Email: fabrice@fabriceharari.com
Skype ID: fabriceharari
Telegram ID:@fabriceharari
Tel # in the USA: +1 985 746 1422
Tel # in France: +33 970 444 445 (local number 0970 444 445)


On 6/26/2018 3:10 AM, Mirte VANBERGHEN wrote:
Hi everyone!

I've managed to do something very strange and annoying ...
I changed a lot in my analysis because a lot of fields were the wrong
size or type and I needed to add some.
I did this by creating duplicates of the tables I needed to change and
made the changes in the new tables. Occasionally I would save and I was
prompted to make the changes in the project. At the end of the day I
always made sure I confirmed.
After that I started to change my code to use the other tables.
During my test I came across an error that stated that the description
of the analysis didn't match that of the project. (It could have been a
bit differently put, I can't recreate the error ...)

I tried generating the analysis, but this caused for the data files to
disappear!! It said there were no data files and there weren't any
tables showing in the analysis.
After a lot of searching and trying, I managed to undo this somewhat by
cancelling the last generation. Now there's 19 files again and they show
in my project explorer, but when I go to the analysis there still aren't
any tables so I can't make any changes to the tables any more ...
When I go to modifications/generation errors it says "deleting file" for
every file and there doesn't seem to be a way to avoid this ...
Can anybody help me in restoring my analysis? I have no idea why this
happened ... I didn't create this analysis originally, I'm still very
much new to Windev (which I probably proved by managing something so
stupid.)
I hope there's a way to fix this, other than creating a new analysis ...
This can be done though because I created documentation about the latest
modifications so I won't necessarily lose a lot of work, just a lot of
time. If there's a different way to fix this, I would love the hear it!!
Any tips on how to prevent this in the future would also be very
welcome!!!!

Kind regards


Mirte
Membre enregistré
6 messages
Posté le 27 juin 2018 - 08:31
How could I have deleted the old file structure? I also didn't name them the same.
I duplicated the data files, named the new ones with 2 behind the name (like the duplicate for Setting was named Setting2).
I didn't touch the originals, I made all the changes in the new ones and left the old ones because the code hasn't been changed to use the new ones yet. Furthermore, I prefer to keep them to know where the structure comes from so that when there are errors, I know how it used to be. (might seem like a weird practice, but I'm doing the best I can in an environment that I'm not very comfortable with and did not choose to work in)

I've done this before on one table and there weren't any problems ... I just simply started to use the new table instead.

Anyway, the roll back doesn't seem to help. The only thing I can do is cancel that last generation. I did this to get from version 50 to version 49. But when I do it now it just says "All the data files found in the specified locations are updated. You can select new directories or servers containing files to update." and nothing gets done ... So I'm guessing there are no old versions to be found ...

I think I found a way to fix things without too much work though.
I got the wda from an earlier version, before I made all those changes. I copied it into my current project and now I have the analysis back. So I'm going to duplicate the tables again and make the changes again. Hopefully this time this won't cause too many problems. I won't duplicate, just create a new one and add the elements one by one to ensure they have a different name and don't cause any problems.


Thanks for all the help!! It did give me a lot more insight into how the analysis works. I hope I can get it working again!!!

Kind regards


Mirte
Membre enregistré
6 messages
Posté le 27 juin 2018 - 14:47
So, I did like I said in my last post. The same problem occurs however.
This error appear when I want to add a new record to a new datafile. I actually added new ones this time, didn't just duplicate the old ones.

"native SQLite access error.
Error number = 20
Description of <LoginPoging> file in database not compatible with description in analysis (<LoginPoging2ID> item not found in <LoginPoging2> file defined in database).
Synchronize the analysis description with the database description."

I can't find a clear answer to what this exactly means and what I am to do.

When I try synchronizing, it indicates that exactly the same thing as yesterday is about to happen, i.e. table deletion. In the section "Selecting the elements to synchronize" it lists the connection which is selected and all the datafiles (which initially are not selected). If I only select the connection, it prompts to select a table to synchronize. All the tables however have the message (table deletion) behind them. So I am definitely not going to do that because like I said, that's what happened yesterday and caused all the problems ...

So now my question is: How do I fix this? How do I get the analysis description synchronized with the database description without the risk that all the tables are deleted? And also, what did I do wrong?

I hope this sheds some extra light on my problem and allows for help to be offered.

With kind regards

Mirte

(btw. I tried to add images to this reply, but the page reloads and everything I typed is gone and there still isn't an image ... I'm using Firefox.)
Posté le 27 juin 2018 - 15:52
Hi Mirte,

haaaa... you are using a SQLite DB...

So, here here is the bad news: the automatic modification of the files
structure based on the analysis is available ONLY for Hyperfile. For all
other DB, you have to modify the files with an alter table query that
you have to code yourself...

Now the good news: there is no good reason that I know of to use SQLite.
Hyperfile is available on mobile and much more powerful. So use that
instead, and hmodifystructure at the beginning of your project code will
do the rest.

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Free Video Courses, free WXShowroom.com, open source WXReplication, open
source WXEDM.

More information on http://www.fabriceharari.com


On 6/27/2018 5:47 AM, Mirte VANBERGHEN wrote:
So, I did like I said in my last post. The same problem occurs however.
This error appear when I want to add a new record to a new datafile. I
actually added new ones this time, didn't just duplicate the old ones.

"native SQLite access error.
Error number = 20
Description of <LoginPoging> file in database not compatible with
description in analysis (<LoginPoging2ID> item not found in
<LoginPoging2> file defined in database).
Synchronize the analysis description with the database description."

I can't find a clear answer to what this exactly means and what I am to do.

When I try synchronizing, it indicates that exactly the same thing as
yesterday is about to happen, i.e. table deletion. In the section
"Selecting the elements to synchronize" it lists the connection which is
selected and all the datafiles (which initially are not selected). If I
only select the connection, it prompts to select a table to synchronize.
All the tables however have the message (table deletion) behind them. So
I am definitely not going to do that because like I said, that's what
happened yesterday and caused all the problems ...

So now my question is: How do I fix this? How do I get the analysis
description synchronized with the database description without the risk
that all the tables are deleted? And also, what did I do wrong?

I hope this sheds some extra light on my problem and allows for help to
be offered.

With kind regards

Mirte

(btw. I tried to add images to this reply, but the page reloads and
everything I typed is gone and there still isn't an image ... I'm using
Firefox.)
Membre enregistré
6 messages
Posté le 28 juin 2018 - 09:12
Ooh, okay ... That changes things a lot!!

Thank you for all your help!! That's what I needed to know to determine how to continue :).

So I'm going to go back to the original analysis, without any duplicates and than change the database so that I'll be able to alter everything more easily!!

Again, I really appreciate your help!!

Best regards

Mirte