The following warnings occurred:
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 895 - File: showthread.php PHP 7.2.34 (Linux)
File Line Function
/showthread.php 895 errorHandler->error




Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sqlite.ToQmGrid - problems with escaped characters
#1
Hi Gintaras,
I am using a sqlite db to maintain a user list. Some of the names have apostrophe like "O'Connor" so I use
this before populating db table row:
Code:
Copy      Help
LastNameField.SqlEscape

To look at all table entries, I fill a QM grid with the table contents:

Code:
Copy      Help
DlgGrid g0.Init(hDlg 1005);;Enrollment Gridt_db.ToQmGrid(g0 "SELECT * FROM RadEnrollment" 1);err

The problem is that the table is filled with the Escaped version e.g. "O''Conor" instead of "O'Conor".
How do I de-escape using ToQmGrid?

Thanks,
Stuart


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)