Hi all,
hope all is going well? Having a little trouble configuring a new datastore in data services. The data store connects fine and all goes well until I am writing in a decimal value. The SQL generated by BODS uses a comma for the decimal separator in effect giving a SQL statement as below
INSERT NEW_TABLE (DECIMAL_COLUMN) VALUES (3,5)The db then throws and error as it sees the values list as having two columns not the one - ie should be inserting 3.5 but is reading as insert a 3 and a 5.
I have tried to change the code page and the language of the data store in questions but to no avail, still get the same error. I don’t want to update for all data stores, just this new one that is giving me the issue.
So, where should I be updating in BODS to state that for this datastore the comma should not be used when generating the insert statement - have tried searching and struggling to find anything that has proved helpful so far…
Any suggestions or advice greatly appreciated.
Dave
DaveR (UK) 
(BOB member since 2006-07-13)