Re: [sqlite] SELECT (string field) returns part of contents, then asterisks
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
Re: [sqlite] SELECT (string field) returns part of contents, then asterisks
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
Re: [sqlite] SELECT (string field) returns part of contents, then asterisks
On 22 Feb 2011, at 3:03pm, Haldrup Office wrote: > 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. Use the command-line tool to look at the same data: http://www.sqlite.org/sqlite.html See if your problem is with the data in the file or the method you're using to access it. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users