Data Connections

Re: C orrect Syntax for SQL

dlgross — Sun, 11 Jun 2006 19:03:30 GMT

What I mean is that when a SQL statement is written in other tools, such as Access or SQL Server, double quotes are not put around each part of the statement i.e., I'm used to seeing dbo.jobmaster without any quotes at all.

Re: C orrect Syntax for SQL

Matt Faus — Sun, 11 Jun 2006 03:40:30 GMT

What do you mean that double quotes are not proper syntax? IP uses Jet SQL to interact with the SQL server. Can you paste the query you're trying to get working?

Re: C orrect Syntax for SQL

Patrick Halstead — Sat, 10 Jun 2006 08:31:15 GMT

Hi Dean,
Sorry but I have no idea.

C orrect Syntax for SQL

dlgross — Mon, 05 Jun 2006 20:17:14 GMT

I notice that when I create a connection to a database table, the Edit SQL box shows each field in quotes as well as each part of the table name, i.e., "dbo"."JobMaster". Since this is not the standard method of using quotes, I am puzzled as to what the syntax critera are for InfoPath. I am specifically interested in what modifications I must make to a SQL statement that I create in another tool (like SQL Server Query Analyzer). I am having problems getting sql statements created in QA to work in Infopath and am wondering what the problem may be. Can any one explain this to me?