Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
little-big problem with Report Builder... |
Wed, Mar 1 2006 3:03 PM | Permanent Link |
"Santy Concepción" | 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)! |
Wed, Mar 1 2006 5:03 PM | Permanent Link |
"Terry Swiers" | > 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) --------------------------------------- |
Thu, Mar 2 2006 4:43 AM | Permanent Link |
"Santy Concepción" | 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) > --------------------------------------- > > |
This web page was last updated on Tuesday, April 23, 2024 at 08:10 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |