Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » SqlLite3 crashes on Fetch()
SqlLite3 crashes on Fetch() [message #38351] Wed, 12 December 2012 02:51 Go to next message
Alboni is currently offline  Alboni
Messages: 191
Registered: January 2012
Location: Deventer, Netherlands
Experienced Member
Hello,

I can consistently crash the Sqlite3 interface with the program I hereby submit. It crashes in debug mode only. In Optimal mode the Select operation just fails.

When I look into the logfile there is a syntax error.

It seems some keywords are missing:

last bit:
Insert + Update + Select

insert into TEST(BD_KORTING) values (1)
update TEST set BD_AANTAL = 1, BD_BEDRAG = 345, BD_EXTRA_VAN = 2, BD_KORTING = 1, BD_BTW_BEDRAG = 345 where BD_ID = 2
BD_ID, BD_BEDRAG, BD_BTW_BEDRAG where BD_EXTRA_VAN = 2 and BD_KORTING = 1
ERROR near "BD_ID": syntax error(0): Preparing: BD_ID, BD_BEDRAG, BD_BTW_BEDRAG where BD_EXTRA_VAN = 2 and BD_KORTING = 1


System: Windows XP SP3, MSVC10

[Updated on: Wed, 12 December 2012 02:54]

Report message to a moderator

Re: SqlLite3 crashes on Fetch() [message #38553 is a reply to message #38351] Sun, 23 December 2012 10:22 Go to previous message
mirek is currently offline  mirek
Messages: 12191
Registered: November 2005
Ultimate Member
Missing From(TEST) here:

Quote:


sql*Select(BD_ID, BD_BEDRAG, BD_BTW_BEDRAG).From(TEST).Where(BD_EXTRA_VAN==id && BD_KORTING==1);


Previous Topic: Fields of the same name in diff tables
Next Topic: How to store a DATETIME in Sqlite?
Goto Forum:
  


Current Time: Thu Feb 20 15:53:49 CET 2020

Total time taken to generate the page: 0.00932 seconds