**NAS_DB_OBJECTS** rs1.prg_projects.created_from, 1, text, 3, 1 rs1.prg_projects.group_right, 2, text, 3, 1 rs1.prg_projects.user_right, 3, text, 3, 1 rs1.prg_projects.timestampfield01, 4, timestamp, 3, 1 rs1.prg_projects.timestampfield02, 5, timestamp, 3, 1 rs1.prg_projects.timestampfield03, 6, timestamp, 3, 1 rs1.prg_projects.intfield01, 7, int8, 3, 1 rs1.prg_projects.intfield02, 8, int8, 3, 1 rs1.prg_projects.intfield03, 9, int8, 3, 1 rs1.prg_projects.intfield04, 10, int8, 3, 1 rs1.prg_projects.intfield06, 11, int8, 3, 1 rs1.prg_projects.field01, 12, text, 3, 1 rs1.prg_projects.field02, 13, text, 3, 1 rs1.prg_projects.field03, 14, text, 3, 1 rs1.prg_projects.field04, 15, text, 3, 1 rs1.prg_projects.field05, 16, text, 3, 1 rs1.prg_projects.field06, 17, text, 3, 1 rs1.prg_projects.field07, 18, text, 3, 1 rs1.prg_projects.field08, 19, text, 3, 1 rs1.prg_projects.field09, 20, text, 3, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT created_from, group_right, user_right, timestampfield01, timestampfield02, timestampfield03, intfield01, intfield02, intfield03, intfield04, intfield06, field01, field02, field03, field04, field05, field06, field07,field08,field09 FROM prg_projects** **NAS_WHERE = WHERE intfield01 = |**vkn**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs1** Groupware - **OX_APP_TITLE**
   Project    
 **rs1.prg_projects.field01**  
**ERROR-MESSAGE**
Do you realy want to delete this project?
 Project
Name: **rs1.prg_projects.field01**
Start date: **rs1.prg_projects.timestampfield01**
End date: **rs1.prg_projects.timestampfield02**
Follow-up: **rs1.prg_projects.timestampfield03**
Status: **rs1.prg_projects.field05** 
Type: **rs1.prg_projects.field04** 
Leader: **rs1.prg_projects.field03** 
External participants: **rs1.prg_projects.field06** 
Customer: **rs1.prg_projects.field07** 
Assigned Jobs
Delete assigned jobs?  Yes   No

**tasks_information**

Note: If you don't delete assigned jobs they will be detached from the project and assignement changed to "General Job"!