[EMAIL PROTECTED] said: > I have run into problems trying to use SQLite via perl DBA. > According to the SQLite.org web site, DECLARE CURSOR should be supported > (actually, it is not in the list of the only SQL not supported). > I get a error saying "error near DECLARE". I have tried to declare cursor > in many ways but always get the same error. > If "cursro" is not supported, does anybody have a suggestion on how to > achieve the same end?
The prepared statement API gives you most of the features of cursors as far as progressing through the database is concerned. Not too swell for supporting writes in the middle of your queries though. Clay -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
