[v4md 1.9.7] Problems with INSERT INTO

[Mathew Ray]

Ok, just found the Update and addRecord functions in the documentation and I
am working on implementing them now, but am I forced to use these in order
to add or update records with valentina in director? I was hoping to stay
with a generic SQL approach if possible...

Thanks,
Mathew

----- Original Message -----
From: "Mathew Ray" <mathew at iqtv.com>
Sent: Tuesday, March 25, 2003 12:51 PM


> 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