SQL with V4MD and viSQL

[Ruslan Zasukhin]

On 8/26/04 12:14 AM, "Holly Bogossian" <holly at roundboxmedia.com> 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.

Hi Holly,

To execute SELECT commands, you should use not SqlExecute() handler,
But you should create Cursor Xtra


    curs = new ( Xtra "Vcursor", "SELECT ...." )
    
Please check docs of Vcursor Xtra

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