What do I use for input query parameters in Table Adapter.
"Where Fid = @fid"  ( and ? and  :  ) fail.

Ivan

>What do I use for input query parameters in Table Adapter.
>"Where Fid = @fid" ( and ? and : ) fail.

I'm probably not going to be able to help because I'm Delphi based, but it would be helpful if you quoted the ElevateDB version & environment

From the snippet you've posted it looks as though you're trying to insert a field name in the condition and that's something that ElevateDB (at least in the Delphi version) does not support. The only way is to build te query manually.

Roy

Visual Studio 2017
EDB 2.27b1 ODBC

This query returns values as expected.
SELECT  *  FROM   FPJ  WHERE Fid = '{029F812E-A9DE-4F90-A31A-64F9A2C113CE}'

In other DB's such as MS SQL, the input parameter is done like this. I believe MS Access uses a "?".
SELECT  *  FROM   FPJ  WHERE Fid = @fid
but with EDB, "Error in WHERE clause near '@'. Unable to parse query text".

I can work around this by feeding in new select text, but, thought there might be a simple answer.

Ivan Sine wrote:

>  thought there might be a simple answer.

There is, I'm sure, but finding it is the harder part. 8-)

I've checked the .Net provider code I have, and it is using parameters, so there must be a way. Key is, is it the ram format, or some other ODBC specific variant. Can't help further I'm afraid - I can't see it on a basic look...

I suspect it will be an ODBC standard thing.

Ivan


Matthew is probably right. Looking at the code you have @fid - why? If this is what you're using try :fid. I'd also like to see how you're assigning the parameter.

Roy Lambert

"Where Fid = @fid"  ( and ? and  :  ) fail.
....

Hi Roy. It's not something I'm doing wrong. I just don't know how to indicate a parameter in Visual Studio's  Table Adapter, when using EDB-ODBC. It's either not an option, or EDB is using something other than the standard @ or ?.

Like I said, not a big deal, just curious.  I've worked around by assigning Adapter.SelectCommand.CommandText

Ivan

I'm pleased that you have something that works.

I've just taken the time to look at the on-line manual for the .net data provider

https://www.elevatesoft.com/articles?action=view&category=edb&article=elevatedb_20_net_data_provider_tips_tricks

and it seems to have a nice clear example of using parameters.


Roy Lambert

Ivan,

<< What do I use for input query parameters in Table Adapter. >>

You should use : as a parameter marker with the EDB .NET Data Provider.

What error are you seeing when you use the : (colon), and how are you using it ?

Also, please be aware of this issue with VS2017:

https://www.elevatesoft.com/incident?action=viewaddr&category=edb&release=2.28&incident=4620

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

Also, please be aware of this issue with VS2017:

https://www.elevatesoft.com/incident?action=viewaddr&category=edb&release=2.28&incident=4620


Hi Tim,

Looks like the same problem/error. No immediate plans to update. But when I do, I will retest.
I have attached a screenshot.

Ivan

I can't remember why, but I think I had to create the parameter fields before I could reference them. What are the advanced options available there?

I seem to recall that Delphi has the big advantage in that you specify the query and it works out the params. The Visual Studio dialog needed me to create the list of params first, and then I could reference them.

Or maybe I remember incorrectly...