When I try to configure a dataadpter with a concat statement
works
Code: Select all
SELECT (firstname, surname, userid)
FROM employees
Code: Select all
SELECT CONCAT (firstname, ', ', surname) AS name, userid
FROM employees
Code: Select all
SELECT { fn CONCAT (firstname, ', ', surname)} AS name, userid
FROM employees
SELECT { fn CONCAT (firstname, '\, ', surname)} AS name, userid
FROM employees
SELECT CONCAT (firstname & surname) AS name, userid
FROM employee
When I configure the dataadapter I can sometimes preview the data.
After I have created and filled the dataset when I try to preview the data the dataset is empty. Although the schema is correct.
Would this be becuase I only have the standard edition or is it a problem with my code.
If you need anymore information just let me know