Re: New user questions

On Tue, 13 Jul 2021, Adrian Klaver wrote:

> Triple quoting is used when the statement extends across more then one
> line. Pair of double quotes is used for single line statement, especially
> when there are single quoted values in the statement.

Adrian,

That makes sense: the statements are treated as comments. I hadn't thought
of them that way.

>> 2) How do I write a cursor execute UPDATE statement where the columns and
>> values to be updated can be single or multiple and the values passed into
>> the method from the tkinter widgets? Are there examples from which I can
>> learn?
>
> There are several ways to read the above.
> Send some examples of what you want to do.

Here's a template:

update contacts
set 
where
;

The contacts table has these attributes:
person_nbr   | integer
act_date     | date
act_type     | character varying(12)
notes        | text
next_contact | date

Could be a changed next_contact date, or notes, or both.

Other tables need updating; for example, a new job title for a person or a
new web site for a company.

Thanks,

Rich