Skip to Content (Press Enter)
UserImage.jpg
Andréa Reis
28Views
2Comments
Updating data from an external database
Question
Hi guys,
 
i successfully created a link to another sql instance to get a table from my ERP database, following the instructions of this link:
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?Topic=How-to-integrate-with-an-external-SQL-Server-or-ORACLE-database-in-OutSystems
 
I could create a List Page and works like a charm! I even change some data from my ERp and there're reflections in outsystems.
 
But when I tried to create an Edit page I simple couldn't.
Is there any chance of this "dream" come true?
 
The update action wasn't created, only the create action for this erp entity. 
Can someone please give me a hand on this?
 
Many thanks and a great hug from Brazil.
0
0
31 Jan 2012
Copy Link
2011-08-23 22-04-05
Tiago Simões
Staff
Hi Andréa,

Does the table have a single primary key?
If it doesn't you'll need to create the edit page yourself and do an advanced query to update or create the record.

Cheers,
Tiago Simões
1
0
31 Jan 2012
Copy Link
UserImage.jpg
Andréa Reis
Hi Tiago, 
thanks for the quick answer.
In fact this table has 2 PK, it's really rare to main tables in ERP to have only one.

I'll try to make an advance SQL tonight and I'll give some feedback.
0
0
31 Jan 2012
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.