Tim

Just to get the syntax right I pasted this into EDBManager as a new query

SELECT * FROM Articulos WHERE CODIGO COLLATE ANSI =?

It ran - empty dataset as the result but I would have expected either an error message or a prompt for a value, probably the former.

Roy Lambert

Roy,

<< Just to get the syntax right I pasted this into EDBManager as a new query

SELECT * FROM Articulos WHERE CODIGO COLLATE ANSI =?

It ran - empty dataset as the result but I would have expected either an
error message or a prompt for a value, probably the former. >>

Nope - you're effectively specifying a native parameter placemark, which is
valid (ODBC uses this, for example).  However, the application must then add
the parameter manually also, which the EDB Manager is not capable of doing.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Nope - you're effectively specifying a native parameter placemark, which is
>valid (ODBC uses this, for example). However, the application must then add
>the parameter manually also, which the EDB Manager is not capable of doing.

Didn't you forget the "yet"?

Roy Lambert

Roy,

<< Didn't you forget the "yet"? >>

No.  Why would we need to allow for manual parameter adding when you can use
the colon notation in the actual SQL to specify a parameter addition right
now ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>No. Why would we need to allow for manual parameter adding when you can use
>the colon notation in the actual SQL to specify a parameter addition right
>now ?

The only reason I can think of is that its valid sql and if I want to test a statement in EDBManager I have to alter it. One of the nice improvements from DBSys is that I can enter parameters so I'm removing one more point of cock up in testing.

Roy Lambert

Roy,

<< The only reason I can think of is that its valid sql and if I want to
test a statement in EDBManager I have to alter it. >>

But this isn't really an SQL statement that you would enter into your Delphi
application either, so I'm not sure where the altering part is coming in.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>But this isn't really an SQL statement that you would enter into your Delphi
>application either, so I'm not sure where the altering part is coming in.

True, where it came from in my case was I wanted to test a portion of a procedure so just cut'n'paste into a query...

Roy Lambert