Jason,

Sorry it's taken me some time to get back to this. I've been out of town all last week.

I do have a confession to make. I'm using a very old version of IBO (4.3Aa) with Firebird 2.5. I know they aren't officially compatible, but so far (two years) I haven't had any problems. Could this be the issue in this particular case?

Which brings up another question: Are there any versions of IBO that are compatible with both Firebird 2.5 and BCB4?

-Joe

--- In IBObjects@yahoogroups.com, "IBO Support List" wrote:
>
> Joe,
>
> I agree this sounds quite odd.
> Perhaps the best thing to do would be to help me reproduce the error.
> Would you be able to make a sample app or is there a time I could have a
> look directly via some kind of a remote desktop viewing?
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of Joe
> Sent: Friday, January 4, 2013 3:54 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Exception on post of IBOTable
>
> I have an application with several forms that have controls (mostly TDBEdit)
> bound to TIBOTable objects. I use a TDBNavigator to control
> insert/edit/post/etc.
>
> We recently had a report from a customer of an intermittent problem, where
> if they edit a record (click edit button on DBNavigator), (they may actually
> edit data or not), then post the record (click on checkmark in the
> DBNavigator), they will sometime get an exception that says, "Invalid INSERT
> statement: No columns".
>
> I AM able to reproduce this behavior, but I can't figure out what's going
> wrong. There is no code of my own involved in this. When I look at the
> call stack in BCB after getting the exception, it's all Borland and IBO
> methods.
>
> This problem only occurs for one form. The other forms (which access other
> tables) work fine. And again, it doesn't always happen. I'm kind of
> confused about the exception message. I'm not sure why it's talking about
> an insert statement, when it seems to me that it should be an update (edited
> record).
>
> Can anyone point me to what settings I might need to look at to try and fix
> this?
>
> -Joe
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>