[Zope] Re: SQL prob on SAPDB

[Daniel Dittmar]

Vitor Varalonga wrote:
>     I need to copy the data from one table to another, on my SAPDB
> database. If I where working with a SQL Server DB I would run the
> following query:
> 
> INSERT INTO TableB (fieldB1, fieldB2)
> SELECT fieldA1, fieldA2 FROM TableA ORDER BY fieldA1
> 
> But it seems that it doesn't work on SAPD, since it returned me
> the following error message:

Don't use the ORDER BY clause, it isn't really useful for the INSERT anyway.

> Sorry for the somehow off-topic non-zope question, but I would really
> appreciate if someone could please enlighten on this.

Post these questions on the SAP DB mailing list: 
http://listserv.sap.com/mailman/listinfo/sapdb.general

You can access it also as a newsgroup through gmane: 
news://news.gmane.org/gmane.comp.db.sapdb.general


Daniel Dittmar

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
daniel.dittmar@sap.com
http://www.sapdb.org