Error #2032

[Brix]

Hi,

I get this error when retrieving the columns with the following query:

Code: Select all

SELECT tab_BasisTabblad__Geslacht, tab_BasisTabblad__Achternaam, ClientId
FROM vw_Cliënten

The table specified is a view

I'm wondering what the error message is. I read earlier that it could be a network issue, but when writing another query which retrieves data from a table instead of a view, the retrieving of the columns does work. Also, running the query in the management studio of sql server, the query runs succesfully.

Thank you

[Vladimir]

Hello,

Please let us know whether this error occurs immediately after clicking the Retrieve Columns button or after some time?

Thank you.

[Brix]

Hi,

the first it occurs after a couple of seconds. when i retry retrieving the columns, it occurs immediately.

Thanks

[Vladimir]

Please tell us which version of our product do you use? Not so long ago, we fixed the error with data columns, in which names national symbols were present (such as in your SQL query). Please try to upgrade to the latest prerelease build.

Thank you.

[Brix]

Hi,

We are using a licenced version, Build 2010.1.700 of March 26 2010.

Thank you

[Vladimir]

Hello,

Please try to upgrade to the latest prerelease build and check your query. The latest version was released on July 19, 2010.

Thank you.