Hi Team,
Need ur expertise with below 2 problems
1) how to make a table read only, such that any user can only insert but can't
update (table schema) or drop the table
alter table / drop table arent allowed on sqlite_master, need similar
restrictions on my custom table.
by setting the tabFlags to TF_Readonly, i m able to prevent the user from
dropping the table but
alter table is still allowed (can add or drop columns)
2) How to apply constraints similar to given below as part of create table
statement, if not possible can it be done after create statement?
table sales(cost price, sale price)
i need a constraint cost price < sale price so that i dont have to do code
level checks during insert statements
thanks and regards
Rakesh Hemrajani
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
