my $sth=$dbh->prepare("SELECT Last FROM Names");
I would appreciate if someone could point me at what I am doing wrong and what I need to do to correct it.
Thank you in advance for your assistance
I am pretty sure that both Last and Names are reserved words. Therefore, you need to quote and escape them.
("SELECT \"Last\" FROM \"Names\"")
Give that a try and see what happens.
Dangi it I had not thought about reserved words. That was EXACTLY the problem. Thank you so much for your help!
Very interesting, and unexpected
You could get the prize, for most obscure answer
> I am pretty sure that both Last and Names are reserved words. Therefore, you need to quote and escape them
I was guessing a bit because it was late when I replied, but later looked in the ODBC/JDBC Guide PDF that FileMaker supplies and sure enough, both of these are in the section (page 55) where they list out the SQL reserved words. There are a lot of them!