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 previous message
Alboni is currently offline  Alboni
Messages: 199
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

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


Current Time: Wed Nov 25 23:32:26 CET 2020

Total time taken to generate the page: 0.02063 seconds