Re: [sqlite] Problem with sqlite3 .import command

On 28 Jun 2018, at 9:21am, Константин Краснов wrote: > However, a table with name " my-test-table" was created in the database and > is empty > > sqlite> .schema > CREATE TABLE [my-test-table]( > "col1" TEXT, > "col2" TEXT > ); Dear Konstantin, The above is not showing a table with the name

[sqlite] Problem with sqlite3 .import command

Then i try to import following .csv file col1;col2 1;1 2;2 3;3 with .import command into a table with name what contents "-" sign sqlite> .open test.db sqlite> drop table if exists [my-test-table]; sqlite> .mode csv sqlite> .separator ; sqlite> .import 'my-test-table.csv' [my-test-table] And

Re: [sqlite] Problem loading sqlite3.dll on Windows XP

2016-05-25 13:35 GMT+02:00 Costache, Catalin : > Hi, > > I am using the provided sqlite3.dll from the download section which causes > problems in Windows XP. > > Our application uses a dynamic dll which is statically linked to sqlite3.dll > (32 bit) using a lib

Re: [sqlite] Problem loading sqlite3.dll on Windows XP

> I am using the provided sqlite3.dll from the download section which causes > problems in Windows XP. > > Our application uses a dynamic dll which is statically linked to sqlite3.dll > (32 bit) using a lib generated from the dll and def file. On Windows 7 there > is no problem, but on windows XP

[sqlite] Problem loading sqlite3.dll on Windows XP

Hi, I am using the provided sqlite3.dll from the download section which causes problems in Windows XP. Our application uses a dynamic dll which is statically linked to sqlite3.dll (32 bit) using a lib generated from the dll and def file. On Windows 7 there is no problem, but on windows XP

[sqlite] Problem on sqlite3 backup_init

Dear all, I am facing a problem while using the sqlite3_backup_init, the error code returned by the loadOrSaveDb function is 21. Here below the code, the function "loadOrSaveDb" was taken as is from your web site. Any hint? Kind Regards. Vincenzo. sqlite3 *conn; CHAR

Re: [sqlite] Problem with sqlite3

_ From: sqlite-users-boun...@sqlite.org on behalf of Chris 'Xenon' Hanson Sent: Wed 6/2/2010 8:11 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with sqlite3 On 6/2/2010 9:56 AM, lukasz aaa wrote: > Hello. Sorry for my English. > I have a problem with the SQLite libr

Re: [sqlite] Problem with sqlite3

On 6/2/2010 9:56 AM, lukasz aaa wrote: > Hello. Sorry for my English. > I have a problem with the SQLite library reloaded correctly (use in > project). I'm using VC++ 2010 and Dev. > I add to project sqlite3.h, copy to folder with source sqlite3.dll and > sqlite3.lib. I add sqlite3.lib to linker -

Re: [sqlite] Problem with sqlite3

Lukasz, I think the function you're trying to call is named sqlite3_open. Regards, Peter Kolbus On Wed, Jun 2, 2010 at 10:56 AM, lukasz aaa wrote: > Hello. Sorry for my English. > I have a problem with the SQLite library reloaded correctly (use in > project). I'm using VC++ 2010

[sqlite] Problem with sqlite3

Hello. Sorry for my English. I have a problem with the SQLite library reloaded correctly (use in project). I'm using VC++ 2010 and Dev. I add to project sqlite3.h, copy to folder with source sqlite3.dll and sqlite3.lib. I add sqlite3.lib to linker - i search information on forums, but can't

Re: [sqlite] Problem with SQLite3

2009/6/5 Ann Shipley : > I am trying to install Google Adwords Editor and when it attempts to open I > receive a message "AdWords Editor has stopped working.  A problem has caused > it to stop working correctly.  Windows will notify if there is a solution." > Then a window

[sqlite] Problem with SQLite3

I am trying to install Google Adwords Editor and when it attempts to open I receive a message "AdWords Editor has stopped working. A problem has caused it to stop working correctly. Windows will notify if there is a solution." Then a window opens stating "Solve a problem with SQLite3" and when I

Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C

On 12/15/06, Francesco Andrisani <[EMAIL PROTECTED]> wrote: Hi comunity, i have the follow problem. I've insert into a C-CGI page a small sqlite3 code. When i call the page from a browser, it exec a query and show on browser the entries, but it don't work. If i add a "printf" above the

Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C

Here is fixed your bug.. :D.. I'd use the Option 2. Option 1: printf("\nhello [1]"); if (sqlite_open("myDB.db", )) error_handle(db); printf("\n hello [2]"); Option 2: printf("\nhello [1]"); if (sqlite_open("myDB.db", )) { error_handle(db); } printf("\n hello [2]"); On 15/12/06, John

Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C

How do you set the working directory? Where is your Sqlite DB file? You are just opening a file name, not a pathname so your working directory is whatever your web server uses for CGI data. Francesco Andrisani wrote: Hi comunity, i have the follow problem. I've insert into a C-CGI page a

Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C

Francesco Andrisani wrote: if (sqlite_open("myDB.db", )); The semicolon at the end of this line means your error_handle() will always get called. Martin - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Problem with sqlite3 on CGI scripts with ANSI C

Hi comunity, i have the follow problem. I've insert into a C-CGI page a small sqlite3 code. When i call the page from a browser, it exec a query and show on browser the entries, but it don't work. If i add a "printf" above the sqlite3_open() it print the message, but if i put the instruction

Re: [sqlite] problem with sqlite3 in lazarus

Sqlite does not use VARCHAR(n) or NUMERIC(s,p). Read up about manifest typing in the documentation and just declare columns as underlying types such as TEXT. You can declare the column as anything you like, but Sqlite makes its own decision as to what it will be. Carlos Avogaro wrote: Hi,

Re: [sqlite] problem with sqlite3 in lazarus

Carlos Avogaro <[EMAIL PROTECTED]> wrote: > > but when I open a recorsed SELECT * FROM PRODUCT from lazarus I received > this messages, FIELD TYPE VARCHAR(6) NOT RECOGNIZED. > This appears to be an issue with lazarus. Your query is correct as written. -- D. Richard Hipp <[EMAIL

[sqlite] problem with sqlite3 in lazarus

Hi, I have sqLite version 3.3.6, and I'm using with lazarus in windows. With sqlite3.exe, I created this table create table product (cod varchar(6), ean varchar(13), desc varchar(30), pvp numeric(10,2)) from lazarus I did 4000 insert, like this: insert into product values

[sqlite] Problem Installing sqlite3 in redhat linux 9 i686 machine

Hello, I tried compiling the source sqlite3-3.2.1 with the following commands on a i686 machine distro rehat linux 9 with the following commands, ./configure make make install And the above process returns successful message and all the lib* libraries are present in /usr/local/lib, i can also