Table doesn't have a primary key Error
I am having trouble utilizing the Lookup Table function. When I try to add a record to the table, I get the following error:
Error executing link in Automation: ABI_P_SAQSubmit2 - From: ABI_P_SAQSubmit2.CountIndex.Properties To: ABI_P_SAQSubmit2.OrderNums.AddRecord()
Table doesn't have a primary key.
Screenshot attached. I have the key I want set to TRUE in the Collection Editor, but that hasn't seemed to help. Any ideas?
Jamie
Thank you for the response.
OrderNum has a string value of 143026 being sent into the Table. I've attached a screenshot.
Is it a data type issue? I specified on the table that the type should be string, but I might have missed something else.
Thanks!
Jamie
From here it looks like it should work. I would create a simple test where you call AddRecord to that table from a win form to see if you have corrupted the table. Absent any other information, I have no real suggestion other than you might consider opening an SR to get someone from support to assist you.
Have you got the solution for this issue.
I have faced same issue today.
Try to declare lookup table Globally should work fine.
Just wanted to add corroborating information to your response Manish.
I had the same issue as above with a local LookupTable. Making the local LookupTable global solved the issue.
Thanks!
Is OrderNum blank? You might add a right before AddRecord and then add a watch to the OrderNum to see what its value is. I would guess that is the issue.