Originally posted by: T.Amar

Hi,

I'm very new to WTX but basically i'm WMB developer. I've to implement on fatching values from DB based on input data.

For intance: Input is A/C number and output should be details of account of that person. Please provide me some steps how can i do that.

Thank you,

T. Amar.

Originally posted by: RichMcFate

It sounds like you want to execute a query that returns multiple columns.  

The first thing you need to do is create an .mdq file that points to the db and supplies the logon credentials.

You would reference that .mdq file in a map rule that uses the DBLOOKUP function to execute a dynamic query against the database.

Since DBLOOKUP always returns a single text item, you might have to pass that result to a RUN() map in order to parse and map the result.

My advice is to spend some time with the examples in <WTXInstall>/examples/adapters/<yourDBbrand>

Rich

Originally posted by: T.Amar

Hi Rich,

Thanks a lot with your valuble information.  

I'll start now. other than that Is there any  WTX Labs like in WMB samples. I'll be much happy if you provide some links on this.

Thank you once again,

T. Amar

Originally posted by: T.Amar

Hi Rich,

Is there any mistake in below code.

DBLOOKUP ("select first_name from employee where employee_id="+Name Fields:InputCard, "SAMPLEDB.mdq", "SAMPLEDB")

When i'm  hard coded the employee_id i'm getting the expected result but when i'm taking from input (Name Fields:InputCard). No Result.

Thank you,

T. Amar

Originally posted by: jvanboga

try this (assumes your mdq file is in the same path as your map and that 'sampledb' is the database name defined in your mdq file)....

DBLOOKUP ("select first_name from employee where employee_id="+Name Fields:InputCard  , " -mdq SAMPLEDB.mdq -dn SAMPLEDB -trace SAMPLEDB.dbl")

If that doesn't produce the results try...

DBLOOKUP ("select first_name from employee where employee_id='"+text(Name Fields:InputCard) + "'" , " -mdq SAMPLEDB.mdq -dn SAMPLEDB -trace SAMPLEDB.dbl")

Originally posted by: T.Amar

Hi Vanboga,

Thanks for your response and valueble information.

Your second Command is working in my case and  i found one more its below

DBLOOKUP ("select first_name from employee where employee_id='"+Name Fields:InputCard+"'","SAMPLEDB.mdq","SAMPLEDB")

Difference is shaded as previous my cmd.

Thanks for your help,

T. Amar

Originally posted by: T.Amar

Hi,

Present my requirement is to Fetch all records from DB where employeeId is coming from Input. I'm having doubt either i've to give query for individual field like above post or can i create query in database interface designer  if so please provide me some info how to give dynamic query in database interface designer.

Thanks you,

T. Amar