- Posts: 118
- Thank you received: 8
- 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
Question SQLite SigSegV after excuting Pragma statement in Zeos query
- universe
-
Topic Author
- Offline
- Junior Member
-
Less
More
3 years 4 months ago #13109
by universe
SQLite SigSegV after excuting Pragma statement in Zeos query was created by universe
Hello all,
Could anyone please confirm that this SQLite statementgenerates a SigSegV in Zeos Query the error is located in the function TZGenericStatementAnalyser.SplitSections (ZGenericSqlAnalyser.pas) it seems thatis returning with null WordCount.
I'm using CT6.7 32bit on Windows 7 64bit.
PS: This code works with old CT6.0.
Thanks
Could anyone please confirm that this SQLite statement
PRAGMA table_info('my_tablename')
CheckForKeyword(Tokens, TokenIndex, SectionNames, Keyword{%H-}, WordCount{%H-});
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.
- universe
-
Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 118
- Thank you received: 8
3 years 4 months ago #13134
by universe
Replied by universe on topic SQLite SigSegV after excuting Pragma statement in Zeos query
No body tried this?
Please Log in or Create an account to join the conversation.
- Matis A.
-
- Offline
- Moderator
-
3 years 4 months ago #13135
by Matis A.
PilotLogic Core Programmer
Replied by Matis A. on topic SQLite SigSegV after excuting Pragma statement in Zeos query
A project sample with the problem ?
for our help
for our help
PilotLogic Core Programmer
Please Log in or Create an account to join the conversation.
- universe
-
Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 118
- Thank you received: 8
3 years 4 months ago #13138
by universe
Replied by universe on topic SQLite SigSegV after excuting Pragma statement in Zeos query
Please find attached a sample project.
Thanks.
Thanks.
Attachments:
Please Log in or Create an account to join the conversation.
- Matis A.
-
- Offline
- Moderator
-
3 years 4 months ago #13139
by Matis A.
PilotLogic Core Programmer
Replied by Matis A. on topic SQLite SigSegV after excuting Pragma statement in Zeos query
Yes this Error exists
but I can't help with PRAGMA SQL command.
but I can't help with PRAGMA SQL command.
PilotLogic Core Programmer
Please Log in or Create an account to join the conversation.
- universe
-
Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 118
- Thank you received: 8
3 years 4 months ago #13153
by universe
Replied by universe on topic SQLite SigSegV after excuting Pragma statement in Zeos query
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.
- Sternas Stefanos
-
- Offline
- Moderator
-
- Ex Pilot, M.Sc, Ph.D
3 years 4 months ago #13154
by Sternas Stefanos
PilotLogic Architect and Core Programmer
Replied by Sternas Stefanos on topic SQLite SigSegV after excuting Pragma statement in Zeos query
I am NOT so familiar with
SQLite3 library SQL syntax and abilities
SQLite3 library SQL syntax and abilities
PilotLogic Architect and Core Programmer
Please Log in or Create an account to join the conversation.