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
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution