Home > Back-end >  After RecordCountMode:=cmTotal sqlite PRAGMA error
After RecordCountMode:=cmTotal sqlite PRAGMA error

Time:11-12

Set up the data after
 conTemp. FetchOptions. RecordCountMode:=cmTotal; 

Use
 
DMForm. QryTemp. Close;
DMForm. QryTemp. SQL. The Clear;
DMForm. QryTemp. SQL. Text:='PRAGMA table_info (KnowLink)';
DMForm. QryTemp. Open;

Complains
[the Window Title]
Project1

[Content]
Exception class name: ESQLiteNativeException
Exception information: [FireDAC] [Phys] [SQLite] ERROR: near "(" : syntax ERROR

[OK]

If not set, not an error, the program running
  • Related