limit in length of sql string V4MD 4.3 on PC

[Christian - ChrisKatDev.com]

Le 24 nov. 2009 à 20:31, Bart Pietercil a écrit :

> By the looks of it , I would think you can write the subselect with
> idPhoto < 15241 ?
> 
I have 28000 idPhoto ;-)

> hth

br
Chrstian
> 
> Bart Pietercil
> CTO Cognosis NV
> 
> 
> 
> On 24 Nov 2009, at 20:23, Ruslan Zasukhin wrote:
> 
>> On 11/24/09 9:19 PM, "Christian - ChrisKatDev.com"
>> <christian at chriskatdev.com> wrote:
>> 
>>> Hello Ruslan,
>>> 
>>> I have crash on pc, but not on mac, with a request very long (with very big
>>> "IN")
>>> => I have 95660 car in my request...
>>> 
>>> have you a limit ?
>>> 
>>> exemple : 
>>> "SELECT idPhoto FROM user_bloc_photos WHERE (idprojet = 2) AND (idPhoto IN (1,
>>> 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, ....., 15241,
>>> 15242))"
>> 
>> Please report this to mantis.
>> 
>> For now you can try remove spaces between numbers I think.
>> 
>> 
>> -- 
>> Best regards,
>> 
>> Ruslan Zasukhin
>> VP Engineering and New Technology
>> Paradigma Software, Inc
>> 
>> Valentina - Joining Worlds of Information
>> http://www.paradigmasoft.com
>> 
>> [I feel the need: the need for speed]
>> 
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina