Hi

Sounds like a Delphi code bug to me. Do you know which method is
raising the error? Once you find it put some extra exception handling
in to display the SQL from the query this may show the issue. Are you
changing datasource, displays for the query. it could be that you have
attached a grid that has this column specified on the grid that isnt in
the query.

Are you using IBO or IB_ components. The IB_ components have a lot more
settings that need to be checked. Do an Alt F12 on the dfm and search
for the offending field, is it setup in anywhere in the query or related
components?

Just some suggestions.

Cheers
Rob






bwc3068 wrote:

> hi all--
>
> I'm not sure if this should be in this group or not, but, i'll take a shot.
>
> i'm using FB 2.1, IBO 4.8.7 and D6
>
> it's tough to put a finger on the "problem" because it's not a constant issue. on my computer when i run the application against the DB's i've received from my customers, I never see the problem.
>
> they do not see it everytime they execute the exact same sequence of steps in the application either, so, I think that removes the odds of it being a source code level bug.
>
> here's what it seems like it is: something to do with the speed / sequencing of my application, Firebird and the database.
>
> what is it: random errors returned and they are usually Access Violation errors OR "dynamic SQL error -206 unknown column".
>
> the column named in the error is never a column in the table (for example "K-000") AND my SQL to fetch the query is always "select * from atable". the source level query is persistent and has all the fields in it at the source code level (ie. they're created in source and in the query ie. persistent).
>
> the customers that see this error all have the same install setup:
>
> a server that has a single install of my application that also has the database & firebird on it. remote PCs on the LAN execute / share that single EXE on the server across the LAN on their PCs.
>
> they will be running fine, then do the exact same thing and it AV Errors or returns the "-206 unknown column" error. then? it works fine again for a while.
>
> it's almost like FB, the database and my application are not syncronized for the result query. i know how odd that sounds.
>
> can anyone shed any light on this or suggest a better way to run the application so there is only a single EXE being shared?
>
> TIA
> kelly
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>