How to add this to a SQL statement

HCL Domino Domino Forum
1

The field is identified as geoc.L. Normally, the field name is only letters and numbers but not separated by a period.

Here is an example of a snippet of the sql statement I have that works:

qry.Sql="Select

baan.ttccom020500.t$suno, baan.ttccom020500.t$l099

From baan.ttccom020500

Where (baan.ttccom020500.t$suno = ‘003323’)"

Here is an example of the

sql statement that I cannot get to work:

qry.SQL="Select

baan.ttccom020500.t$suno, baan.ttccom020500.t$geo.L

From baan.ttccom020500 Where (baan.ttccom020500.t$suno = ‘001097’)"

Does anyone have any ideas how to get this to work?

Thanks in advance for your comments.

Jean