spelling

[hermie]

Hello

I have a simple query when I run the query I cannot do the spelling check
The spelling control is greyed.
Here is the SQL of the query:
SELECT [HG-001 PARTICIPANTE].NOMBRE_PART, [HG-001
PARTICIPANTE].APELLIDO_PATERNO, [HG-001 PARTICIPANTE].APELLIDO_MATERNO,
[HG-001 PARTICIPANTE].[MUNICIPIO-REFERIDO], [HG-002 EXPERIENCIA
TRABAJO].SEG_SOC_PART, [HG-002 EXPERIENCIA TRABAJO].RECOM_REALIZAR, [HG-002
EXPERIENCIA TRABAJO].DATE_GESTION, [HG-001 PARTICIPANTE].[ADDRES-CITY],
Programa.Prog_plura
FROM ([HG-001 PARTICIPANTE] INNER JOIN Programa ON [HG-001
PARTICIPANTE].PROGRAMA = Programa.Cod_Prog) INNER JOIN [HG-002 EXPERIENCIA
TRABAJO] ON [HG-001 PARTICIPANTE].SEG_SOC_PART = [HG-002 EXPERIENCIA
TRABAJO].SEG_SOC_PART;

Why can I not do a spelling check on this query?

Herman

 

[Rick Brandt]

Hello

I have a simple query when I run the query I cannot do the spelling
check The spelling control is greyed.
Here is the SQL of the query:
SELECT [HG-001 PARTICIPANTE].NOMBRE_PART, [HG-001
PARTICIPANTE].APELLIDO_PATERNO, [HG-001
PARTICIPANTE].APELLIDO_MATERNO, [HG-001
PARTICIPANTE].[MUNICIPIO-REFERIDO], [HG-002 EXPERIENCIA
TRABAJO].SEG_SOC_PART, [HG-002 EXPERIENCIA TRABAJO].RECOM_REALIZAR,
[HG-002 EXPERIENCIA TRABAJO].DATE_GESTION, [HG-001
PARTICIPANTE].[ADDRES-CITY], Programa.Prog_plura
FROM ([HG-001 PARTICIPANTE] INNER JOIN Programa ON [HG-001
PARTICIPANTE].PROGRAMA = Programa.Cod_Prog) INNER JOIN [HG-002
EXPERIENCIA TRABAJO] ON [HG-001 PARTICIPANTE].SEG_SOC_PART = [HG-002
EXPERIENCIA TRABAJO].SEG_SOC_PART;

Why can I not do a spelling check on this query?

Herman

AFAIK Spell Check has never been available in the query designer and I see
no logical reason why it should be. Table and field names are seldom going
to be properly spelled english words.

 

[hermie]

Hi Rick

Maybe I was not clear enough, but when I run the query I want to do a
spelling check on certain fields, and this is not possible?
I suppose it should be possible?

Herman

Hello

I have a simple query when I run the query I cannot do the spelling
check The spelling control is greyed.
Here is the SQL of the query:
SELECT [HG-001 PARTICIPANTE].NOMBRE_PART, [HG-001
PARTICIPANTE].APELLIDO_PATERNO, [HG-001
PARTICIPANTE].APELLIDO_MATERNO, [HG-001
PARTICIPANTE].[MUNICIPIO-REFERIDO], [HG-002 EXPERIENCIA
TRABAJO].SEG_SOC_PART, [HG-002 EXPERIENCIA TRABAJO].RECOM_REALIZAR,
[HG-002 EXPERIENCIA TRABAJO].DATE_GESTION, [HG-001
PARTICIPANTE].[ADDRES-CITY], Programa.Prog_plura
FROM ([HG-001 PARTICIPANTE] INNER JOIN Programa ON [HG-001
PARTICIPANTE].PROGRAMA = Programa.Cod_Prog) INNER JOIN [HG-002
EXPERIENCIA TRABAJO] ON [HG-001 PARTICIPANTE].SEG_SOC_PART = [HG-002
EXPERIENCIA TRABAJO].SEG_SOC_PART;

Why can I not do a spelling check on this query?

Herman

AFAIK Spell Check has never been available in the query designer and I see
no logical reason why it should be. Table and field names are seldom going
to be properly spelled english words.

 

[hermie]

Hi Rick

I found something but not understand it.
When I remove the join "programa" from the query I can do a spelling check.
Now the question is what causes the join Programa to not activate the
spelling check (F7)??

Herman

Hello

I have a simple query when I run the query I cannot do the spelling
check The spelling control is greyed.
Here is the SQL of the query:
SELECT [HG-001 PARTICIPANTE].NOMBRE_PART, [HG-001
PARTICIPANTE].APELLIDO_PATERNO, [HG-001
PARTICIPANTE].APELLIDO_MATERNO, [HG-001
PARTICIPANTE].[MUNICIPIO-REFERIDO], [HG-002 EXPERIENCIA
TRABAJO].SEG_SOC_PART, [HG-002 EXPERIENCIA TRABAJO].RECOM_REALIZAR,
[HG-002 EXPERIENCIA TRABAJO].DATE_GESTION, [HG-001
PARTICIPANTE].[ADDRES-CITY], Programa.Prog_plura
FROM ([HG-001 PARTICIPANTE] INNER JOIN Programa ON [HG-001
PARTICIPANTE].PROGRAMA = Programa.Cod_Prog) INNER JOIN [HG-002
EXPERIENCIA TRABAJO] ON [HG-001 PARTICIPANTE].SEG_SOC_PART = [HG-002
EXPERIENCIA TRABAJO].SEG_SOC_PART;

Why can I not do a spelling check on this query?

Herman

AFAIK Spell Check has never been available in the query designer and I see
no logical reason why it should be. Table and field names are seldom going
to be properly spelled english words.

 

[Tom Lake]

I found something but not understand it.

When I remove the join "programa" from the query I can do a spelling check.
Now the question is what causes the join Programa to not activate the
spelling check (F7)??

Perhaps the join renders the result not updatable in which case spell check
would have no effect on the output.

Tom Lake

 

[hermie]

Hi tom

But why? the join is simple e.g.
table partipante textfield progama is join to table Programa textfield
Cod_prog
Table programa has only 3 records
Cod_Prog Prog_plura
1 Jóvenes
2 Adultos
3 Trabajadores Desplazados

The query shows correctly the joined data.

Herman

 

[hermie]

Hi
I found the problem
Problem was that table Programa not had a PK So I changed Cod_Prog to be the
PK and now the spelling checks works

Thx all for the support

Herman