Hi!

I'm using DBISAM with RBuilder Pro 10.01
I need to change the report sql (QueryDataViews) at runtime.
I use the "CreateAutosearchCriteria" procedures to add criterias to the SQL
query, but I have one big problem with this using DBISAM (not with Paradox)

If I add a AutoSearch criteria, the criteria is added between two " "
(double quotes)
With Paradox there is no problem, because "A" is equal to 'A'.

BUT with DBISAM, "A" is not a valid syntax.

How can I fix it? Is it better to contact ReportBuilder to change its code,
or can I use souble quites in DBISAM SQL syntax (maybe in version 5)?

Thanks (again)!

> How can I fix it? Is it better to contact ReportBuilder to change its
> code,
> or can I use souble quites in DBISAM SQL syntax (maybe in version 5)?

Check the SQLType property of the designer and/or report object.  It's
probably set to sqBDELocal, but needs to be set to sqSQL2 in order to work
with DBISAM.

--

---------------------------------------
 Terry Swiers
 Millennium Software, LLC
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Ok, I solved it with a simple...

         TdaQueryDataView(lDataView).SQL.SQLType:=sqSQL2;

....before adding the SearchCriterias.


"Terry Swiers" <millennnium@1000years.com> escribió en el mensaje
news:C526B52C-5266-4FAF-963B-E40D1B7CFE3D@news.elevatesoft.com...
>
>> How can I fix it? Is it better to contact ReportBuilder to change its
>> code,
>> or can I use souble quites in DBISAM SQL syntax (maybe in version 5)?
>
> Check the SQLType property of the designer and/or report object.  It's
> probably set to sqBDELocal, but needs to be set to sqSQL2 in order to work
> with DBISAM.
>
> --
>
> ---------------------------------------
>  Terry Swiers
>  Millennium Software, LLC
>  http://www.1000years.com
>  http://www.atrex.com
>
>  Atrex Inventory Control/POS -
>     Big business features without spending big business bucks!
>
> Atrex Electronic Support Options:
>  Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
>  Email: mailto:support@atrex.com
>  Newsgroup: news://news.1000years.com/millennium.atrex
>  Fax: 1-925-829-1851
>  Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
>  ---------------------------------------
>
>