>>MS just ruined my day :(
>>
>>I love grids for lookup routines with 4 - SQL type. I have one that looks up inventory...it has about 2 dozen controls a user can set...each fires off a method that builds a ton of little strings and then:
>>
>>THISFORM.grd.recordsource = m.tsql1 + m.tsql2 + m.tsqlx + m.twhere + m.torder + m.tinto
>>
>>In some cases this results in a recordsource with a "value" of 600 + characters.
>>
>>That was in 5.0 anyway. I've been fighthing with a 6.0 lookup grid...dad gum thing wouldn't work and couldn't figure out why. Until I checked the recordsource...it now only hold 255 characters.
>>
>>This sucks! But I figured some of y'all might wanna' know about this
UN-improvement...
>Ken,
>Currently I don't have 6.0. Is this the case if you prepare SQL string and set recordsource in code?
I found it by going to the record source and typing 12345678901234567892 etc. Sucker froze at 255!
>Hope this is only a limitation for PEM sheet.
Huh? What's a PEM sheet (hope this ain't a DUH? question)