database : insert/update/delete

Bill bill at bluewatermaritime.com
Sat Aug 27 14:05:26 EDT 2005


The database query builder does an excellent (and a little too seamless--no
feedback) job of updating (although since the records are catched you have
to refresh to see the changes).

But I can't help you with delete and insert as you can't do either of those
with the database query builder so I am using libDatabase for that (also
works great). I remember that when I was using the direct calls some of them
were confusing and required reading the directions several times. I finally
just copied directly from the SQLite Demo stack which was a fairly easy
solution. Have you looked at that stack?

Are you looking at your data table using SQLiteManager or something like
that as if you are looking at your data with results from the database query
builder you won't see any changes until after a refresh.


On 8/27/05 9:59 AM, "Revolution" <rrevolution at softhome.net> 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 ?
> 
> also, for the update and delete ?
> 
> have tried it, but it doesn't add to the table.
> stucked here.
> 
> 10x
> 
> Adrian C.
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

            |    |    |
           )_)  )_)  )_)
          )___))___))___)\
         )____)____)_____)\\
       _____|____|____|____\\\__
-------\                   /--------- http://www.bluewatermaritime.com
 ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
  ^^^^      ^^^^     ^^^    ^^
       ^^^^      ^^^

24 hour cell: (787) 378-6190
fax: (787) 809-8426

Blue Water Maritime
P.O. Box 91
Puerto Real, PR 00740






More information about the use-livecode mailing list