Focal Point
iSM Microsoft Access target problem

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/283106325

September 07, 2010, 06:38 PM
MacLonghorn
iSM Microsoft Access target problem
I have created an Access target in iWay Service Manager 6. I then create a statement which is a select on a table named "My_Table". When I do a Test Run, it gives me an error b/c it's converting the table name to My Table. The iwaf operation is:

select from My Table

I tried using [] and "" around the table name but no luck. How can I fix this?


Thanks.

Mark
WF 7.6 Windows
September 15, 2010, 02:49 PM
Kerry
Hi Mark,

Per our iWay technicals:

If I use the same statement:
SELECT FROM My_Table

Which is not specifying what to select, I get the following error message:

com ibi rdbms exceptions RDBMSException com microsoft sqlserver jdbc SQLServerException Incorrect syntax near the keyword FROM

The correct syntax is “SELECT * FROM My_Table”; don’t forget the star or a specific column name to retrieve...FYI I have created an “Adapter” target to my database server, created a prepared statement to select all rows on the table My_Table and used the “Test Run” option to test the prepared statement. The “SQL Code” of the prepared statement is:

SELECT * FROM My_Table

And it returns all the rows.


Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.