[yunqa.de] Re: DISQLite3UniDirQuery results don't match same query run in db manager
- From: H M <docshotmail2@xxxxxxxxxxx>
- To: DISQLite3 mailing list <yunqa@xxxxxxxxxxxxx>
- Date: Wed, 25 Sep 2013 13:05:00 +0000
Sorry Ralf I now realise I asked something very similar before and after a very
good effort on your behalf you provided two solutions on 22/10/2012 .
For anyone else reading, the issue is that as I generate the sql in Pascal
using user input and other calculatiuons to form the sql, DISQLite3UniDirQuery
does not know the data types of some calculated fields when it runs the sql.
Both of Ralf's solutions work but for my application it actually simplified my
code to just send the output of the sql to a temporary table and then use
DISQLite3UniDirQuery to query the temp table instead. That keeps it happy with
data types.
Regards
Howard
> Date: Wed, 25 Sep 2013 10:15:01 +0200
> From: delphi@xxxxxxxx
> To: yunqa@xxxxxxxxxxxxx
> Subject: [yunqa.de] Re: DISQLite3UniDirQuery results don't match same query
> run in db manager
>
> On 24.09.2013 15:54, H M wrote:
>
> > I have some sql that, when run through my db management s/w
> > (SQLiteExpert Pro), produces 4 columns of numbers (3 integers and 1 float).
> > However, the same sql, copy/pasted into DISQLite3UniDirQuery, produces
> > two columns of integers and two columns of just zeros!
> >
> > I don't use persistant fields as the query component is general purpose
> > and gets loaded with many different sql statements.
>
> Can you please post a complete test project (source code only, no
> binaries) plus a small sample database for inspection? I would need your
> exact code and data to reproduce your problem.
>
> Ralf
> _______________________________________________
> Delphi Inspiration mailing list
> yunqa@xxxxxxxxxxxxx
> //www.freelists.org/list/yunqa
>
>
>
Other related posts:
