update Valentina DB

Ruslan Zasukhin sunshine at public.kherson.ua
Wed Jan 12 11:00:44 CST 2005


On 1/12/05 10:39 AM, "Martin Kloss" <martin.kloss at gmx.de> wrote:

> At 20:57 11.01.2005, you wrote:
>> for example script in Director:
>> 
>> myCursor = db.query("INSERT INTO Artikel (ArtikelNr,Name, Beschreibung)
>> VALUES ('136428744', 'Fleece','bla bla bla', Null);")
>> 
>> UpdateRecord(myCursor)
>> 
>> Valentina Error 2 Why?
> 
> Hi Beatrice,
> 
> it looks like you're using my Valentina DB class, hence Ruslan
> mentioned that a db.query() call does not exist in Valentina ;-)
> Anyway, I think the problem is just the ";" at the end of the
> SQL statement, it looks like you're importing queries from a
> SQL dump from, say mySQL. It should work if remove the semicolon.
> And make sure you're using the latest V4MD 1.x version.

Martin, Valentina 1.x will not eat many SQL commands in one line.
They must be sent separately.

Valentina 2.0 can do this.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------




More information about the Valentina mailing list