Re: [sqlite] SQL help on preparing a report

[Simon Slavin]

On 31 Jul 2016, at 7:11pm, Ertan Küçükoğlu  wrote:

> I prepared
> an excel file with 3 sheets.

A few notes:

First, you cannot attach files to messages on this forum.  We do this on 
purpose because if we made it easy to post files people would just zip up their 
whole project, post it to the list, and expect us to make it work.  If you need 
us to see a file please put it on the web somewhere and post a pointer.

Second, we don't like doing people's homework.  It's possible that someone will 
bother to help you but you stand a better chance by explaining what you're 
having problems with.

I recommend that you read the documentation on expressions



and SQLite core functions



and then concentrate on asking us about specific calculations you need, 
explaining where you got stuck yourself.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL help on preparing a report

[Ertan Küçükoğlu]

Hello,

I am developing an application with SQLite. There is this report and my SQL
knowledge is not good enough to cope with it. I do not want to do all these
calculations by regular select statements and writing an application code.
Details;

I have below two tables in the same SQLite database file:
CREATE TABLE IF NOT EXISTS FIS(
  ID  Integer  NOT NULL PRIMARY KEY AUTOINCREMENT,
  UniqueIDChar(48) not null COLLATE NOCASE,
  EKU integer  not null check (EKU > 0),
  ZNo integer  not null check(ZNo > 0),
  FNo integer  not null check(FNo > 0),
  Tarih   date not null,
  Saattime not null,
  Zaman   datetime not null,
  Barkod  Char(10) COLLATE NOCASE NOT NULL,
  KdvOran Floatnot null check(KdvOran >= 0),
  Miktar  Floatnot null,
  Birim   Char(10) COLLATE NOCASE,
  OrjinalBirimFiyat   Floatnot null check(OrjinalBirimFiyat >= 0),  
  KartBirimFiyat  Floatnot null check(KartBirimFiyat >= 0),
  TeraziBirimFiyatFloatnot null check(TeraziBirimFiyat >= 0),
  IndirimliBirimFiyat Floatnot null check(IndirimliBirimFiyat >= 0),
  PromosyonFiyat  Floatnot null check(PromosyonFiyat >= 0),
  BirimFiyat  Floatnot null check(BirimFiyat >= 0),
  KDVTutarFloatnot null,
  Tutar   Floatnot null,
  Kasiyer Char(20) not null COLLATE NOCASE,
  OturumIDSmallInt not null,
  Vardiya SmallInt check(Vardiya > 0),
  VeresiyeKoduChar(20) COLLATE NOCASE,
  POSSeriNo   Char(50) not null COLLATE NOCASE,
  POSFisYazmaSuresi   integer  not null check(POSFisYazmaSuresi >= 0)
);

CREATE TABLE IF NOT EXISTS FISODEME(
  IDInteger NOT NULL PRIMARY KEY AUTOINCREMENT,
  EKU   integer not null check (EKU > 0),
  ZNo   integer not null check(ZNo > 0),
  FNo   integer not null check(FNo > 0),
  Tarih date not null,
  Saat  time not null,
  Zaman datetime not null,
  OdemeTuru Smallint not null check(OdemeTuru in (1, 2, 3)),
  KDVTutari Float not null check(KDVTutari >= 0),
  FisToplamifloat not null check(FisToplami >= 0),
  OdemeMiktari  float not null check(OdemeMiktari >= 0),
  ParaUstu  float not null check(ParaUstu >= 0),
  Banka Char(20) COLLATE NOCASE,
  VeresiyeKodu  Char(20) COLLATE NOCASE,
  POSSeriNo Char(50) not null COLLATE NOCASE
);

It is not easy for me to explain the report by written words. So, I prepared
an excel file with 3 sheets. First two contains raw data from above tables.
Last one is the report itself. Please ignore yellow marked columns in raw
data sheets.

I am quite open to add new table(s) for reporting purposes if that makes the
report possible/easier.

It doesn't need to be a single SQL. Running several SQL statements is not a
problem at all. However, I do not want to deal with 10s of SQL statements if
it can be done for example with only 3. It will be something as 10s of
statements If I am to deal with it using my own knowledge.

I appreciate any help.

Regards,
Ertan Küçükoğlu

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Failed to install Microsoft Visual C++ Runtime

[Zehev Spitz]

I am trying to install the design-time components of SQLite for Visual Studio 
2015. Based on the SQLite downloads page 
(https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) I am 
supposed to choose the setup package named 
"sqlite-netFx46-setup-bundle-x86-2015-1.0.102.0.exe" for this purpose. However, 
I am getting the following error:

> Failed to install Microsoft Visual C++ Runteim: vcredist_x86_2015_VSU2.exe, 
> Another version of this product is already installed. Installation of this 
> version cannot conitnue. To configure or remove the existing version of this 
> product, use Add/Remove Programs on the Control Panel.

I tried removing the redistributable for both 32- and 64-bit, then rerunning VS 
2015 Update 3 with cumulative fixes 
(https://msdn.microsoft.com/en-us/library/mt752379.aspx), and then rerunning 
the setup, with the same error.  
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] www.sqlite.org server maintenance

[Richard Hipp]

This message is to verify that the mailing list is still working.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Mailing list outage

[Richard Hipp]

The mailing list has not been working for about the past 24 hours.  A
memory upgrade at Linode went wrong, requiring us to rebuild the
server, and it has taken a few iterations to get mailman running.  If
you see this message, that is a good sign that the mailing lists are
working again.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Mailing list outage

[Richard Hipp]

I've been working to restart the mailing lists after a failed memory
upgrade at Linode required us to rebuild the server.  If you can see
this message, that means the mailing list is operating again.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Mailing list outage

[Richard Hipp]

A routine memory upgrade on the server failed yesterday, requiring us
to rebuild the system.  I've been struggling to get the mailing list
to run ever since.  If you can see this message, that means I have
finally met with some success.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Failed to install Microsoft Visual C++ Runtime

[Joe Mistachkin]

Zehev Spitz wrote:
> 
> > Failed to install Microsoft Visual C++ Runteim:
vcredist_x86_2015_VSU2.exe,
> Another version of this product is already installed. Installation of this
> version cannot conitnue. To configure or remove the existing version of
this
> product, use Add/Remove Programs on the Control Panel.
> 

Do you have the setup logs handy for this error?  They could help us to
resolve
the issue in the future setup packages.  The setup itself already has a
check
for the error codes that are documented to be used for this particular
situation;
however, there must (?) be (at least) one that is new (to Visual Studio
2015).

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mailing list outage

[R Smith]

Just to confirm, in case needed, it seems to be working now.


On 2016/07/31 1:02 PM, Richard Hipp wrote:

A routine memory upgrade on the server failed yesterday, requiring us
to rebuild the system.  I've been struggling to get the mailing list
to run ever since.  If you can see this message, that means I have
finally met with some success.



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mailing list outage

[Terra 2]

received


El 31/07/16 a les 18:54, R Smith ha escrit:

Just to confirm, in case needed, it seems to be working now.


On 2016/07/31 1:02 PM, Richard Hipp wrote:

A routine memory upgrade on the server failed yesterday, requiring us
to rebuild the system.  I've been struggling to get the mailing list
to run ever since.  If you can see this message, that means I have
finally met with some success.



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


--



Pere

torre_coll...@terra.es 







AVIS LEGAL

Nota de confidencialitat: Aquest missatge podria contenir missatges 
d'empresa i altre informació confidencial tutelada per les lleis de 
Europea i altres estats, Si Vostè el rep per error o sense ser una de 
les persones esmenades a la capçalera, haurà de destruir-lo sense 
copiar-lo ni revelar-l'ho o qualsevol altre acció relacionada amb el 
contingut del missatge i notificar-ho per correu electrònic a l'emissor 
del missatge.


Les persones o entitats que incompleixin els deures de confidencialitat 
podran ésser perseguides davant dels Tribunals de Justícia sota l'empar 
de la legislació civil, penal i administrativa nacional i internacional.


Gracies per la seva cooperació.



LEGAL NOTICE

Confidentiality notice: This mail may include business and other 
confidential information protected under the laws of and other 
territories. if you are not one of the intended recipients of the 
message, you are legally obliged to delete the message content. 
Furthermore, you are kindly requested to report immediately the incident 
to the sender.


Breach of confidentiality duties is a serious criminal offence in and 
other territories. Offenders shall be legally prosecuted worldwide.


Thank you for your cooperation.



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users