Re: [dabo-users] Grid from SQLite Views

On Friday, March 02, 2012 12:35:51 PM Ed Leafe wrote:

> On Mar 2, 2012, at 12:10 PM, Dewald Jacobs wrote:

> > It is capitalized. Is that a problem? I have been working with this

> > database for a while and my tables all work in dabo with capitalized

> > columns. The two tables that I use for the View is already used in the

> > app. The only column that is created in the View is Julian, but I get

> > errors on all the columns. Should I try all column names in the lower

> > case?

> It might be worth it to try. As a rule, I always name my tables, columns,

> indices, etc., in lower case to avoid case-sensitivity issues, so I'm sure

> that if there are some places in the code where case comes into play, it

> probably isn't very well tested.

> -- Ed Leafe

Here's a SWAG - could SQLite see 'Julian' as a data type as in julian date?

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com