May 6, 200322 yr Newbies Hi all I'm in deep trouble.My client having FileMaker Pro 6.0 db which i wants to access from ASP using ODBC connectivity.But their filds have space between two words.for example "Reference Number".when i use this in SQL query it's taking the first word "Reference" and giving the error as Reference field not exist.I can't remove the space in between the filed coz they are using this db for other applications.So can anybody help me to resolve this problem.... regards sanith
May 6, 200322 yr you can define calc fields (reference_number = reference number) for every field that is likely to appear in the query.
May 6, 200322 yr In the SQL statement can you place single quotes around the field name; e.g.: 'Reference Number' Good Luck. Garry
May 8, 200322 yr Author Newbies We can't give single quotes in the SQL queries....Thanks for the suggestion.... regards sanith
Create an account or sign in to comment