I have a database containing a table called client that has, among others, column names like id, first, last,…

It is projected to extract each record and from it, assemble a PDF file named after that client using his/her id, first, and last name

I have this visual FoxPro script that should do that but it is not working. I am getting Object Client is not found error.

sqlCn is a connection handle to a SQL Server DB.

RC=SQLEXEC(sqlCn ,"Select * from Client","client")
SELECT client
SCAN
F_PDF = PADL(ALLTRIM(client.Id.Value), 8, "0") + "_" + ALLTRIM(client.FIRST.Value) + "_" + ALLTRIM(client.LAST.Value)
F_PDF = STRTRAN(F_PDF, "/", "_")
F_PDF = STRTRAN(F_PDF, "", "_")
F_PDF = STRTRAN(F_PDF, ".", "") + ".pdf"
ENDSCAN