on 5/29/01 18:16, jda at jda at his .DOT com wrote:
>>> 2. Handling very large (> 30K) VText fields.
>>
>> What you mean?
>>
>> You can right now have 200-500KB text fields.
>> Or you ask about Segment size ?
>
> No, length. I'm sorry to say I've forgotten the exact details, but I
> have a method that reads all of the fields in the record, converts
> them to uppercase, and indexes them. That let's me do indexed,
> case-insensitive searches for "words beginning with".
>
> Each field (see below) is a VText field, so the method was declared
> as such, too. The search was failing with large records, I believe,
> and you told me to redelare it as VVarChar, which I did as
>
> allFields = new VVarChar("allFields", 5000, -1)
> allFields.indexByWords = true
> allFields.SetMethod( "Upper(CONCAT(authors,' ', title,' ', editors,'
> ', journal,' ', volume,' ', pages,' ', date,' ', publisher,' ',
> location,' ', url,' ',title2,' ',user1,' ',user2,' ', abstract,'
> ',keywords,' ',notes))" )
>
> Of course, this isn't a long term solution, because only the 5000
> characters will be available for searching.
Ah! you mean METHODS with TEXT fields.
The guys which will work on this is busy now,
I hope he well be able made this at about 20-30 June.
This is not a bug, this is not implemented I'd say.
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on at lists .DOT macserve.net
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2001 Ruslan Zasukhin |
|
