Re: [sqlite] SELECT (string field) returns part of contents, then asterisks

2011-02-23 Thread Haldrup Office
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

[sqlite] SELECT (string field) returns part of contents, then asterisks

2011-02-22 Thread Haldrup Office
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

Re: [sqlite] SELECT (string field) returns part of contents, then asterisks

2011-02-22 Thread Simon Slavin
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

Re: [sqlite] SELECT (string field) returns part of contents, then asterisks

2011-02-22 Thread Puneet Kishor
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