da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Limit to querylength?

Forum List » ThinDAC » General English

ArjanNoordhoek
User

Junior Boarder

Posts: 12

Karma: 0

Limit to querylength?

Posted: 2007/06/25 04:15

Hi,

Is there a limit to the length of a query. Am using queries with long aliases which leads to a total query length of more then 3000 characters.
When trying to active the query I get the message that the first field can't be bound.
When looking in the log of the server only part of the query is shown (2025 characters).

Am using BDS2006 with the latest release of thindac and ADOServer the MSSQL 2005.

Arjan

ArjanNoordhoek
User

Junior Boarder

Posts: 12

Karma: 0

Re:Limit to querylength?

Posted: 2007/06/25 08:20

After some investigation I found out that the Ainfo.commandtext in ADOServer contains 2048 characters (Hmm. suspicious number). So there does seem to be a limit.

Arjan

Diman

Admin

Posts: 1461

Karma: 18

Re:Limit to querylength?

Posted: 2007/06/25 22:58

Hello

I will check this issue with Danijel, at first.

Regards,
Dmitry

ArjanNoordhoek
User

Junior Boarder

Posts: 12

Karma: 0

Re:Limit to querylength?

Posted: 2007/06/26 01:31

I found the problem. When copy pasting to the commandtext with a very large string, not all is copied.
If I assign it at runtime to the commandtext everything works fine.

Must say I don't know where to look to solve the copy/paste problem.
perhaps it's automatically resolved when you make the new propertyeditors

Arjan

Forum List » ThinDAC » General English