SQL Database Integration and SPI Communication Interface in Xojo

Getting Started
1

I am contacting you for assistance with two technical issues I encountered while working with Xojo on a Raspberry Pi.

  1. I am facing difficulties integrating an SQL database with Xojo. An error appears during this process, and I have attached an image for your reference. Could you kindly provide guidance on troubleshooting this issue or any recommended practices to ensure a seamless database integration?

  2. I have an existing SPI communication file in Python. I would like to understand the process of importing this file into Xojo or interfacing it with an SPI communication interface on the Raspberry Pi. Any insights, sample code, or documentation regarding this setup would be immensely helpful.

Thank you for your assistance, and I look forward to your guidance on these issues.

image
image1546×977 71 KB

2

The image:
what is the problem ? You set a breakpoint, run the project and it stop at the break point.
Run again ?
Click in the Run button.
Click in the break visial feedback rect to remove it.

There is a channel for RPi.

3

you can comminicate from Python to Xojo via TCP Network
or if you start the Python Script from Xojo Shell Class you can read the output.

i see you use only CommitTransaction
it is usually Begin and Commit or Rollback at Error

instead of a break point by mouse click you can also use the break command in source code.

before you open a file better test if it exists.
https://documentation.xojo.com/api/files/folderitem.html#folderitem-exists

4

For SPI, though never used myself:

https://einhugur.com/Html/opensource.html

1 Like