Hello list, thanks for helping me out- I guess it was a limitation in the DLL. I resorted to ODBC now, using the SQLITE3ODBC.DLL from http://www.ch-werner.de/sqliteodbc/. Works like a charm.
Have a fine day, /T Den 22.02.2011 16:07, Puneet Kishor skrev: > On Tue, Feb 22, 2011 at 04:03:22PM +0100, Haldrup Office wrote: >> Hello list, >> >> I'm in the process of writing a little interface tool for notes and >> adress databases from an iPad. >> >> Using MS Word VBA and SQLite3_StdCall.dll. >> My query looks quite simply put: >> SELECT ROWID,creation_date,title FROM Note >> >> and it runs fine and returns w/o problems. >> >> When I iterate through it, though, and I try to read a long note (saved >> in field 'title') I happen to get some 2700 characters back plus a >> sequence of asterisks. > Probably a limitation of your "MS Word VBA and SQLite3_StdCall.dll" > > >> Am I missing something here? >> >> Thank you for your efforts, >> >> /T >> >> -- >> Med venlig hilsen, >> >> Thomas Besand >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- Med venlig hilsen, Thomas Besand J. Haldrup A/S Bredgade 129 DK-9670 Løgstør +45 98 67 10 33 +45 51 57 23 43 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users