[v4md 1.9.7] Problems with INSERT INTO

[Mathew Ray]

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?

Thanks,
Mathew