SQL with V4MD and viSQL

[Frank Schima]

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,
Frank