Hy everybody,
I am in a very frustrating situation. I can't go on with designing the application, allthough it is in a very advanced point .
I have SQL database and Visual Foxpro 8 interface.
In foxpro I have a DBC with remote views to SQL tables.
When opening a view in designer works .
Only when trying to browse data, I get the message "COUNT field incorrect or syntax error". And can't browse it . When launching the application, in some screen appears and in others doesn't.
Even if I remove the date type parameter I get the error .
The view has 2 parameters : one of date type and the other of character type .
Any idea is welcome !

The code for view is:
*************************
SELECT Comenzi.*, Documente.numedoc, Persoane.numepers AS agent,;
Parteneri.numepart, Magazii.coddivizie, Magazii.magazie, Divizii.divizie;
FROM ;
dbo.comenzi Comenzi ;
INNER JOIN dbo.documente Documente ;
ON Comenzi.tipdoc = Documente.tipdoc ;
INNER JOIN dbo.persoane Persoane ;
ON Comenzi.idagent = Persoane.idpersoana ;
INNER JOIN dbo.parteneri Parteneri ;
ON Comenzi.idnume = Parteneri.idnume ;
INNER JOIN dbo.magazii Magazii ;
ON Comenzi.idmagazie = Magazii.idmagazie ;
INNER JOIN dbo.divizii Divizii ;
ON Magazii.coddivizie = Divizii.coddivizie;
WHERE Comenzi.data BETWEEN ?fdatai AND ?fdatas;
AND Comenzi.idnume LIKE ( ?fidnume )

DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.T.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.T.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","dbo.comenzi")
DBSetProp(ThisView,"View","WhereType",4)

DBSetProp(ThisView+".iddoc","Field","DataType","C(12)")
DBSetProp(ThisView+".iddoc","Field","DefaultValue","getid("+CHR(34)+"comenzi"+CHR(34)+",3,9,.T.)")
DBSetProp(ThisView+".iddoc","Field","UpdateName","dbo.comenzi.iddoc")
DBSetProp(ThisView+".iddoc","Field","KeyField",.T.)
DBSetProp(ThisView+".iddoc","Field","Updatable",.T.)

DBSetProp(ThisView+".tipdoc","Field","DataType","C(5)")
DBSetProp(ThisView+".tipdoc","Field","UpdateName","dbo.comenzi.tipdoc")
DBSetProp(ThisView+".tipdoc","Field","KeyField",.F.)
DBSetProp(ThisView+".tipdoc","Field","Updatable",.T.)

DBSetProp(ThisView+".data","Field","DataType","D")
DBSetProp(ThisView+".data","Field","DefaultValue","putdata()")
DBSetProp(ThisView+".data","Field","RuleExpression","getscadenta("+CHR(34)+"c"+CHR(34)+")")
DBSetProp(ThisView+".data","Field","RuleText",CHR(34)+"Data documentului ?"+CHR(34))
DBSetProp(ThisView+".data","Field","UpdateName","dbo.comenzi.data")
DBSetProp(ThisView+".data","Field","KeyField",.F.)
DBSetProp(ThisView+".data","Field","Updatable",.T.)

DBSetProp(ThisView+".dataoperare","Field","DataType","D")
DBSetProp(ThisView+".dataoperare","Field","UpdateName","dbo.comenzi.dataoperare")
DBSetProp(ThisView+".dataoperare","Field","KeyField",.F.)
DBSetProp(ThisView+".dataoperare","Field","Updatable",.T.)

DBSetProp(ThisView+".zileplata","Field","DataType","I")
DBSetProp(ThisView+".zileplata","Field","UpdateName","dbo.comenzi.zileplata")
DBSetProp(ThisView+".zileplata","Field","KeyField",.F.)
DBSetProp(ThisView+".zileplata","Field","Updatable",.T.)

DBSetProp(ThisView+".idnume","Field","DataType","C(7)")
DBSetProp(ThisView+".idnume","Field","RuleExpression","getdatecl("+CHR(34)+"com"+CHR(34)+")")
DBSetProp(ThisView+".idnume","Field","UpdateName","dbo.comenzi.idnume")
DBSetProp(ThisView+".idnume","Field","KeyField",.F.)
DBSetProp(ThisView+".idnume","Field","Updatable",.T.)

DBSetProp(ThisView+".idmagazie","Field","DataType","C(7)")
DBSetProp(ThisView+".idmagazie","Field","RuleExpression","getscadenta("+CHR(34)+"c"+CHR(34)+")")
DBSetProp(ThisView+".idmagazie","Field","UpdateName","dbo.comenzi.idmagazie")
DBSetProp(ThisView+".idmagazie","Field","KeyField",.F.)
DBSetProp(ThisView+".idmagazie","Field","Updatable",.T.)

DBSetProp(ThisView+".idagent","Field","DataType","C(7)")
DBSetProp(ThisView+".idagent","Field","UpdateName","dbo.comenzi.idagent")
DBSetProp(ThisView+".idagent","Field","KeyField",.F.)
DBSetProp(ThisView+".idagent","Field","Updatable",.T.)

DBSetProp(ThisView+".totaldoc","Field","DataType","B(2)")
DBSetProp(ThisView+".totaldoc","Field","DefaultValue","0")
DBSetProp(ThisView+".totaldoc","Field","UpdateName","dbo.comenzi.totaldoc")
DBSetProp(ThisView+".totaldoc","Field","KeyField",.F.)
DBSetProp(ThisView+".totaldoc","Field","Updatable",.F.)

DBSetProp(ThisView+".tvadoc","Field","DataType","B(2)")
DBSetProp(ThisView+".tvadoc","Field","DefaultValue","0")
DBSetProp(ThisView+".tvadoc","Field","UpdateName","dbo.comenzi.tvadoc")
DBSetProp(ThisView+".tvadoc","Field","KeyField",.F.)
DBSetProp(ThisView+".tvadoc","Field","Updatable",.F.)

DBSetProp(ThisView+".idiesiri","Field","DataType","C(12)")
DBSetProp(ThisView+".idiesiri","Field","UpdateName","dbo.comenzi.idiesiri")
DBSetProp(ThisView+".idiesiri","Field","KeyField",.F.)
DBSetProp(ThisView+".idiesiri","Field","Updatable",.T.)

DBSetProp(ThisView+".operata","Field","DataType","L")
DBSetProp(ThisView+".operata","Field","DefaultValue",".F.")
DBSetProp(ThisView+".operata","Field","UpdateName","dbo.comenzi.operata")
DBSetProp(ThisView+".operata","Field","KeyField",.F.)
DBSetProp(ThisView+".operata","Field","Updatable",.T.)

DBSetProp(ThisView+".sursa","Field","Comment","Aplicatie,Palm,Web")
DBSetProp(ThisView+".sursa","Field","DataType","I")
DBSetProp(ThisView+".sursa","Field","DefaultValue","1")
DBSetProp(ThisView+".sursa","Field","UpdateName","dbo.comenzi.sursa")
DBSetProp(ThisView+".sursa","Field","KeyField",.F.)
DBSetProp(ThisView+".sursa","Field","Updatable",.T.)

DBSetProp(ThisView+".integral","Field","DataType","L")
DBSetProp(ThisView+".integral","Field","DefaultValue",".F.")
DBSetProp(ThisView+".integral","Field","UpdateName","dbo.comenzi.integral")
DBSetProp(ThisView+".integral","Field","KeyField",.F.)
DBSetProp(ThisView+".integral","Field","Updatable",.T.)

DBSetProp(ThisView+".obs","Field","DataType","M")
DBSetProp(ThisView+".obs","Field","DefaultValue","space(0)")
DBSetProp(ThisView+".obs","Field","UpdateName","dbo.comenzi.obs")
DBSetProp(ThisView+".obs","Field","KeyField",.F.)
DBSetProp(ThisView+".obs","Field","Updatable",.T.)

DBSetProp(ThisView+".idcmdpalm","Field","DataType","C(9)")
DBSetProp(ThisView+".idcmdpalm","Field","DefaultValue","space(9)")
DBSetProp(ThisView+".idcmdpalm","Field","UpdateName","dbo.comenzi.idcmdpalm")
DBSetProp(ThisView+".idcmdpalm","Field","KeyField",.F.)
DBSetProp(ThisView+".idcmdpalm","Field","Updatable",.T.)

DBSetProp(ThisView+".tipvaluta","Field","DataType","C(3)")
DBSetProp(ThisView+".tipvaluta","Field","DefaultValue","'ROL'")
DBSetProp(ThisView+".tipvaluta","Field","UpdateName","dbo.comenzi.tipvaluta")
DBSetProp(ThisView+".tipvaluta","Field","KeyField",.F.)
DBSetProp(ThisView+".tipvaluta","Field","Updatable",.T.)

DBSetProp(ThisView+".curs","Field","DataType","B(2)")
DBSetProp(ThisView+".curs","Field","DefaultValue","1")
DBSetProp(ThisView+".curs","Field","UpdateName","dbo.comenzi.curs")
DBSetProp(ThisView+".curs","Field","KeyField",.F.)
DBSetProp(ThisView+".curs","Field","Updatable",.T.)

DBSetProp(ThisView+".codpromo","Field","DataType","C(5)")
DBSetProp(ThisView+".codpromo","Field","DefaultValue","space(5)")
DBSetProp(ThisView+".codpromo","Field","UpdateName","dbo.comenzi.codpromo")
DBSetProp(ThisView+".codpromo","Field","KeyField",.F.)
DBSetProp(ThisView+".codpromo","Field","Updatable",.T.)

DBSetProp(ThisView+".transmis","Field","DataType","L")
DBSetProp(ThisView+".transmis","Field","DefaultValue",".f.")
DBSetProp(ThisView+".transmis","Field","UpdateName","dbo.comenzi.transmis")
DBSetProp(ThisView+".transmis","Field","KeyField",.F.)
DBSetProp(ThisView+".transmis","Field","Updatable",.T.)

DBSetProp(ThisView+".stamp","Field","DataType","C(36)")
DBSetProp(ThisView+".stamp","Field","UpdateName","dbo.comenzi.stamp")
DBSetProp(ThisView+".stamp","Field","KeyField",.F.)
DBSetProp(ThisView+".stamp","Field","Updatable",.T.)

DBSetProp(ThisView+".ts","Field","DataType","M NOCPTRANS")
DBSetProp(ThisView+".ts","Field","UpdateName","dbo.comenzi.ts")
DBSetProp(ThisView+".ts","Field","KeyField",.F.)
DBSetProp(ThisView+".ts","Field","Updatable",.F.)

DBSetProp(ThisView+".numedoc","Field","DataType","C(25)")
DBSetProp(ThisView+".numedoc","Field","UpdateName","dbo.documente.numedoc")
DBSetProp(ThisView+".numedoc","Field","KeyField",.F.)
DBSetProp(ThisView+".numedoc","Field","Updatable",.F.)

DBSetProp(ThisView+".agent","Field","DataType","C(30)")
DBSetProp(ThisView+".agent","Field","UpdateName","dbo.persoane.numepers")
DBSetProp(ThisView+".agent","Field","KeyField",.F.)
DBSetProp(ThisView+".agent","Field","Updatable",.F.)

DBSetProp(ThisView+".numepart","Field","DataType","C(60)")
DBSetProp(ThisView+".numepart","Field","UpdateName","dbo.parteneri.numepart")
DBSetProp(ThisView+".numepart","Field","KeyField",.F.)
DBSetProp(ThisView+".numepart","Field","Updatable",.F.)

DBSetProp(ThisView+".coddivizie","Field","DataType","C(2)")
DBSetProp(ThisView+".coddivizie","Field","UpdateName","dbo.magazii.coddivizie")
DBSetProp(ThisView+".coddivizie","Field","KeyField",.F.)
DBSetProp(ThisView+".coddivizie","Field","Updatable",.F.)

DBSetProp(ThisView+".magazie","Field","DataType","C(30)")
DBSetProp(ThisView+".magazie","Field","UpdateName","dbo.magazii.magazie")
DBSetProp(ThisView+".magazie","Field","KeyField",.F.)
DBSetProp(ThisView+".magazie","Field","Updatable",.F.)

DBSetProp(ThisView+".divizie","Field","DataType","C(15)")
DBSetProp(ThisView+".divizie","Field","UpdateName","dbo.divizii.divizie")
DBSetProp(ThisView+".divizie","Field","KeyField",.F.)
DBSetProp(ThisView+".divizie","Field","Updatable",.F.)
*************************

Thanks A LOT !
Mihai .