Conncetiviti error

I have this error only when reading a certain file from SQL
server, and not with all the other files, so it's very strange.
I have a Visual FoxPro cursoradapter who gets populated with a
record from a table in SQL server, and the CursorFill method of
the CursorAdapter (which populates it using the CursorAdapter
properties) raises this error:
Connectivity error: [ODBS SQL Server driver] [SQL Server] Line 1:
incorrect sintax near ")".
The message was in italian so I translated it.
I checked the CursorAdapter's SelList, the SelectCmd, the
KeyFieldList, the Cursorschema... none of them contains
parentheses except the selectcmd, as modified in the
BeforeCursorfill event. The selectcmd is the command that Visual
FoxPro will internally use to call SQL server and populate the
cursoradapter.
This select statement contains the list of fields, the FROM
clause and the following "WHERE" condition:
WHERE FLG_LOAD=0 and (substring(TAG1,1,16) >= ' '
and substring(TAG1,1,16)<=(SELECT
COALESCE(min(substring(TAG1,1,16)),'') FROM AR_ANAGR_ANA_IP WHERE
substring(TAG1,1,16) > ' ' and FLG_LOAD = .F.))
FLO_LOAD and TAG1 are both fields of that table.
Someone sees something strange, in that condition?
TIA
VilliHi
FLG_LOAD = .F.))
The ".F." is not a valid expression in SQL Server. Is it a variable, a value
or ?
Regards
Mike
"Villi Bernaroli" wrote:

> I have this error only when reading a certain file from SQL
> server, and not with all the other files, so it's very strange.
> I have a Visual FoxPro cursoradapter who gets populated with a
> record from a table in SQL server, and the CursorFill method of
> the CursorAdapter (which populates it using the CursorAdapter
> properties) raises this error:
> Connectivity error: [ODBS SQL Server driver] [SQL Server] Line 1:
> incorrect sintax near ")".
> The message was in italian so I translated it.
> I checked the CursorAdapter's SelList, the SelectCmd, the
> KeyFieldList, the Cursorschema... none of them contains
> parentheses except the selectcmd, as modified in the
> BeforeCursorfill event. The selectcmd is the command that Visual
> FoxPro will internally use to call SQL server and populate the
> cursoradapter.
> This select statement contains the list of fields, the FROM
> clause and the following "WHERE" condition:
> WHERE FLG_LOAD=0 and (substring(TAG1,1,16) >= ' '
> and substring(TAG1,1,16)<=(SELECT
> COALESCE(min(substring(TAG1,1,16)),'') FROM AR_ANAGR_ANA_IP WHERE
> substring(TAG1,1,16) > ' ' and FLG_LOAD = .F.))
> FLO_LOAD and TAG1 are both fields of that table.
> Someone sees something strange, in that condition?
> TIA
> Villi
>
>|||Mi e' parso che Mike Epprecht (SQL MVP) abbia scritto:

> Hi
> FLG_LOAD = .F.))
> The ".F." is not a valid expression in SQL Server. Is it
> a variable, a value or ?
Ooooooooooooooops!
Thanks, Mike :)
--
The answer to the ethernal question is:
put a read events after the launch of the form

Confused about reporting feature

I remember reading something about some sort of new feature on SQL Server
2005 regarding adding reporting capabilities to SQL Sever 2005. I am not
sure what it was but I think it had to do with the SQL Server being able to
process a full report request and return the report all ready to print. I
think it was some sort of server reporting engine.
I also noticed that Visual Studio 2005 comes with a control that allows you
to create reports.
My question is, was I smoking crack when I read all this about SQL 2005 new
reporting capabilities? Also, anybody knows if the reporting control that
comes with Visual Studio 2005 is somewhat connected to SQL Server 005?
ThanksSearch and read about "Reporting Services".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rene" <a@.b.c> wrote in message news:uCSIzjQaGHA.508@.TK2MSFTNGP02.phx.gbl...
>I remember reading something about some sort of new feature on SQL Server 2
005 regarding adding
>reporting capabilities to SQL Sever 2005. I am not sure what it was but I t
hink it had to do with
>the SQL Server being able to process a full report request and return the r
eport all ready to
>print. I think it was some sort of server reporting engine.
> I also noticed that Visual Studio 2005 comes with a control that allows yo
u to create reports.
> My question is, was I smoking crack when I read all this about SQL 2005 ne
w reporting
> capabilities? Also, anybody knows if the reporting control that comes with
Visual Studio 2005 is
> somewhat connected to SQL Server 005?
> Thanks
>
>|||On Wed, 26 Apr 2006 03:13:02 -0500, "Rene" <a@.b.c> wrote:

>I remember reading something about some sort of new feature on SQL Server
>2005 regarding adding reporting capabilities to SQL Sever 2005. I am not
>sure what it was but I think it had to do with the SQL Server being able to
>process a full report request and return the report all ready to print. I
>think it was some sort of server reporting engine.
>I also noticed that Visual Studio 2005 comes with a control that allows you
>to create reports.
>My question is, was I smoking crack when I read all this about SQL 2005 new
>reporting capabilities? Also, anybody knows if the reporting control that
>comes with Visual Studio 2005 is somewhat connected to SQL Server 005?
>Thanks
Hi,
You're referring to SQL Server 2005 Reporting Services. Most editions
of SQL Server have some RS functionality.
See
http://www.microsoft.com/sql/prodin...e-features.mspx
for which edtions of SQL Server 2005 have what RS features.
Information about RS is available from
http://www.microsoft.com/sql/techno...ng/default.mspx
and in Books Online.
Andrew Watt [MVP]|||Hi,
look here:
http://www.microsoft.com/sql/techno...ng/default.mspx
The control is for rendering reports also in your other applications
like Windows Forms, rather than *only* in Web projects.-
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

Confused about reporting feature

I remember reading something about some sort of new feature on SQL Server
2005 regarding adding reporting capabilities to SQL Sever 2005. I am not
sure what it was but I think it had to do with the SQL Server being able to
process a full report request and return the report all ready to print. I
think it was some sort of server reporting engine.
I also noticed that Visual Studio 2005 comes with a control that allows you
to create reports.
My question is, was I smoking crack when I read all this about SQL 2005 new
reporting capabilities? Also, anybody knows if the reporting control that
comes with Visual Studio 2005 is somewhat connected to SQL Server 005?
ThanksSearch and read about "Reporting Services".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rene" <a@.b.c> wrote in message news:uCSIzjQaGHA.508@.TK2MSFTNGP02.phx.gbl...
>I remember reading something about some sort of new feature on SQL Server 2005 regarding adding
>reporting capabilities to SQL Sever 2005. I am not sure what it was but I think it had to do with
>the SQL Server being able to process a full report request and return the report all ready to
>print. I think it was some sort of server reporting engine.
> I also noticed that Visual Studio 2005 comes with a control that allows you to create reports.
> My question is, was I smoking crack when I read all this about SQL 2005 new reporting
> capabilities? Also, anybody knows if the reporting control that comes with Visual Studio 2005 is
> somewhat connected to SQL Server 005?
> Thanks
>
>|||On Wed, 26 Apr 2006 03:13:02 -0500, "Rene" <a@.b.c> wrote:
>I remember reading something about some sort of new feature on SQL Server
>2005 regarding adding reporting capabilities to SQL Sever 2005. I am not
>sure what it was but I think it had to do with the SQL Server being able to
>process a full report request and return the report all ready to print. I
>think it was some sort of server reporting engine.
>I also noticed that Visual Studio 2005 comes with a control that allows you
>to create reports.
>My question is, was I smoking crack when I read all this about SQL 2005 new
>reporting capabilities? Also, anybody knows if the reporting control that
>comes with Visual Studio 2005 is somewhat connected to SQL Server 005?
>Thanks
Hi,
You're referring to SQL Server 2005 Reporting Services. Most editions
of SQL Server have some RS functionality.
See
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
for which edtions of SQL Server 2005 have what RS features.
Information about RS is available from
http://www.microsoft.com/sql/technologies/reporting/default.mspx
and in Books Online.
Andrew Watt [MVP]|||Hi,
look here:
http://www.microsoft.com/sql/technologies/reporting/default.mspx
The control is for rendering reports also in your other applications
like Windows Forms, rather than *only* in Web projects.-
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--