[TYPO3-english] CREATE OR REPLACE VIEW on extension

[Bjoern Pedersen]

Am 20.07.2010 17:19, schrieb Sergio:
> Hi:
> 
> I've tried to add a new view to my own extension, but I can't get it to be
> created when I install the extension. All my tables are created when I
> install it except my view. The view syntax is correct inside ext_tables.sql
> because I could create it successfully inside phpmyadmin extension.
> 
> I've tried to add TCA array on ext_tables.php as I do with tables, but
> without success.
> 
> Do I have to do something special to create it?
> 
> I didn't see any documentation about it out there :(
> 
> Thanks in advance,
> Sergio
Hi,

Probably the TYPO3 sql parser does not understand the VIEWs. The
sql-file is not passed 'as is' to the database, but parsed and adopted
(e.g.  all create table calls for existing tables are changed to alter
table statements).

The  db-experts may give more details here.

Björn