Dragan, something quite interesting I have seen lately... chatGPT in action
https://chat.openai.com/
It will remember a conversation and expand upon previous information. Here a couple of questions to turn a fox sample into python: (or other languages as needed)

can you write some sample code in vfp to iterate through a temp table and display the resulting list in a modal form?
Sure, here's some sample Visual FoxPro code that iterates through a temp table and displays the resulting list in a modal form:

sql
Copy code
LOCAL lcTempTable, lnRecno, lcField1, lcField2, lcField3
lcTempTable = "TempTable" && Replace with the name of your temp table
IF USED(lcTempTable)
USE IN (lcTempTable)
ENDIF
SELECT 0
USE (lcTempTable) ALIAS lcTempTable

* Open the modal form
DO FORM MyForm WITH "Title", .T.

* Loop through the records in the temp table and add them to the list
lnRecno = 1
SCAN
lcField1 = lcTempTable.Field1
lcField2 = lcTempTable.Field2
lcField3 = lcTempTable.Field3
MyForm.lstResults.AddItem(lnRecno + " " + lcField1 + " " + lcField2 + " " + lcField3)
lnRecno = lnRecno + 1
ENDSCAN

* Close the temp table and release resources
USE IN (lcTempTable)
In this example, MyForm is the name of the form that contains a listbox control named lstResults where the results will be displayed. You can modify the code to suit your specific needs.




Stacy Violett
now can you show that code using python instead please?
Sure, here's an example of how to iterate through a temp table and display the results in a modal form using Python and the PyQt5 GUI framework:

python
Copy code
from PyQt5.QtWidgets import QApplication, QDialog, QVBoxLayout, QListWidget, QListWidgetItem
import pyodbc # Import the PyODBC library for database access

# Connect to the database and open the temp table
conn = pyodbc.connect("Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;")
cursor = conn.cursor()
cursor.execute("SELECT * FROM TempTable")

# Create the modal dialog and list widget
app = QApplication([])
dialog = QDialog()
layout = QVBoxLayout()
list_widget = QListWidget()

# Loop through the records and add them to the list widget
recno = 1
for row in cursor.fetchall():
field1 = row.Field1
field2 = row.Field2
field3 = row.Field3
item = QListWidgetItem(f"{recno} {field1} {field2} {field3}")
list_widget.addItem(item)
recno += 1

# Add the list widget to the dialog layout and display the dialog
layout.addWidget(list_widget)
dialog.setLayout(layout)
dialog.setWindowTitle("Results")
dialog.setModal(True)
dialog.exec_()

# Close the cursor and database connection
cursor.close()
conn.close()
Note that you'll need to replace myServerAddress and myDataBase with the address of your SQL Server instance and the name of your database, respectively. You may also need to modify the SELECT statement to retrieve the correct columns from your temp table.






>>Hi Rich,
>>
>>>Thank you so much for your detailed writeup on Python
>>
>>You're most welcome. This good old forum has been a helpful place for so many years. A pleasure to be useful here!
>
>BTW, my old padawan, Voja Cvejić, after wasting years learning .net (plus Angular, Ado.net and a few other tools out there) just in case it may land him next job, finally confesses he was wasting time, and wants to learn Python. He's lined up some „learn python in nn days“ thingies, but I guess these would mostly waste his time on learning stuff he already knows. Is there a crash course for an old fox?
>
>(unless, of course, someone here needs an old fox who knows a bunch of .net things and could do some work as a telecommuting assistant... but in that case this is the wrong neck of the forum)