Bde Error Capability Not Supported
Contents |
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea (South)Russian FederationSpain Embarcadero Home Watch, Follow, & Connect with Us Share This Communities Articles Blogs Resources Downloads Help Submit Translation Printer-friendly EDN » Delphi » capability not supported delphi bde Database » Database Engines Show All [All] Handling the "Capability not supported" error By:
Bde Error 8458
Borland Staff Abstract: An application written using the BDE, Delphi, or C++ Builder may return an error "Capability not supported." Problem: bde error 9473 An application written using the BDE, Delphi, or C++ Builder may return an error "Capability not supported." Solution: This error is returned by the BDE when the BDE parses an SQL string to be sent to
Bde Error $210d
a server and the syntax of the string is not supported by the BDE. See below for more information on how the BDE sends pass through SQL strings to DBMS servers and ODBC data sources. The BDE, and Delphi and C++ Builder applications that use data-aware components send SQL strings to DBMS servers and ODBC data sources depending on the setting of the SQLQRYMODE parameters. The settings of the SQLQRYMODE parameter are bde error 13059 listed in the BDE Administrator Help (formerly known as the BDE Configuration Help) file, and are paraphrased below: - The SQL string is sent to the server or ODBC data source first. If an error is returned the string is then parsed and ran by the BDE. SERVER - The SQL string is sent to the server or ODBC data source, if an error is returned then the error is placed on the BDE error stack and the appropriate BDE error is returned. LOCAL - The SQL string is parsed and ran by the BDE. When the BDE parses and runs the SQL string due to the SQLQRYMODE being set to blank or LOCAL, if the SQL string to be parsed is not supported by the BDE the error "Capability not supported" is returned. The SQLQRYMODE parameter is found in both BDE alias definitions and in BDE driver definitions. The BDE will look for this parameter first in the alias definition, if it is not found or the entry not a recognized value or is corrupted then the BDE will look at this parameter in the driver definition. Alias definitions can be created by using TDatabase component, by using the DbiOpenDatabase() and DbiAddAlias() BDE API calls, and by using the BDE Administrator
Tag Search Advanced Search Go to Page... Thread Tools Display Modes #1 07-01-2005, 02:07 AM gtsakiri Member Join Date: May 2005 Posts: 40 capability not supported Hello friends! I have already finished my
Bde Error 8712
database application(based on BDE technology) and built my executable file.I have no problem when
Bde Error $000f
I work with it to my computer.But,when I install the program an all the libraries that have to be installed to an bde error $2501 other specific computer, in some forms an error occurs which says:"Capability not supported".What may cause it? The same program has no problem to other computers. gtsakiri View Public Profile Send a private message to gtsakiri http://edn.embarcadero.com/article/25183 Visit gtsakiri's homepage! Find all posts by gtsakiri #2 07-01-2005, 02:50 AM LörAn Senior Member Join Date: Mar 2001 Posts: 1,506 RE: capability not supported Maybe it's dued to a different DB provider (or a different version of your provider) Did you install the same BDE onto this other computer ? LörAn. MAIL: loran@superheros.as ICQ : 112714184 LörAn View Public Profile Send a private message to LörAn Visit LörAn's http://www.delphipages.com/forum/showthread.php?t=138278 homepage! Find all posts by LörAn #3 07-01-2005, 03:44 AM digitiger Senior Member Join Date: Jan 2001 Posts: 716 RE: capability not supported Generally this error is returned by bde when is is not able to execute some sql on the underlying database. so in just check all your sql scripts and specially the functions and key words used in them. may be for testing purpose you can display the sql script in some edit box just before executing them so that you can check the sql script when ever you get the error msg and then try the same script from outside the database using database utilities to see if error is due to that or not hope it helps and if it does then do accept the answere digitiger View Public Profile Send a private message to digitiger Visit digitiger's homepage! Find all posts by digitiger #4 07-01-2005, 04:58 AM douglas Senior Member Join Date: Jul 2001 Posts: 7,695 RE: capability not supported Straight from borland... http://213.45.21.18/~azzani/borland/interbase-faq/25183.html If this helps, please accept as answer! UnSysApps douglas View Public Profile Send a private message to douglas Visit douglas's homepage! Find all posts by douglas #5 07-01-2005, 04:58 AM douglas Senior Member Join Date: J
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job https://www.experts-exchange.com/questions/20853314/Capability-not-supported-error-with-SQLServer-and-ODBC-is-there-a-solution.html Ways to Get Help Expand Search Submit Close Search Login Join Today Products https://groups.google.com/d/topic/borland.public.bde/0rDL1npkY6Y BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Capability not supported error with SQLServer and ODBC - is there a solution? Want to Advertise Here? Solved Capability not supported error with SQLServer and ODBC - is there a solution? Posted on 2004-01-16 Delphi 1 Verified bde error Solution 4 Comments 857 Views Last Modified: 2011-09-20 The following query: select * from table where (1=1) and ForignKey in ( 0, 2, 3 ) returns an error if I try to open it with RequestLive set to true. If I set RequestLive to false then it opens ok. I need to edit the values returned by this query. Is there a way?? I know that using capability not supported ADO will solve my problem but since I am planning to run this program with other databases I cannot switch to ADO right now. Delphi 5, updates 1 and 2. 0 Question by:rmaranhao Facebook Twitter LinkedIn Google LVL 27 Active 3 days ago Best Solution bykretzschmar >Do you know what clauses will require the UpdateObject even if I am >using a single table? usualy caused, if the bde was unable to determine the primary key. this depends on the database, used driver Go to Solution 4 Comments LVL 27 Overall: Level 27 Delphi 26 Message Active 3 days ago Expert Comment by:kretzschmar2004-01-16 you have to use a TUpdateSQL attached as UpdateObject (property) of your tquery and run the query with cachedUpdates(property) = true to set the insert/update/delete statements just use the wizard, which comes up with a dblClick don't forget to use query.ApplyUpdates; query.CommitUpdates; in the afterpost and afterdelete-events just tell me, if this may a way for you btw. ado supports also multiple databases meikl ;-) 0 LVL 5 Overall: Level 5 Message Author Comment by:rmaranhao2004-01-16 Ok. This solves one problem. What I still don't understand is why won't the BDE allow me to run
from GoogleSign inHidden fieldsSearch for groups or messages