Subject RE: [IBO] New User on IBO/Problem with Join
Author IBO Support List
Post date 2013-11-04T16:19:30Z
Have you set the KeyRelation property of the query to the table alias that you want a record inserted into?
 
Jason

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Tallys Ferrante
Sent: Monday, November 4, 2013 5:44 AM
To: ibobjects@yahoogroups.com
Subject: [IBO] New User on IBO/Problem with Join


Hello Guys!

I'm new on IBO, coming from DBExpress... On my new work we only use IBO. And i'm getting a problem with Join on IBOQuery.( All my coworkers don't know how to resolve).

When i use a IBOQuery with simple SQL Statement (Select Fields from Table) on SQL and fill the EditSQL with the proper Update Statement my Inserts works fine, but when i make a SQL with Join i get a error message:

' Problem on insert a new row '

How i proceed to get my inserts working with JOIN?

Thanks in advanced!