Hi,
I found a serious bug.
It does not happen in Unidac with SQLServer connectivity only with SDAC.
If you do a query with a parameter and the contents of the field start with a colon you will not get a correct result
SELECT ARTICLE FROM Table1 where article =':SRI' works fine and shows all records with :SRI in the article
SELECT ARTICLE from Table1 where article = :parameter where parameter is :SRI will not return the correct result.
If the parameter does not contain a colon in the beginning the result IS correct.
Providing you have setup a MSTable call dbarticle point to table Article;
The same is true for a combined locate :
dbArticle.Locate('article;otherfield',VarArrayOf([variable1,variable2],[])
where variable1 is :SRI , again it works with variable1 not containing a colon at the start.
Can you fix this, or do you know a workaround ?
Kind regards,
Erik
Bug with locate or select and : in fieldcontents
-
- Posts: 24
- Joined: Thu 11 Nov 2004 08:24
- Location: Moerkapelle
Re: Bug with locate or select and : in fieldcontents
Unfortunately, we can't reproduce the issue. To investigate this behavior of SDAC, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html
You can send the sample using the contact form at our site: devart.com/company/contactform.html