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?
Welcome to the wonderful world of floating point numbers :-)
I always store money values as cents (or as integers, what ever your
currency might call it) and move the decimal to format for display..
Randall Fox wrote:
After reading the FAQ and type information over, I went and tried the
following
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 52.8000
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 th
Mr. Warren was kind to provide me the code for Palm OS
port of Sqlite(I incorrectly mentioned "Mr. Wayne" in
my last mail; the work has been done by Mr. Warren
Taylor). He has generously permitted me to add the
code to wiki. Since I cannot add the code to wiki due
to its limitations I have uploade
There is a PalmOS port of SQLite available. Mr. Taylor
on this list kindly sent me the code of his work on
the Palm port. I have not tested it on Palm Vx but I
do believe it works(Mr. Wayne can correct me if I am
wrong). I am working on Palm OS 6 port of SQLite but
haven't been able to get far as m
I tried to upload the code to the wiki but wasn't able
to do so due to 100K limit of the attachment. Over the
weekend I will upload the code to my own site and post
the link on this list as well as update the wiki :-)
- Jalil
--- "Clark, Chris" <[EMAIL PROTECTED]> wrote:
>
>
> > -Original M
> 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' substitut
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&D 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 par
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
inv
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
> ...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:
>
> 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 th
"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 parti
Mitchell Vincent wrote:
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
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, quer
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. W
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 record
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
-
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
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, queried/wr
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: [
> 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 wit
> 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 wit
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 totall
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
To
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 pas
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 of
28 matches
Mail list logo
