X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:from:date:message-id:subject:to
	:content-type; q=dns; s=default; b=UOK9o5+FTBRSxdWjQPdSdiI7zHmur
	mrcquVjclb7xESiAMdXH2M97BKyVC9MPaMH7hM+HVh1vRaTTTXfy7h4yNxaHXGh4
	KEZm/7EuJ9C/gLiwmax++e5ibtDsJ6vJntYJRRFpW2KZuR5mx6hwCtGFmapRgYNa
	KqW+bUvzjXngao=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:from:date:message-id:subject:to
	:content-type; s=default; bh=st4rGt4tSzfBKYFfIZUtkdfamu4=; b=hvI
	4pcN/qyKRDPG5y9Mfc5HIJnbVrbm5ahSOTOK2GiP4coo19pdZGY3fke8uvGk0h9N
	oPVJDIpA2vcrrgkocpXS4rnqcAMGFhn9Yw5V2U+FI60KB+vlwLmBhfYH6XkLs7c9
	GqQbgBr3Xx/dHHdL8b1WQlB39ngZbK2OB9E58lNk=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Authentication-Results:	sourceware.org; auth=none
X-Virus-Found:	No
X-Spam-SWARE-Status:	No, score=-1.6 required=5.0 tests=AWL,BAYES_00,FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS autolearn=ham version=3.3.2 spammy=TCL, 3201, Hx-languages-length:1516
X-HELO:	mail-pg0-f45.google.com
X-Google-DKIM-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=R7C0o/2BAKZA3JP3akhafHe6YpiEXrAipgYd6SmkPGA=; b=R2mYMcUPXqaJAQzMCWIV3msDOt/TgV3y6x/BobT4S+8FkWBao3v0RAHj2GGoGWQf2G /G2U3HD3qH+ZvGubfxuzQuW5pp2I4ymN5tgJcByha/aTpkTdG1kvZV3gcVJTw/2vTXw8 aStMbu2dRkF4vIU4V8edY7xLn9ZW0OYdLFlgsG1sE4veKe9ec6KQyBzgwYmtSW1dZGlt pfZxU27bi3Jyh9LDSv/9RcMOOMIl1SpB3k/c89iFY3U60azG2BUcLaKNrq6BmzWq73Lg 0iz0LUwwa+KzwKxQRvpxg3Nq7A4tzki8//dXAB+C4JbFgFyKp+KyFG5Fg8tVHTzA1jAL l30w==
X-Gm-Message-State:	AHPjjUhbJebfGvRCCcjtOAZT6HrCloatcZchegAEFfnXCzrg9Uo8IYHC 8QT9sUCsktDPDsRbOKd3rzryZJ1LfdWf
X-Google-Smtp-Source:	ADKCNb7tCB4DX1vTVl8xQ7aCLi09yRml8VKdeHCrDjf1iOutSQAwc3XtCmYVFxtfZFg/w/gxfUYg+GJIWxb6yKQpg8o=
X-Received:	by 10.101.75.4 with SMTP id r4mr9600854pgq.265.1505077800198; Sun, 10 Sep 2017 14:10:00 -0700 (PDT)
MIME-Version:	1.0
From:	Keith Christian <keith1christian AT gmail DOT com>
Date:	Sun, 10 Sep 2017 15:09:59 -0600
Message-ID:	<CAFWoy7FZt30FaFEog7S9aTMo2u1Kh_YHY-8gyUqjXRDa8R6HwQ@mail.gmail.com>
Subject:	Compiling the Sqlite3 v 3.20.1 libsqlite3.x.y.dll on Cygwin
To:	cygwin AT cygwin DOT com
X-IsSubscribed:	yes

What .dll should be compiled or loaded to execute a TCL program
including the SQLite library as shown in this fragment, which used to
work a few years ago?


        #!/usr/bin/tclsh
        load libsqlite3.8.3.dll "SQLite3"
        sqlite3 db1 ./tcl_interface.db
        puts ""
        puts "Dropping table t1"
        puts ""
        db1 eval {DROP TABLE IF EXISTS t1}
        db1 eval {CREATE TABLE IF NOT EXISTS t1(a int, b text)}
        db1 eval {INSERT INTO t1 VALUES('1','hello')}
        db1 eval {INSERT INTO t1 VALUES('2','goodbye')}
        db1 eval {INSERT INTO t1 VALUES('3','howdy!')}
        close db1


I downloaded and extracted the the amalgamation as done previously:

       2069637 Sep 10 14:36 sqlite-amalgamation-3200100.zip


Then ran this gcc command provided by Dr. Hipp a few years ago:

        gcc -o sqlite3.exe -I. sqlite3.c shell.c


No libsqlite3.x.y.z.dll in the current directory as before.  These
DLL's were created in a subdirectory, howver:

        find . -type f -name 'libsqlite3*' -exec ls -dl {} +
        -rw-rw-rw-+ 1 KChris0000 Domain Users 5414520 Sep 10 14:46
./.libs/libsqlite3.a
        -rw-rw-rw-+ 1 KChris0000 Domain Users  159728 Sep 10 14:46
./.libs/libsqlite3.dll.a
        -rw-rw-rw-+ 1 KChris0000 Domain Users     912 Sep 10 14:46
./.libs/libsqlite3.lai
        -rw-rw-rw-+ 1 KChris0000 Domain Users     904 Sep 10 14:46
./libsqlite3.la


From here, with Sqlite3 v3.20.1, how to create a .dll as before?  Or
is the method of loading libsqlite3 different now?

        #!/usr/bin/tclsh
        load libsqlite3.8.3.dll "SQLite3"
        sqlite3 db1 ./tcl_interface.db


Thanks,

Keith

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

- Raw text -