lisachew
Active Member
Dear All,
First question:
Currently, I've create a Header detail Form for the user to add data to table. Using business view from the table F554111 that I've created. In the OK button event rules, I put ...
Example:=
Button Clicked:
Insert.F554111
But I always get the result errors such as duplicate keys not allowed as shown in attachment. No matter how many record I tried to add in it will always display the error, and the highlighted area will always be a line before the empty line. But funnily, the data are actually captured in the table. To my opinion, would it be possible that it has errors because of the blank line, as the line is also capture into the table with zero amount.
Second question:
I was wondering whether can I actually put the 2 insert.Fxxx function in the Application? Pls refer to the example given below.
In the OK button event rules, I put ...
Example:=
Button Clicked:
Insert.F554111
Insert.F554111A
**I did tried to put both insert table in the Post Button Clicked**
(If this method can be used, then you may proceed to read the next question. But if not, just ignore the next question.)
When I clicked on the OK button, all the data are insert into the F554111. But only one line or mayb none at all was inserted to the other table F554111A. Let me refresh you, I am using the table F554111 as the business view only. Would it be possible that it was not inserted to the F554111A table because it was not the business view?
Please help as I have been stuck to this problem for days. And I have not enough efficient reference to help.
Thank you very much.
Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2
First question:
Currently, I've create a Header detail Form for the user to add data to table. Using business view from the table F554111 that I've created. In the OK button event rules, I put ...
Example:=
Button Clicked:
Insert.F554111
But I always get the result errors such as duplicate keys not allowed as shown in attachment. No matter how many record I tried to add in it will always display the error, and the highlighted area will always be a line before the empty line. But funnily, the data are actually captured in the table. To my opinion, would it be possible that it has errors because of the blank line, as the line is also capture into the table with zero amount.
Second question:
I was wondering whether can I actually put the 2 insert.Fxxx function in the Application? Pls refer to the example given below.
In the OK button event rules, I put ...
Example:=
Button Clicked:
Insert.F554111
Insert.F554111A
**I did tried to put both insert table in the Post Button Clicked**
(If this method can be used, then you may proceed to read the next question. But if not, just ignore the next question.)
When I clicked on the OK button, all the data are insert into the F554111. But only one line or mayb none at all was inserted to the other table F554111A. Let me refresh you, I am using the table F554111 as the business view only. Would it be possible that it was not inserted to the F554111A table because it was not the business view?
Please help as I have been stuck to this problem for days. And I have not enough efficient reference to help.
Thank you very much.
Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2