[V4MD] Question about the SQLExecute Command

[Ruslan Zasukhin]

on 3/14/03 12:35 AM, Carsten Ilwig at Carsten.Ilwig at portal-rind.de wrote:

> Hi,
> how can I access the result of the SQLExecute command in V4MD?
> When I call the following command in Director
> 
> SqlExecute(myDBObject,SELECT * FROM Sources WHERE MemberID = ID12547)
> 
> I get as result 0 and noValentina Error back.
> 
> 
> If I call the same sql command in ViSQL I get back the correct record.
> 
> Where does the mistake lie?

Mistake is that if you want SELECT then you need use

    curs = new VCursor( db, "SELECT ... ")


Command Sqlexecute() is for execution all rest SQL commands like INSERT,
UPDATE

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------