Tim

In EDBManager developing a query I'm given the following

Hint: Create index (DayBook) on column "D"."_fkStaff" for possible better
performance

I did, there is, and its still suggesting it, even after closing and reopening EDBManager

Roy Lambert

Roy,

<< In EDBManager developing a query I'm given the following

Hint: Create index (DayBook) on column "D"."_fkStaff" for possible better
performance

I did, there is, and its still suggesting it, even after closing and
reopening EDBManager >>

Did you make sure that the collation matched properly ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Did you make sure that the collation matched properly ?

No and my apologies for not thinking of that option.

I was nobbled by EDBManager or to put it another way when I altered the details of the previous column (integer) to create the next one (varchar) I didn't realise that case insensitive hadn't been ticked.

If you ever reach a slow patch would it be possible to define default properties for the field types in EDBManager eg I will 99.87% of the time have varchars case insensitive.

Roy Lambert

Roy,

<< If you ever reach a slow patch would it be possible to define default
properties for the field types in EDBManager eg I will 99.87% of the time
have varchars case insensitive. >>

What you're looking for are SQL domains, and yes, I'll probably introduce
something similar in a user-defined type system.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< If you ever reach a slow patch would it be possible to define default
>properties for the field types in EDBManager eg I will 99.87% of the time
>have varchars case insensitive. >>
>
>What you're looking for are SQL domains, and yes, I'll probably introduce
>something similar in a user-defined type system.

Possibly (if I know what an SQL domain was) but what I was thinking about was defaults for your check/edit boxes.

Roy Lambert

Roy,

<< Possibly (if I know what an SQL domain was) but what I was thinking about
was defaults for your check/edit boxes. >>

 That will work also - noted.

--
Tim Young
Elevate Software
www.elevatesoft.com