SQL Forms

Features

• Automatically generate list,add,edit methods
• You have special fields (non SQL fields) with incremental values,
  useful for primary key and made in a portable SQL format
• Select security check script for each list,add,edit method
• edit fields, create/drop table
• Change fields display order
• use standard HTML form fields and some new fields (select, list and date) to fill the forms
• list and select fields are build from other SQL tables (by a query)

Common mistakes

• Avoid to use reserved SQL fieldnames such as id,name,date,type,int,file,text,user,all
• Check sql field size (avoid to be too small) or data will be truncated
• Update options but don't edit directly the list,add,edit methods
• Update options when you get an error
• Avoid to use invalid names or chars into names (like " or ')
  • Homepage:
    http://ioan.freezope.org/
  • Contact Email:
    [email protected]