Data Connections

Re: about "EDIT SQL"

iron — Tue, 05 Sep 2006 09:19:39 GMT

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".

Re: about "EDIT SQL"

Patrick Halstead — Mon, 04 Sep 2006 20:47:25 GMT

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?

Re: about "EDIT SQL"

iron — Mon, 04 Sep 2006 11:15:48 GMT

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

Re: about "EDIT SQL"

madhuri — Mon, 04 Sep 2006 09:20:26 GMT

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

about "EDIT SQL"

iron — Sun, 03 Sep 2006 14:45:16 GMT

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.