Welcome, Guest

Forum

CodeTyphon Studio

CodeTyphon Studio Components and Libraries

Database Development

SQLite SigSegV after excuting Pragma statement in Zeos query

Components and Libraries for Database Development, discussions, problems and suggestions

Page:
1

TOPIC:

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13109

universe
Topic Author
Offline
Junior Member
Posts: 122
Thank you received: 8

Hello all,
Could anyone please confirm that this SQLite statement

PRAGMA table_info('my_tablename')

generates a SigSegV in Zeos Query the error is located in the function TZGenericStatementAnalyser.SplitSections (ZGenericSqlAnalyser.pas) it seems that

CheckForKeyword(Tokens, TokenIndex, SectionNames, Keyword{%H-}, WordCount{%H-});

is returning with null WordCount.
I'm using CT6.7 32bit on Windows 7 64bit.
PS: This code works with old CT6.0.
Thanks

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

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13134

universe Topic Author Offline Junior Member Posts: 122 Thank you received: 8	No body tried this?
	Please Log in or Create an account to join the conversation.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13135

Matis A. Away Moderator Posts: 1060 Thank you received: 149	A project sample with the problem ? for our help PilotLogic Core Programmer
	Please Log in or Create an account to join the conversation.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13138

universe Topic Author Offline Junior Member Posts: 122 Thank you received: 8	Please find attached a sample project. Thanks. File Attachment: File Name: Sample_Project.zip File Size:522 KB Attachments:
	Please Log in or Create an account to join the conversation.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13139

Matis A. Away Moderator Posts: 1060 Thank you received: 149	Yes this Error exists but I can't help with PRAGMA SQL command. PilotLogic Core Programmer
	Please Log in or Create an account to join the conversation.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13153

universe Topic Author Offline Junior Member Posts: 122 Thank you received: 8	I figured out the error exists for Postgresql if the query starts WITH RECURSIVE statement. Apparently only simple SELECT query are executed.
	Please Log in or Create an account to join the conversation.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13154

Sternas Stefanos Away Moderator Ex Pilot, M.Sc, Ph.D Posts: 4512 Thank you received: 1101	I am NOT so familiar with SQLite3 library SQL syntax and abilities PilotLogic Architect and Core Programmer
	Please Log in or Create an account to join the conversation.

Page:
1