Please help me with filter option.
Is it possible to use the wildcard option Client like '[AB] *' for records that start with 'A' or 'B'? This option works in Access, but it does not work in Unidac Table or FireDac Table as Filter.
TUniTable/TFDTable.Filter wildcard limitation - like '[AB]*'
167 Views Asked by Jiří Baudyš At
1
There are 1 best solutions below
Related Questions in MS-ACCESS
- Ctrl+' for copying from previous record in MS Access not working bilingual in Access 2016
- Updating Access Database using C# and stored procedure does not work
- SQL Left Join not including desired rows
- Published MAUI app doesn't work with access database
- Microsoft access sql query to update last record
- Syntax error in FROM clause C# and MSAccess
- sum function in a report
- Excel column datatype issues using MSADO and Access 2016 Engine driver
- Monitor Scaling Issue for Moveable Access Form using MoveWindow win32 API
- ms-access email electronic signiture
- "Make Trusted Document" warning doesn't trigger until exit, causing "Can't exit now" error
- How to compile java gdal PGEO on apple silicon MacOS to read mdb file?
- Access won't open past the splash screen
- Access, Relationship. Too complicated Syntax?
- Table Update from a form using VBA
Related Questions in DELPHI
- How can I read the header of request to webserver
- Receiving Notifications for Individual Task Completion OmniThreadLibrary Parallel.ForEach
- Delphi - How to get result of function from QuickReport without viewing a report?
- Out of memory while adding documents to a Firebird BLOB field with Delphi
- How to MakeScreenshot fullpage on Delphi
- How to program a COM object with an IEnumerator, IEnumerable interface inside
- How to Dynamically Add Controls to Delphi Form
- How to write a string in Stringrid with DelimitedText in FMX Delphi 11
- TGrid/TStringGrid multi cell selection / multi editing in delphi firemonkey (12)
- How to localize "Today" in the Delphi TMonthCalendar?
- How can I call a SOAP webserver method in Vue.js?
- Efficiently Handling Large Number of API Calls with Delphi 10.4 and OmniThreadLibrary
- Delphi can not compile the unit create by its "XML Data Binding Wizard"
- Save Form Properties in File and then restore those Properties after reopening
- Is it possible to open a blob without saving it to file
Related Questions in DELPHI-10.2-TOKYO
- How to convert JWK to PEM format in Delphi?
- How to connect Delphi to an external DB?
- Selecting the contents of a cell in an FMX Stringgrid in the same way as you can "SelectAll" in an Edit box
- Enabling High DPI makes TImage smaller at runtime than at design-time
- Delphi TEdgeBrowser and OnNavigate event POST data
- Delphi project compilation error: Packages 'A' and 'B' both contain unit 'C'
- Copy TByteDynArray (array of byte) to string
- Sum and count of grouped records
- Speed up image loading in TImage
- In-memory compression of a Zip file
- TActionClientItem to TAction
- How can I detect when a StringGrid cell value has changed?
- How to force bind the IP used by TNetHttpClient with 4 LANs present?
- Why does the Document_Open Macro not run in Word when opening the document from Delphi using Office Automation
- What is the simplest way to get the RTTI properties in ancestral order?
Related Questions in UNIDAC
- How to retrieve two or more fields by using TUniQuery in Delphi/MongoDB?
- Delphi and UniDAC MySQL connect string
- How get the row that causes the error when Appling Updates
- Action On Device Wake Up to Re-establish Socket Connection
- TUniTable/TFDTable.Filter wildcard limitation - like '[AB]*'
- Delphi Unidac MySQL Create Trigger From Memo Code Syntax Error
- Does TUniQuery (UniDac TUniQuery) Last and First methods jump directly or do a record by record scroll
- Unidac / MyDac / SQL - I have problem with fast insert about 1000 rows
- Best way to update detail records from a summary SQL statement in Delphi
- KBMMW ORM MetaExists(mwmdtTable) not supported
- How can I replace WHERE IN choices in WHERE clause to reduce execution time of the request?
- Delphi FMX - Android API 26 - SQLite DB Connection with UniDAC
- obtain the real identity of the connected user
- Why I can not connect to mongodb from unidac?
- Delphi XE7 unidac rounding issue
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Solution is use FilterSQL, Unidac(8*), in Unidac 9* is this problem fixed (i think) https://www.devart.com/unidac/revision_history.html