Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Connectivity » View Thread |
Messages 1 to 10 of 12 total |
TableAdapter parameter |
Thu, May 10 2018 3:59 PM | Permanent Link |
Ivan Sine | What do I use for input query parameters in Table Adapter.
"Where Fid = @fid" ( and ? and : ) fail. |
Fri, May 11 2018 2:54 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, May 11 2018 10:00 AM | Permanent Link |
Ivan Sine | 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. |
Fri, May 11 2018 10:24 AM | Permanent Link |
Matthew Jones | 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. |
Fri, May 11 2018 11:44 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, May 11 2018 12:35 PM | Permanent Link |
Ivan Sine | "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 |
Sat, May 12 2018 2:29 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, May 17 2018 12:13 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, May 17 2018 9:09 PM | Permanent Link |
Ivan Sine | 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 Attachments: Capture.JPG |
Fri, May 18 2018 11:39 AM | Permanent Link |
Matthew Jones | 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... |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |