Topic: Is Record ID a String in a table
Hello,
The following works to change a table field without opening the record in a window.
SQLExecute('UPDATE Staff SET Location = "Away" where id =' +inttostr(form1.tablegrid1.dbItemID));
The above shows that the record ID in a table is a string, not an integer.
Selecting an individual record for printout in a report looks like the statement below.
WHERE employees.id = $id;
Why is a single record id written in different ways whether it is in a table or a report?
Is there some sort of rule to apply to know when to use the different ways of doing this?
Dumb question in know but I have to ask.
Thanks,
David