embeded browse form wont update

[Tom Cone Jr]

Re: embeded browse form wont update

Karlo,

Your first question has now been answered. The new records are failing to show up in your set based form because they don't have link field values that would "link" them to their parent record.

Please tell us about the field rule you created in order to populate the link field values. The only rule you've mentioned thus far is an auto-increment rule and I'm having trouble understanding how that would create field values that might match values in your parent table. More details please.

[Tom Cone Jr]

Re: embeded browse form wont update

Karlo,

Perhaps you're misunderstanding the tutorial.

For a two table set, using a one to many link, when new records are entered to the child table THROUGH THE FORM, the form itself will supply the link field value to each new row in the child table. The link field value is supplied automatically by the form, but only for child table records entered through the form. i.e. by the user entering records from the keyboard using objects in the form.

Since imported records are not being entered through the form, but are being entered directly into the table without using the form, the link field values in the newly entered child table records remain blank.

[karlombd]

Re: embeded browse form wont update

@stan

we want it to be auto-increment, and date should be automatically generated too so i cant be cheated. it will be used for monitoring. that's why we want it to be automated as possible. i checked the auto increment field in the field rules and create a default expression on data entry "DMS-"+time("yy")+padl(increment(previous("dms_no")),3,"0").

@tom

i would like the field rule for dms_no (expression used was stated above) to populate both table the parent and the child, if you notice the link in my set i put on the referential integrity to change/delete and as the tutorial said, i would bind the fields that i link. i got what you mean in your second response and that's what i would like to do. i'm looking for a ways that i could import excel field the form i created, i just use the import command on the toolbar above, if im not mistaken its under tools then records then imports excel or ascii. but it always import directly to the table not to the fields.

[MoGrace]

Re: embeded browse form wont update

If you import your excel file (or save it as a temporary dbf table), you can then append that table and your auto increment field rule should work.

[karlombd]

Re: embeded browse form wont update

@robin

yah that would work but i want the auto-increment to be put in a set of import for example i import an excel file that contains 10 item those 10 item should have the same values, such as serial number or date, and if i import a new excel file again that has for example 17 items that should have a different value than the first set of items.

[Al Buchholz]

Re: embeded browse form wont update

@stan

we want it to be auto-increment, and date should be automatically generated too so i cant be cheated. it will be used for monitoring. that's why we want it to be automated as possible. i checked the auto increment field in the field rules and create a default expression on data entry "DMS-"+time("yy")+padl(increment(previous("dms_no")),3,"0").

@tom

i would like the field rule for dms_no (expression used was stated above) to populate both table the parent and the child, if you notice the link in my set i put on the referential integrity to change/delete and as the tutorial said, i would bind the fields that i link. i got what you mean in your second response and that's what i would like to do. i'm looking for a ways that i could import excel field the form i created, i just use the import command on the toolbar above, if im not mistaken its under tools then records then imports excel or ascii. but it always import directly to the table not to the fields.

Thanks for explaining what you want the system to do.

The timedatestamp should be entered on the parent along with the dms_no.

Then each value should be assigned to it's own global variable.

Then use those variables to assign the value in the child records so the child records get the same value as the parent.

No need to use autoincrement system. It won't do what you are describing. It's not the right tool for this instance.

[Tom Cone Jr]

Re: embeded browse form wont update

Karlo,

If you're still having trouble and want more help please supply the following:

1) For the parent table, tell us how records are entered, and what field rules are in place, and which are not working. Spare no details. Assume we know nothing about your application.

2) For the child table, are we to assume that records will be imported? Are there field rules in place for this table? What are they? Are any not working?

I think we've gradually come to understand what your end result should look like, but the exact sequence you wish to use is still unclear.

[karlombd]

Re: embeded browse form wont update

@alan

i entered both on the parent, i got values on the child after i import the excel file but not the auto generated values that i made. i notice that those auto generated values created their own row and populate only one row. they are not populating the field next to the imported excel values. i may just doing the process wrong. it show and generate auto increments finely when i do it in default browser for the table ckd_dms_no. but it did not supply values on the child ckd_dms.

[karlombd]

Re: embeded browse form wont update

@tom

yes i still do need help i might doing it wrong.


the parent table uses auto generated values such as date and dms_no (which was coded to be auto increment from previous values) i put the rules in data entry then in the default values. for the child table, yes we will be importing all the values for that. there's no field rules here. i just link the field of dms_no to the parent put on the referential integrity to change/delete on the set. but they are not working, the values of parent table doesn't fill the dms_no field in child. let me know if you need more detail. what i want is that the dms_no should be linked to the imported file. for example i imported an excel file and it contains item1, item2 and item3. those set of items should have the same dms_no ie. dms-001. dms_no will just change if i import another set of items. thanks!

[karlombd]

Re: embeded browse form wont update

i try manually typed the values of excel file and it worked well. i guess there is some thing wrong in importing excel into the embedded browser, seem like its not activated.

[Tom Cone Jr]

Re: embeded browse form wont update

Karlo,

Most field rules are enforced only when entering or changing data interactively ( i.e. through the keyboard ). Exceptions: calculated field rules and auto-increment field rules, and (more recently) certain xbasic scripts you code yourself. If you're expecting a "default values" field rule to be honored during an import and its not happening then the likely explanation is that the internal script Alpha uses to do the import is not triggering enforcement of the rule. If memory serves this limitation of the import operation has existed for a long long time.

[karlombd]

Re: embeded browse form wont update

@Tom

so it cant be done? or can i write an xbasic code to import excel file and fill only selected table on my embedded browser? i didn't get a problem when i manually entered them, even the fields with field rules. also i notice that i need to click on my embedded browser before i can enter values, i'm thinking that it might be the problem why imports wont show up to the embedded browser of the form and just go directly on the table i created.

[Tom Cone Jr]

Re: embeded browse form wont update

karlo,

It can be done, but not the way you're trying.

others may have better ideas but I think a script that did the following would solve your problem.

1. store the current link field value in a variable
2. empty a temporary table that has same structure as your child table
3. import your excel rows to the temp table
4. assign missing field values in each row of the temp table
5. append the temp table records to your child table
6. refresh or resynch the display in your form

[Al Buchholz]

Re: embeded browse form wont update

Thanks for explaining what you want the system to do.

The timedatestamp should be entered on the parent along with the dms_no.

Then each value should be assigned to it's own global variable.

Then use those variables to assign the value in the child records so the child records get the same value as the parent.

No need to use autoincrement system. It won't do what you are describing. It's not the right tool for this instance.

It's a change to your append operation. Instead of using the autoincrement (which will assign unique values to each record) use the global variable that has the value for dms_no

[karlombd]

Re: embeded browse form wont update

Tom.

Thanks! i will try this one. ill message up after.