Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
First posting so sorry if miss something or being dumb,
I'm trying to intergrate sage accounts 2011 into a qvw i have built in v10. I have all the ODBC connectors etc installed fine and can see all the table etc within sage. I have pulled over the tables i need and if i preview them in the table viewer i can see all the values etc. When i come to put them into tables etc though it doesn't pass through any values (see attached screen shot)
Any guidance or advice would be greatly received. No doubt i'm over looking something really simple
Kind Regards
Jamie
its because Sage fields are loaded with a single quoute 'FIELD', remove the ' and leave it like FIELD.