[sqlite] typeless in sqlitedataset?

i'm using sqlitedataset (http://sqlitedataset.sourceforge.net/cms/) for c++ programming. when i use function get_fType() to retrieve the filed_value datatype, it always is 0,which means string. is there a problem? and how could i tell the 1 is char "1" or integer 49?

Re: [sqlite] Adding and subtracting decimals is not accurate

Randall Fox wrote: After reading the FAQ and type information over, I went and tried the following: CREATE TABLE M (A numeric, B text); INSERT INTO M VALUES (1.2); INSERT INTO M VALUES (1.2); INSERT INTO M VALUES (1.2); . . ; did this about 45 times . . SELECT SUM(A) FROM M; result was

[sqlite] Adding and subtracting decimals is not accurate

After reading the FAQ and type information over, I went and tried the following: CREATE TABLE M (A numeric, B text); INSERT INTO M VALUES (1.2); INSERT INTO M VALUES (1.2); INSERT INTO M VALUES (1.2); . . ; did this about 45 times . . SELECT SUM(A) FROM M; result was 52.8001 Defining

Re: [sqlite] Join query help

> select customers.*, ctots.total > from customers, > (select customer_id cid, sum(invoice_amount) total >from invoice_master group by cid) ctots > where customers.customer_id = ctots.cid You're right -- sorry, I wan't paying attention. For 'customers, (subquery) where'

RE: [sqlite] re: academic software licensing (delphi)

Hi, no, i didn't realize that. both personal and at my payed job we still use delphi5.. this licensing issues makes it for us as independent R partner far to expensive to upgrade development tools on a frequent base.. i've been begging for a new delphi for ages now. ironically, one of our

Re: [sqlite] Join query help

Very nice, however that still only gives me the customer records if they have an invoice in the invoice_master table.. A sub-select or outer join or something of the sort is needed but I can't get it to work.. In PostgreSQL I might do : SELECT *,(SELECT sum(total) FROM invoice_master WHERE

RE: [sqlite] re: academic software licensing (delphi)

You do realize that you do not need BDE anymore to just use the TDataSet, right? Borland got rid of that requirement about 2 years ago (Around Delphi 6), if memory serves :) Other than that, I agree, the free edition is a totally acceptable choice. Shawn -Original Message- From: [EMAIL

Re: [sqlite] Join query help

> ...get all customers records, plus the sum of a column in the invoice... The idea is to get customer_id and the sum from the invoice table, then join that with the rest of the customer info. Of course, if you want to do it in one SQL statement, you have to write those steps in reverse order:

RE: [sqlite] re: academic software licensing (delphi)

"you get to use all of the great database functionality that Borland's VCL offer" unless of course you think borland's data-aware components aren't so great.. imho, they are just unnecessary overhead, making things more complex than they should and limit you in usage of features that makes

Re: [sqlite] Database Locking

I'm using SQLite on a Windows XP system with 1GB of RAM. I'm writing a server which spawns multiple threads for it's connections. It is querying and writing to an SQLite database within each thread. Whenever a query or insert/update statement is issued, the SQLite database is opened,

Re: [sqlite] Database Locking

In a message dated 6/4/2004 11:53:05 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: I'm using SQLite on a Windows XP system with 1GB of RAM. I'm writing a server which spawns multiple threads for it's connections. It is querying and writing to an SQLite database within each thread.

[sqlite] Join query help

So I'm sitting here in a pinch and my brain just refuses to work... 2 tables, a customer and an invoice table. What is the proper SQL to get all customers records, plus the sum of a column in the invoice table with a relation on the customer ID, but not all customers might have an invoice

[sqlite] SQLite::DB Perl Module Released

Folks, I an sharing, through CPAN, one perl module that provides an object oriented wrapper to SQLite databases using DBI and DBD::SQLite modules. http://search.cpan.org/~vxx/SQLite-DB-0.02/lib/SQLite/DB.pm Please feel free to send me feedbacks of it. Regards, Vitor

Re: [sqlite] palm pilot

Il giorno Wed, 2 Jun 2004 05:31:21 -0700 (PDT), tu oh prode Jalil Vaidya <[EMAIL PROTECTED]> hai scritto una mail. Il suo oggetto era"Re: [sqlite] palm pilot": > There is a PalmOS port of SQLite available. Mr. Wayne > on this list kindly sent me the code of his work on > the Palm port. I have not

[sqlite] Database Locking

I'm using SQLite on a Windows XP system with 1GB of RAM. I'm writing a server which spawns multiple threads for it's connections. It is querying and writing to an SQLite database within each thread. Whenever a query or insert/update statement is issued, the SQLite database is opened,

RE: [sqlite] re: academic software licensing (delphi)

Yes, but it you right the component around TdataSet you get to use all of the great database functionality that Borland's VCL offers, as well as tons of 3rd party components. Shawn -Original Message- From: Jay Macaulay [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:34 AM To:

Re: [sqlite] re: academic software licensing (delphi)

> hi- > > i dont think delphi 7 personal edition will work with sqlite (not 100% > sure though). > i believe i need more than a tdataset that works with sqlite to get it > to work with delphi 7 personal edition. > there is an alternative however. http://ibobjects.com seems to be very > generous

RE: [sqlite] re: academic software licensing (delphi)

Or do it with Klix and get platform portability :-) > -Original Message- > From: Shawn Anderson [mailto:[EMAIL PROTECTED] > Sent: Friday, June 04, 2004 9:22 AM > To: [EMAIL PROTECTED] > Subject: RE: [sqlite] re: academic software licensing (delphi) > > > Question: Why not use the

RE: [sqlite] re: academic software licensing (delphi)

Question: Why not use the totally free version of C++Builder and just create a VCL component for SQLite -- the VCL component can then be used from either C++ Builder or Delphi. Shawn -Original Message- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 10:18 AM

RE: [sqlite] re: academic software licensing (delphi)

With personal edition of Delphi, you will have to rely on third party software to gain some of the functionality of the more expensive versions. With personal edition you should have all you need to develop an API level interface to SQLite, if you wish to remain totally "free." If you have any

[sqlite] re: academic software licensing (delphi)

hi- i dont think delphi 7 personal edition will work with sqlite (not 100% sure though). i believe i need more than a tdataset that works with sqlite to get it to work with delphi 7 personal edition. there is an alternative however. http://ibobjects.com seems to be very generous with licensing

RE: [sqlite] sorry for the confusion re: academic software