Bug and/or gotcha

[JD Kromkowski]

If you call a field “TIME”, for example in calendar/appointment database, the quickreport gets all funky. 1. Insert all will shut down. 2. If you insert field one by one, as soon a you choose the field with TIME as name, the columns will stop being added. If you delete the MyTABLE.TIME field the subsequently added columns will appear. Calling it something as in using AS doesn’t fix problem.

[JD Kromkowski]

On 01/14/13 4:48 PM, kromkowski wrote:
> If you call a field "TIME", for example in calendar/appointment
> database, the quickreport gets all funky.
>
> 1. Insert all will shut down.
>
> 2. If you insert field one by one, as soon a you choose the field with
> TIME as name, the columns will stop being added. If you delete the
> MyTABLE.TIME field the subsequently added columns will appear. Calling
> it something as in using AS doesn't fix problem.

calling field "time" as OPPOSED to "TIME" apparently does not create
problem.

[Michael]

On 14/01/2013 21:48, kromkowski wrote:
> If you call a field "TIME", for example in calendar/appointment
> database, the quickreport gets all funky.
>
> 1. Insert all will shut down.
>
> 2. If you insert field one by one, as soon a you choose the field with
> TIME as name, the columns will stop being added. If you delete the
> MyTABLE.TIME field the subsequently added columns will appear. Calling
> it something as in using AS doesn't fix problem.
>

You may have stumbled on a problem with TIME in all caps being a SQL reserved word, which doesn't affect SIMPOL on its own, but
may hit you. I have recently discovered that the SQL engine may support wrapping identifiers in double quotes ("). You can't
easily try that in the Quick Report, but we will be investigating that as a solution for things like this.

Ciao, Neil

[Author]

Posts