In Xcode (Mac OS Catalina), when trying to create an application to access a database, I receive syntax errors, resulting from the installed version of SQlite (below 3.30) does not allowing generation of virtual columns.
After updating to 3.46 the version installed on system, this does not occur if I execute such queries directly in SQlite, via Terminal.
How do I get Xcode to access and use the system updated version ?
Thanks in advance
apffal
Users receive reputation points by contributing quality content to the forums.
Posts include post and replies published on the forums.
Post authors can mark replies as Accepted to indicate successful solutions.
Apple Developer Forums admins can mark replies as Apple Recommended to indicate an approved solution
Last seen
User for
Post
Replies
Boosts
Views
Activity
I'm trying to get results from a SQLite database, containing rows and columns, into a NSTableView, using Swift. There is no problem with the database query and I'm getting no errors when running the application.
However, when displaying data, I always get the same (last) row in the table - repeated so many times as the total number of rows.
What is missing in my code ?
Thanks in advance.
`class SecondViewController: NSViewController, NSTableViewDataSource, NSTableViewDelegate {
@IBOutlet var tableview: NSTableView!
var querySQL = ""
var bdadosDB: OpaquePointer?
var statement: OpaquePointer?
var allRows = [String]()
var rows = [String]()
var cols = [String]()
var CellIdentifiers :[String] = ["ordCell", "procCell", "espCell", "natCell", "recCell", "estCell", "julgCell", "decCell"]
override func viewDidLoad() {
let dirPaths = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true)
let docsDir = dirPaths[0]
let databasePath = (docsDir as NSString).appendingPathComponent("bdados.db")
let dbpath = databasePath
sqlite3_open(dbpath, &bdadosDB)
querySQL = "SELECT * FROM proc"
sqlite3_prepare_v2(bdadosDB, querySQL, -1, &statement, nil)
while (sqlite3_step(statement) == SQLITE_ROW)
{
let str = String(sqlite3_column_int(statement, 0)) + ";"
let str_1 = String(cString: sqlite3_column_text(statement, 1)) + ";"
let str_2 = String(cString: sqlite3_column_text(statement, 2)) + ";"
let str_3 = String(cString: sqlite3_column_text(statement, 3)) + ";"
let str_4 = String(cString: sqlite3_column_text(statement, 4)) + ";"
let str_5 = String(cString: sqlite3_column_text(statement, 5)) + ";"
let str_6 = String(cString: sqlite3_column_text(statement, 6)) + ";"
let str_7 = String(cString: sqlite3_column_text(statement, 7))
let result = str + str_1 + str_2 + str_3 + str_4 + str_5 + str_6 + str_7
allRows.append(result)
}
let str_arr = allRows.joined(separator: "_")
rows = str_arr.components(separatedBy: "_")
tableview.dataSource = self
tableview.delegate = self
super.viewDidLoad()
}
func numberOfRows(in tableview: NSTableView) -> Int {
return rows.count
}
func tableView(_ tableview: NSTableView, viewFor tableColumn: NSTableColumn?, row: Int) -> NSView? {
var text: String = ""
var cellIdentifier: String = ""
for i in 0 ..< rows.count {
let rw = rows[i]
cols = rw.components(separatedBy: ";")
for j in 0 ..< cols.count {
let col = cols[j]
if tableColumn == tableview.tableColumns[j] {
text = col
cellIdentifier = CellIdentifiers[j] }
}
}
if let cell = tableview.makeView(withIdentifier: NSUserInterfaceItemIdentifier(rawValue: cellIdentifier) , owner: nil) as? NSTableCellView {
cell.textField?.stringValue = text
return cell }
else {
return nil }
}
}
`
When inserting results from a database into a Python (last version) tkinter text widget, in macOS Catalina or Big Sur, I get unwanted spaces between paragraphs.
However this behaviour doesn´t occur in Windows.
How to solve the issue ? Thanks in advance
This is my relevant code
e10 = tkscrolled.ScrolledText (root, height=12, width=60, font=(‘times new roman’, 9), wrap=“word”)
canvas.create_window(255, 295, window=e10)
………
cursor.execute(“SELECT * FROM relator” )
result = cursor.fetchall()
e10.delete(1.0, tk.END)
e10.insert(1.0, result[result.index(n)][9])