SQL with V4MD and viSQL

[Ruslan Zasukhin]

On 8/26/04 5:11 PM, "Holly Bogossian" <holly at roundboxmedia.com> wrote:

Hi Holly,

> Frank
> I am not sure I understand what you mean by a "field method"? Would
> you please give me an example of 'pseudo' code demonstrating your
> suggestion.

Frank means BaseObject method
    aka "Virtual field",
    aka "Calculate fields"

You can look into Valentina SQL.pdf for functions which you can use in
BaseObject methods.

And into Valentina Kernel.pdf which describe what is this.

And into V4MDReference.pdf, Xtra Vdatabse, handler MakeNewField()


> Also, if v1 can not handle mathematical operations does the beta
> version do them?

You mean 2.0 ?

Yes. Valentina 2.0 support such syntax.

 
> I also have looked at the manual, ValentinaSQL.pdf and the section
> "Expressions." Can they be implemented using the Director Xtra? How
> are these implemented?

Yes! all these functions can be used in BaseObject methods.


> Thanks,
> 
>> Hi Holly,
>> 
>> 
>> On Aug 25, 2004, at 5:14 PM, Holly Bogossian wrote:
>> 
>>> I have had no problems with simple SQL using executeSQL command but
>>> cannot get the following to work. I keep getting the error:  "603,
>>> Field Not Found". Same result regardless of operator. What am I
>>> doing wrong?
>>> 
>>>     SELECT (field1Number - field2Number) FROM baseObjectName
>>> 
>>> Using Director MX, V4MD v1.10 on Mac G4. This same result also
>>> occurs using viSQL on WinXP.
>> 
>> You cannot perform mathematical operations in SQL in Valentina 1.
>> The workaround is to use a field method.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------