[V4MD] adding method field

[Ruslan Zasukhin]

On 5/5/05 11:56 AM, "Peter Salomon" <peter.salomon at gmx.net> wrote:

> hi list,
> 
> i have a project where i can´t add method fields in one table.
> perhaps you may help me to find what´s wrong.
> 
> 1. xtra V4MD 2.0.3fc6 works. examples work, in another table of my
> project i added already method field.
> 
> 2. methodfields are of type stringfield:
> 
>      aTable.createStringField(fldName, 128, [#fNone] , methodstring)
> 
> but also creation with type varcharfield fails
> 
> 3. methodstring is something like:
> 
> "IF ((fld1 + fld2 +fld3)/3*100 < 30, 'low',IF ((fld1 + fld2 +fld3)/
> 3*100 < 70, 'middle', 'high'))"
> 
> this methodsring worked with version 1.x

Well, may be you can just for test to use some simple function?
    e.g. Lower(fld)

If simple will work then it needs check your big function.


> 4. this table has more than 350 fields, when i try to add
> methodfields, messagewindow tells me that job is done without errors.
> but closing db and  check with VStudio
> 
>   --> no methodfields.
> 
> so has anyone an idea what is wrong here or suggestions to find a
> better way?

Wow, 350 fields. 

You sure you need so many in single table ?


-- 
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]