|
FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile |
| | | | | |
| Iniciado por Mark Bailey, 04,jun. 2004 17:38 - 2 respuestas |
| |
| | | |
|
| |
Publicado el 04,junio 2004 - 17:38 |
These are going to sound like a really dumb questions but
coming from a very different environment (Magic) and I am struggling
to get my head around a few concepts at the moment.
Firstly, assume I have a file defined in the LDM of a project.
The physical file is not yet created on the disk.
In the demo it explains how to create a window to Add, Edit, Delete
the records of the file using code. No problem there.
It then goes on to show you how to drop a table on the form and associate
it with the file. It uses the file that just had data added to it using data entry screen.
Hence, no code was needed to display the live data in the table.
So, the question is. Assume I had not first of all used code to enter data into the file
and instead I just wanted to enter and manipulate all data via the table form. It gives me
an error. Does this mean that if the physical file does not exist then I still need code to
create the table in the first place.
Of course what is confusing is that the RAD process does not show any code for the Window
or the Table.
The second question is..
As a trial I set up the following three files in the LDM
Companies
Company_ID
Company_Name
Address_1
Address_2
Localities
Locality_ID
Locality_Desc
Postal_Code
State_ID
States
State_ID
State_Abbrev
State_Name
and an intermediate file between Companies and Localities
Company_Locality
Locality_ID
Company_ID
Company_Locality
I then tried to set up a editable form whereby I have the Company Name, Address 1 and Address 2 in a table and the Locality in a combo box not in
the table. Also Once the Locality is selected then I want to diaplay the related postal_code and State_Abbrev
I have tried doing this using RAD but it keeps assuming a one to many style with the Locality etc in the table and the Company, Address1,Address2 in fields outside of the table.
I suspect I am going about this all wrong but have gone right through the 7.5 Tutorial and cannot glean how to do this.
Could someone please suggest the correct process for constructing this kind of arrangement.
Sorry this is so long winded.
BTW, this is all in V8 beta
Thanx in Advance.
Mark Bailey
Perth, Western Australia |
| |
| |
| | | |
|
| | |
| |
Publicado el 04,junio 2004 - 23:17 |
Mark,
I too have left Magic and bought WinDev - what a relief to be able to write
real code again! Your questions evoke my sympathy.
Dropping a table on a window:
what is missing, I am guessing, is HCreationIfNotFound("*") in project initialisation.
If you use the wizard to create a window to contain a table to manipulate
a file, the code to create an empty file is generated.
Company/Locality:
I do not use RAD for whole file structures, this sort of thing sometimes
happens.
Use the new window wizard to create a table window for Companies file, then
drag and drop the fields from Locality outside the table. For each field,
you can use a multifile link to point from company record locality_id to
the locality file. Remember to set the locality fields to display only so
that they cannot be inadvertently amended on the company window. You may
need to add FiletoScreen() in the exit code of the locality combo box to
force the write - I can never remember, I just put it in if the fields do
not display!
Hope this points you in the right direction.
Good luck,
Andy Bewick
Mark Bailey <mbailey@arach.net.au> wrote:
These are going to sound like a really dumb questions but
coming from a very different environment (Magic) and I am struggling
to get my head around a few concepts at the moment.
Firstly, assume I have a file defined in the LDM of a project.
The physical file is not yet created on the disk.
In the demo it explains how to create a window to Add, Edit, Delete
the records of the file using code. No problem there.
It then goes on to show you how to drop a table on the form and associate
it with the file. It uses the file that just had data added to it using
data entry screen.
Hence, no code was needed to display the live data in the table.
So, the question is. Assume I had not first of all used code to enter data
into the
file
and instead I just wanted to enter and manipulate all data via the table
form. It gives
me
an error. Does this mean that if the physical file does not exist then I
still need
code to
create the table in the first place.
Of course what is confusing is that the RAD process does not show any code
for the Window
or the Table.
The second question is..
As a trial I set up the following three files in the LDM
Companies
Company_ID
Company_Name
Address_1
Address_2
Localities
Locality_ID
Locality_Desc
Postal_Code
State_ID
States
State_ID
State_Abbrev
State_Name
and an intermediate file between Companies and Localities
Company_Locality
Locality_ID
Company_ID
Company_Locality
I then tried to set up a editable form whereby I have the Company Name,
Address 1 and
Address 2 in a table and the Locality in a combo box not in
the table. Also Once the Locality is selected then I want to diaplay the
related postal_code
and State_Abbrev
I have tried doing this using RAD but it keeps assuming a one to many style
with the
>Locality etc in the table and the Company, Address1,Address2 in fields outside
of the
table.
I suspect I am going about this all wrong but have gone right through the
7.5 Tutorial
and cannot glean how to do this.
Could someone please suggest the correct process for constructing this kind
of arrangement.
Sorry this is so long winded.
BTW, this is all in V8 beta
Thanx in Advance.
Mark Bailey
Perth, Western Australia
|
| |
| |
| | | |
|
| | |
| |
Publicado el 05,junio 2004 - 07:09 |
Hi Mark
So, the question is. Assume I had not first of all used code to enter data into the file
and instead I just wanted to enter and manipulate all data via the table form. It gives me an error. Does this mean that if the physical file does not exist then I still need code to create the table in the first place.
You still don't need code to see the table (given you are accessing the file directly and not using an alias or query) but there is no physical file yet.
Use HCreationIfNotFound(FileNAme) to create the file. In the window wizard you will find a check box asking if this should be dome for you - beware this will stay valid for each time you create a window using the wizard!
Of course what is confusing is that the RAD process does not show any code for the Window >or the Table.
This in itself is an arse, as one can't see what the code is doing, but learn to live with it.
and an intermediate file between Companies and Localities
Company_Locality
Locality_ID
Company_ID
Company_Locality
I then tried to set up a editable form whereby I have the Company Name, Address 1 and Address 2 in a table and the Locality in a combo box not in
the table. Also Once the Locality is selected then I want to diaplay the related postal_code and State_Abbrev
I have tried doing this using RAD but it keeps assuming a one to many style with the Locality etc in the table and the Company, Address1,Address2 in fields outside of the table.
I suspect I am going about this all wrong but have gone right through the 7.5 Tutorial and cannot glean how to do this.
Could someone please suggest the correct process for constructing this kind of arrangement.
I could get shot by saying this, but relation (Intermediate) files can be a waste of time and definitely confuse a user.
When you make a Locality record for a company just use the company info as a lookup and fill in the record using a Vision+. You will still have about the same overhead without the extra file, just more locality records.
It's a matter of just keeping the same info once and then relating it back to another file.
Relation files can be a waste of space as they only hold two ID numbers, and in most cases are filled in to do other duties as well.
Gill |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|