[sqlite] [newbie] SQLite + VB.Net 2005?

Hello I just started learning VB.Net with "The Book of Visual Basic 2005", and would like to use SQLite, but I don't know where to start, as the wrappers I found usually only have C# samples, and assume the reader knows how to install those wrappers... which I dont, yet :-/ Would someone have a

Re: [sqlite] Create table error on AIX -- Unable to open database "mytest": SQL logic error or missing database

John Stanton wrote: > > I had a problem compiling Sqlite on ealrier > versions of AIX. It turned out to be a linker > problem and compiling without the -g optimization > solved the problem. The configure process shows an entry that says: checking whether accepts -g... no I edited the

[sqlite] Limit Column Width

How can I limit the width of column returned by a query? In a bash script I am returning an ID, and a text field from a table. The text field can be any length, contain newlines, etc. The problems is if a row of results contains a new line, the "grid" of rows and columns is messed up. I can

Re: [sqlite] What is the standard way to store dates and do operations with dates please?

On Apr 6, 2008, at 5:12 PM, John Stanton wrote: > Not a hack, but the traditional way to store dates and times. Sqlite > functions use a magic epoch which facilitates the presentation of the > date and time in the form of the major calendars. > > We do not use the Julian calendar these days. It

Re: [sqlite] Create table error on AIX -- Unable to open database "mytest": SQL logic error or missing database

I had a problem compiling Sqlite on ealrier versions of AIX. It turned out to be a linker problem and compiling without the -g optimization solved the problem. What compiler are you using? Xlc or gcc? Chris Pierce wrote: > Hi, > > I am having problems with SQLite v3.5.7 on AIX v5.2. > > I

Re: [sqlite] What is the standard way to store dates and do operations with dates please?

Not a hack, but the traditional way to store dates and times. Sqlite functions use a magic epoch which facilitates the presentation of the date and time in the form of the major calendars. We do not use the Julian calendar these days. It was supplanted by the Gregorian in 1582. Julian

[sqlite] problem with undefined reference

May I suggest you don't use precompiled packages when they are not "official" (i.e., included in Slackware distribution) ones, but make your own packages. Yuu can find Slackbuilds for sqlite-3.5.7 on slackbuild.org and salcky.eu websites for that purpose. There is a typo in your command: