database : insert/update/delete

[Dave Cragg]

On 27 Aug 2005, at 14:59, Revolution wrote:

> Saturday, August 27, 2005 4:57:04 PM (GMT +02:00)
>
> Hi,
>
> want to add to the database what's in a text
> field.
>
> event from the button mouseup :
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 
> =-=-=-=-=
> put fld "MyEdit" into MyEditVar
> put "INSERT INTO mytable myfield VALUES ('" & MyEditVar & "');"  
> into SQL
> revExecuteSQL dbID, SQL
> put the result into sqlResult
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 
> =-=-=-=-=
>
> what's wrong ?

Don't include the semicolon at the end of the statement.

Also, I think myfield should be in parentheses.

Cheers
Dave