InfoPath Dev

i have no idea about "where" statement in EDIT SQL(data connection).

field1 is infopath text field.

select A, B, C from dbo.sqltable as sqltable
where A="field1"

this sql is error.

please let this sql correct.

Hi

Using ‘where#%92 statement to edit SQL the syntax is:
SELECT column FROM table WHERE column operator value

Suppose Column1, column2, Column3 are columns in a table 'Person'

SELECT Column1, column2, Column3 FROM Person WHERE column1='123'

For more detail idea about SQL query view this link
http://www.w3schools.com/sql/sql_where.asp

thanks.
but where column='123'
'123' is not field name.

Hi Tetsu and a warm "irrasshaimase!" to you joining us from my favorite country - Japan!

Unfortunately, InfoPath doesn't support filtering on values in the form. We have a Web service that supports doing this (our "Database Accelerator") without code. The only other option is to write some code that connects to SQL directly (or write your own Web service).

We plan to update the Database Accelerator shortly and we can send you an evaluation version for free. Send me e-mail if you are interested.

Where are you located in Japan?

Hi, Patrick.
where did you learn japanese? i live in osaka. have you ever been in osaka?
i was surprised to hear japanese here. lol.

i am interested in "database Accelerator".