Hi All,

I found this special situation when I using these commands :

* Open testdata.dbc(invoice) or tastrade.dbc
PUBLIC x,y,o,r
x = CREATEOBJECT("DataLinks")
y= CREATEOBJECT("AdoDB.Connection")
y=x.PromptNew
y.Open
o = CREATEOBJECT("ADOX.Catalog")
o.ActiveConnection=y
r = CREATEOBJECT("ADODB.recordset")
r.ActiveConnection=y

s = o.Views("invoice").Command && pre tesstdata.dbc
? s.CommandText

s.CommandText RETURN 259 chars ONLY ???????????

If I using database as ACCESS, then I can working with Views.

I making some mistake or problem is in VFPOLEDB/ADO ???

jaro

You send me answers, please on email: thskk@thskk.sk

I have : VFP 7 SP1, WIN2000 PRO.