Need help with Return statement

[Columbo]

I tried your suggestion but I am getting an SQLite3 operational error. Here is the code I tried.

import sqlite3

# Connect to the database
conn = sqlite3.connect('dinobase.db')

c = conn.cursor()

def getRecord(srchName, recNo, name, meaning, pronounce, period, group, size, lived, diet, fossils, factfile):
# Execute the query
    c.execute('SELECT recNo, name, meaning, pronounce, period, group, size, lived, diet, fossils, factfile FROM dino WHERE name = ?', (srchName,))

    # Retrieving data
    for row in c:
        recNo = row[0]
        name = row[1]
        meaning = row[2]
        pronounce = row[3]
        period = row[4]
        group = row[5]
        size = row[6]
        lived = row[7]
        diet = row[8]
        fossils = row[9]
        factfile = row[10]
        return c.fetchall()

# Close the connection
conn.close

srchName = "Dimetrodon"
recNo = 0
name = ""
meaning = ""
pronounce = ""
period = ""
group = ""
size = ""
lived = ""
diet = ""
fossils = ""
factfile = ""

recNo, name, meaning, pronounce, period, group, size, lived, diet, fossils, factfile = getRecord(srchName, recNo, name, meaning, pronounce, period, group, size, lived, diet, fossils, factfile)    #Call the search function

function_return = recNo, name, meaning, pronounce, period, group, size, lived, diet, fossils, factfile
print(recNo)
print("name : " + name)
print("meaning : " + meaning)
print("pronounce : " + pronouce)
print("period : " + period)
print("group : " + group)
print("size : " + size)
print("lived : " + lived)
print("diet : " + diet)
print("fossils : " + fossils)
print("\n")
print("factfile : " + factfile)
print("\n")

Yoriz write Sep-16-2022, 05:28 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.