--- In firebird-support@yahoogroups.com, "jwcane2003" <jwcane@...> wrote:

>
> The following insert command is an example of what I would like to use to enter dummy data into my database for testing:
>
> INSERT INTO residents (First, Last, Bldg, Unit, cbRelease, Email, lbOwnRent)
> VALUES("Theo","Jones","6105","2101","Yes","jones@","Own")^
>
> Any ideas appreciated.
>

You have to use a ' (single quote) instead of " (double quote) for string literals. So:
INSERT INTO residents (First, Last, Bldg, Unit, cbRelease, Email, lbOwnRent)
VALUES('Theo','Jones','6105','2101','Yes','jones@','Own')