Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

fcl-db problem 11 years 5 months ago #4017

  • Dinko
  • Dinko's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 91
  • Thank you received: 5
Hello

I want to report problems with fcl-db package which is included into CodeTyphon 4.3 distribution

It seems that it is unusable because if you want to put some select statement into TSQLQuery SQL property then you will get an error

SErrNoSelectStatement = 'Cannot open a non-select statement'

I'm using TSQLite3Connection, TSQLTransaction and TSQLQuery components.

Comparing to the previous release (CodeTyphon 4.2), which was OK, this release of fcl-db have many changes in source code, so it is maybe not stable enough.

Regards, Dinko

Please Log in or Create an account to join the conversation.

fcl-db problem 11 years 5 months ago #4018

  • Jan Roza
  • Jan Roza's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 173
  • Thank you received: 6
I have exactly the same problem and was doubting my sanity as I could not find the error.
Now I know I'm not loosing my mind as others have the same problem :)
I use the same combination: TSQLite3Connection, TSQLTransaction and TSQLQuery.

Hope there will be a patch for this soon (I'm sure there will be).
Operating Systems Windows 11 and Linux Mint (64-bit) and virtual Raspberry Pi Desktop
The following user(s) said Thank You: Dinko

Please Log in or Create an account to join the conversation.

fcl-db problem 11 years 5 months ago #4021

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4535
  • Thank you received: 1114
We will fix and this Guys
PilotLogic Architect and Core Programmer
The following user(s) said Thank You: Slamet Riyanto, Dinko

Please Log in or Create an account to join the conversation.

fcl-db problem 11 years 5 months ago #4092

  • zerg
  • zerg's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 2
  • Thank you received: 0
I use sqlite too, and the same problem, and it's OK in ct4.2

Please Log in or Create an account to join the conversation.

fcl-db problem 11 years 5 months ago #4093

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4535
  • Thank you received: 1114
Sir, (good morning)
read this post
PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

Last edit: by Sternas Stefanos.
  • Page:
  • 1