How to use Automatic query builder to insert a record!

Andre Garzia soapdog at mac.com
Thu Aug 7 01:29:01 EDT 2003


> Hi Andre,
>
> You'll have to do a tiny bit of scripting, but it's
> really easy -- suppose the name of your query is
> "Foobar", then create an Insert button and set its
> script to :
>
> --
> on mouseUp
>   revExecuteWithQuery "Foobar", \
>      "INSERT INTO users VALUES(2003,'Andre Garzia')"
> end mouseUp
> --
>
> Hope this helped,
>
> Jan Schenkel.


Hi Jan,

first tanx for the quick answer.

let me see if i get it... i must change the SQL query in my automatic 
query from select to insert... right?

if thats so, how does it get the values from the fields?

I can't find revExecuteWithQuery in the transcript dictionary.

Uh... are thoose undocumented featues?
Andre Alves Garzia  2003  BRAZIL
http://www.soapdog.org




More information about the use-livecode mailing list