[v4md 1.9.7] Problems with INSERT INTO

[Ruslan Zasukhin]

on 3/25/03 7:51 PM, Mathew Ray at mathew at iqtv.com wrote:

> Hi all,
> 
> For some reason this SQL works in viSQL, but not in director...
> 
> tSQL = "INSERT INTO theInfo VALUES ('test2 name', 'test 1', 'test 2', 'test
> 3', 'test 4')"
> tQueryResults = new( xtra "VCursor", GetRef(tDatabase), tSQL )
> 
> All of my SELECT statements work fine using the same generic query()
> function, and if I run the sql in viSQL, a record is created propertly.
> 
> Am I missing something?

Yes Mathew,

All SQL commands except SELECT, must be made via handler

    db.SqlExecute()


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