Re: [sqlite] SQLite file Validation

2010-05-19 Thread Eric Smith
> Devs were told to make sure they are validating their sql statements, > but as I have seen in the code, few of them have > Question: Do you think that instead of getting them go back throughout > their code, it is feasible to create a function that just eliminates the ; > and replaces it wit

Re: [sqlite] SQLite file Validation

2010-05-19 Thread Dustin Sallings
On May 19, 2010, at 12:46, seandakid wrote: > Thanks for the quick reply Dustin. That was my concern as well.. it might > create more issues than it will solve. > > One of the devs suggested this code example: > > int makeSQLtight(const TCHAR* update); I'm all for developer laziness,

Re: [sqlite] SQLite file Validation

2010-05-19 Thread Black, Michael (IS)
on Systems From: sqlite-users-boun...@sqlite.org on behalf of Black, Michael (IS) Sent: Wed 5/19/2010 2:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite file Validation When you say "create a function" -- sure you can write y

Re: [sqlite] SQLite file Validation

2010-05-19 Thread Black, Michael (IS)
When you say "create a function" -- sure you can write your own program that would do that -- but it sounds like you want something to intercept all the calls, yes? You could create an insert or update trigger. Then write your own cleanup sqlite function to stick in the trigger. Shouldn't b

Re: [sqlite] SQLite file Validation

2010-05-19 Thread seandakid
Thanks for the quick reply Dustin. That was my concern as well.. it might create more issues than it will solve. One of the devs suggested this code example: int makeSQLtight(const TCHAR* update); S Dustin Sallings wrote: > > > On May 19, 2010, at 12:24, seandakid wrote: > >> Question: Do

Re: [sqlite] SQLite file Validation

2010-05-19 Thread Dustin Sallings
On May 19, 2010, at 12:24, seandakid wrote: > Question: Do you think that instead of getting them go back throughout their > code, it is feasible to create a function that just eliminates the ; and > replaces it with a ,? And if so, any suggested code? On one hand, you have something tha