Home » U++ Library support » U++ SQL » Fields
| Re: Fields [message #4163 is a reply to message #4162] |
Wed, 26 July 2006 09:54   |
aroman
Messages: 18
Registered: November 2005
|
Promising Member |
|
|
I didn't actually read all the way through your post, I noticed this:
sql * Insert(TABLE)(C0, "a")(C1, 1)(C3, 2)
if(duplicate())
sql * Update(TABLE)(C0, "a")(C1, 1)(C3, 2)
In sqlite, at least, you can use "REPLACE" to insert or update. According the the sqlite documentation, it's also in mysql:
http://www.sqlite.org/lang_replace.html
Perhaps that should be added to the sql interface.
=)
- Augusto
|
|
|
|
Current Time: Mon Jun 23 02:11:35 CEST 2025
Total time taken to generate the page: 0.03919 seconds
|
Members
Pages
Help
Register
Login
Home
