 |
 |
11-03-2005, 01:06 AM
|
|
Regular
|
|
Join Date: Dec 2003
Location: The Netherlands
Posts: 97
|
|
adodb query syntax
|
Hello,
I'm (still) using adodb to exhange data between excel files. The query syntax differs a bit from for example MySQL. I'd like to know what the syntax is for an update query, and where i can find the syntax. I've searched in this forum, with google and in msdn but i couldn't find it.
Werner
|
|
11-03-2005, 06:06 AM
|
 |
Keeper of foo
Retired Moderator
* Guru *
|
|
Join Date: Nov 2001
Location: Graceland
Posts: 15,612
|
|
|
UPDATE tablename SET field1='value1', field2='value2', fieldX='valueX' [WHERE criteriafield='somevalue']
|
__________________
~ Quod non mortiferum, fortiorem me facit ~
Avatar by lebb
|
11-04-2005, 01:23 PM
|
|
Regular
|
|
Join Date: Dec 2003
Location: The Netherlands
Posts: 97
|
|
It doesn't work
|
I'm sorry reboot but your code doesn't work. I tried the code with 'or ` before and after the tablename. Thanks anyway for your reply
Has someone an idea where to find a solution, book or tutorial.
|
|
11-04-2005, 01:50 PM
|
 |
Google Hound
Retired Moderator
* Guru *
|
|
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,378
|
|
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
Last edited by loquin; 11-04-2005 at 01:59 PM.
|
11-04-2005, 01:53 PM
|
|
Google Hound
Retired Moderator
* Guru *
|
|
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,378
|
|
Or, MS
http://support.microsoft.com/default...22120121120120
Remember, you need to wrap your table name (worksheet name) with either square brackets, or with apostrophes. In addition, worksheet names need to be suffixed with the dollar sign ($)
Update [SHEET1$] Set [Column1] = 7 where [Column2] = '12345' |
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
Last edited by loquin; 11-04-2005 at 01:59 PM.
|
11-05-2005, 01:21 AM
|
|
Regular
|
|
Join Date: Dec 2003
Location: The Netherlands
Posts: 97
|
|
|
The brackets around the column name i didnot trie yet. That's the firtst thing i'll try.
The tut from Herilane gives me no help with the sysntax problem. It did help me with making a connection and a recordset.
Thanks for your reply
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|
|
|
 |
|
