Re: [sqlite] .net Sqlite lib reading date fields not working?

Could treat it as datetime -Original Message- From: Joe Mistachkin Sent: 5/30/2013 9:44 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] .net Sqlite lib reading date fields not working? eschneider FE > > Solved it. > Great. I'm curious, which connection string

Re: [sqlite] .net Sqlite lib reading date fields not working?

eschneider FE > > Solved it. > Great. I'm curious, which connection string properties did you end up using? > > You cannot use parameter DbType.DateTime2 and must use DbType.DateTime for > the lib to format the date upon insert. > Right, DbType.DateTime2 is not recognized by

Re: [sqlite] .net Sqlite lib reading date fields not working?

Solved it. You cannot use parameter DbType.DateTime2 and must use DbType.DateTime for the lib to format the date upon insert. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of eschneider FE Sent: Thursday, May 30, 2013

Re: [sqlite] .net Sqlite lib reading date fields not working?

eschneider FE wrote: > > So are you say we can specify the exact format string in the connection > string? > As of yesterday, yes. > > How would that look? > ; DateTimeFormatString='XXX' > Probably something like: "Data

Re: [sqlite] .net Sqlite lib reading date fields not working?

Joe, So are you say we can specify the exact format string in the connection string? How would that look? ; DateTimeFormatString='XXX' Would I need to download a new .NET API or Sqlite version? Eric -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] PRAGMA reverse_unordered_selects and GROUP_CONCAT

Mark Lawrence wrote: > I'm hitting an issue with ordering and GROUP_CONCAT that seems to > depend on whether the reverse_unordered_selects pragma is enabled, > and/or non-aggregate terms are also selected. > > reverse_unordered_select with non-agg result >

Re: [sqlite] .net Sqlite lib reading date fields not working?

I used a connection string for ;DateTimeKind= DateTimeKind.Utc but my inserts are still incorrect: "91","Eric","Schneider","Paul","11/27/1972 12:00:00 AM","1" I don't think the inserts for parameter are formatting the date. I don't believe this is UCT format. I have also confirmed that my UI

Re: [sqlite] Fw: problem sqlite3 c++ please

specific to your question, if you want to import/export with C API, you can try these extensions https://github.com/fnoyanisi/sqlite3_capi_extensions From: Fehmi Noyan ISI To: General Discussion of SQLite Database

Re: [sqlite] Fw: problem sqlite3 c++ please

Hi, The command you entered, starting with dot, are sqlite shell commands, i.e. if you need similar functionality, you either * need to check SQLite C/C++ API documentation for a fucntion  or * need to implement your own function From: Maxime Gerum

Re: [sqlite] Fw: problem sqlite3 c++ please

On Wed, May 29, 2013 at 4:31 PM, Maxime Gerum wrote: > > it works, but in c++, if i make request[4]= ”.mode csv” > .mode is a command from the shell program sqlite3, and is not valid SQL. The C API only knows SQL, so you'll have to write the import/export code yourself or

Re: [sqlite] problem sqlite3 c++ please

On 29 May 2013, at 3:31pm, Maxime Gerum wrote: > it works, but in c++, if i make request[4]= ”.mode csv” The commands which start with '.' are not part of SQLite. They work only in the shell tool. Simon. ___ sqlite-users

[sqlite] PRAGMA reverse_unordered_selects and GROUP_CONCAT

Hi, I'm hitting an issue with ordering and GROUP_CONCAT that seems to depend on whether the reverse_unordered_selects pragma is enabled, and/or non-aggregate terms are also selected. reverse_unordered_select with non-agg result -- ON

[sqlite] Fw: problem sqlite3 c++ please

Hello, i’m french, sorry if i make errors of langage In my school project, i use sqlite3 with c++, i can make any request such as create table or select *from, no problems. But i would export my database in a csv file, in sqlite3> .mode csv

Re: [sqlite] I'm wondering how to use Sqlite3 API to make change on configuration

On 30 May 2013, at 6:32am, Sunki Cheon wrote: > Sqlite3 site says users can fix the configuration, like *scratch memory > size, shared_memory, page cache size* etc, by using Sqlite3 > API(sqlite3_config). But I'm not familiar with using sqlite and dbt2(I'm > doing my