what about

set path to D:\foxprogs\galileo\data\ additive
ot = CREATEOBJECT("cursoradapter")
ot.DataSourceType="NATIVE"
ot.DataSource = "galidata.dbc"
ot.Alias = "Kunden"
ot.Tables = "Kunden"
ot.SelectCmd = "select TOP 1 * from galidata!kunden order by name1"
? ot.CursorFill()

VFP heavily relies on pathes

>Hi there,
>
>how can I iuse a cursoradapter wothout placing it in the DE? I tried
>
>

>ot = CREATEOBJECT("cursoradapter")
>ot.DataSourceType="NATIVE"
>ot.DataSource = "D:\foxprogs\galileo\data\galidata.dbc"
>ot.Alias = "Kunden"
>ot.Tables = "Kunden"
>ot.SelectCmd = "select TOP 1 * from kunden order by name1"
>? ot.CursorFill()
>

>
>If I try this in the commandline-window it asks for the table. I thought the CA would do this. What else do I have to do?
>
>Thanks in advance
>
>Thomas