on 2017 Sep 12 5:36 AM
Hello,
I'm trying to synchronise between en existing remote database to/from a consolidated (central) database. The table I'm trying to synchronise is a 'Download To Remote Only' mapping and has a custom query for the 'download_cursor' event. The custom query contains a join to a different table and selects a field (formno) from that table.
My mappings:
Remote table:
So in my situation: How do I map a column that doesn't exist on my consolidated table (but I get the column from my custom query) to my remote table? I don't see the option to add a custom column to the table mapping.
Thank you
Request clarification before answering.
Hi Schoof
I think the following will work but I have not tried it:
That's all. You should be able to ignore the column mappings page
Hope that works for you
Dave
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dave, Thanks for the answer.
That's what I tried to do initially, I tried to ignore the column mappings but when I try to synchronise I get the exception 'Server error: Message: Expecting 17 columns in cursor, but found 18. Table Name: OrderLine'.
And I thought this was because I have 17 columns mapped in the column mapping. I also tried to unmap them all but then I get the exception that my primary key is not mapped.
Note that the table and column mapping UI is for you to provide the information needed for generating synchronization scripts. Since you are already using a custom download_cursor synchronization script you don't need to generate one, and thus you don't need to set up that column mapping in the UI.
If you are wondering why the "Custom" option is grayed in the pop-up menu in your screenshot, that is because those options are only applicable to uploads (eg. if you have consolidated column that isn't in the remote table).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Thanks for the reply!
When I don't add any mappings there is no option to specify a download_cursor. When I add the mappings for a couple of columns but I ignore it, on synchronising I get the exception 'Server error: Message: Expecting 17 columns in cursor, but found 18. Table Name: OrderLine'.
Am I missing something here?
User | Count |
---|---|
60 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.