Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Igor Korot
Or for the simplicity sake - just add the sqlite3.* files to the project and compile everything. But then you will NOT need to follow the instruction in my previous email. As Keith said, you should choose the path and follow it - either use the source code or use precompiled library. Thank you.

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Igor Korot
Hi, It is in the Properties->Linker->General->Additional Library Directories. Don't remove the things that is already there - just append you path to the end. Thank you. On Fri, Dec 21, 2018 at 7:18 PM zydeholic wrote: > > Hi Igor, > I've looked and I don't see those exact words. If you can, it

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Keith Medcalf
To compile the sqlite3.c file to sqlite3.dll you need to create a separate project that will "compile" sqlite3.c (as a "C" file) with the dependency sqlite3.h and tell VS to output a "DLL" / Dynamic Link Library rather than an EXE file. The ".lib" is the built from the symbols exported into th

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread zydeholic
So, and sorry if this is covering ground already covered, but if I wanted to compile my own DLL and .lib file, I would do what exactly? Just not tell it about the .lib dependencies?  And not put the lib and dll files in my project directory?  Sorry for my denseness.  I'm very knew to this route

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread zydeholic
Hi Igor, I've looked and I don't see those exact words.  If you can, it would be helpful to know the route to get there, like Linker>>Input>>??? Thanks for your time. From: Igor Korot To: SQLite mailing list Sent: Friday, December 21, 2018 4:47 PM Subject: Re: [sqlite] Need

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Keith Medcalf
No problem. You can of course omit the sqlite3.c file and use the sqlite3.lib/sqlite3.dll combination, but your application will then be dependent on the version of sqlite3.dll that happens to be found at runtime and the options that were used to compile it. If you use the sqlite3.c directly

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread zydeholic
Holy Chewbacca, I removed the .c file from the project and I got an error free compile.  Yes, I knew my code would not do anything, except prove that I was able to talk through to something.  I'll try your code below.  Thanks MUCHO. David From: Keith Medcalf To: SQLite mailing list

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Keith Medcalf
First of all use EITHER the source (.c) OR the precomiled dynamic link library (.dll/.lib). Not both. The .c file contains the code to the sqlite3 database engine. The DLL contains this code compiled to a Dynamic Link Library. The LIB file tells your application how to find the code in th

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Igor Korot
Hi, On Fri, Dec 21, 2018 at 6:26 PM zydeholic wrote: > > My cpp code consists of this at the moment: > #include "sqlite3.h" > #include > #include > using namespace std; > > int main() > { > sqlite3 *db; > } > > I have added sqlite3.h to my header files.I have added sqlite3.c to my source >

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread zydeholic
My cpp code consists of this at the moment: #include "sqlite3.h" #include #include using namespace std; int main() {     sqlite3 *db; } I have added sqlite3.h to my header files.I have added sqlite3.c to my source files.I've moved these two files, plus sqlite3.dll and sqlite3.lib into the sam

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Keith Medcalf
C++ is just C with mungified names and structures with pointers. You can call C functions from C++. You compile the "C" stuff as "C" and the "C++" stuff as "C++". You then link them together to produce as executable. In order to generate a "load module" output (ya know, that EXE thing that y

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread zydeholic
Ok, to further define my goals, I am not looking to compile the files into a final EXE, unless that is the only way I can use it with my program.  I want to tap into the sqlite functionality from a C++ application I am writing.  I suppose I need to use the DLL that I downloaded, but have never

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Scott Doctor
Try creating a fresh project, call it sqliteshell.exe The amalgamation zip has a file called shell.c Add the files shell.c, sqlite3.c, and sqlite3.h to the new project compile. See if you still get any errors. The shell.c program is the command line utility. See if you still get any errors.

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Larry Brasfield
Zydeholic wrote: ➢ I compile and get one error: Severity    Code    Description    Project    File    Line    Suppression State Error    LNK2001    unresolved external symbol _sqlite3_version    sqlite_try_3    C:\Users\DSNoS\source\repos\sqlite_try_3\sqlite_try_3\sqlite3.obj    1 That symb

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

2018-12-21 Thread Simon Slavin
On 21 Dec 2018, at 5:54pm, James K. Lowden wrote: > If the assigning body didn't intend the "number" as a quantity, it's > not. Treating it as such will often come to tears. I've seen this argument phrased as "Are you going to do maths on it ? If not, don't store it as a number.". And yes,

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread zydeholic
Thanks for responding Deon, Ok, I took the two sqlite3.c and sqlite3.h files, fresh from an amalgamation extract, put them in the project, and set .c to "Not using precompiled header", All platforms, all configurations. I compile and get one error: Severity    Code    Description    Project    F

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

2018-12-21 Thread James K. Lowden
On Thu, 20 Dec 2018 15:42:27 + Chris Locke wrote: > and a model number is a numeric number My phone's model number is VVX 500. > set the column affinity to the type of data Yes, and not everything that looks like a number is a number. Some things that start out looking like numbers chan

Re: [sqlite] Doing math in sqlite

2018-12-21 Thread Jungle Boogie
On Thu 20 Dec 2018 4:21 PM, Jungle Boogie wrote: > Hi All, > > This is more of a how do I do this in sql question. I apologize in advance > for a simple question, but I need to learn somehow, so any pointers are > appreciated. Thank you all for the helpful replies and education on doing math w

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

2018-12-21 Thread Deon Brewis
Right-click on the sqlite3.c file in your Visual Studio project, click on properties, then under C/C++ go to Precompiled Headers, and change the setting for "Precompiled Header" to "Not using precompiled header". Make sure to do this for "All Configurations" and "All Platforms" (at the top of t