Dbexpress Error Invalid Field Type
Contents |
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea
Dbexpress Error Invalid Precision
(South)Russian FederationSpain Embarcadero Home Watch, Follow, & Connect dbexpress error invalid username/password with Us Share This Communities Articles Blogs Resources Downloads Help Submit Translation Printer-friendly EDN dbexpress error 0x0015 » Delphi » Database Show All [All] dbExpress Error: Invalid Field Type when using a ftDateTime param type with Oracle By: Angel Martinez Abstract: explains how to work around the Invalid Field Type Error Problem: When I try and use a Parameter of field type ftDateTime in a query with dbExpress, I get the following: dbExpress Error: Invalid Field Type Solution: Rather than use ftDateTime as the param field type, use ftTimeStamp. You will need to create a variable of type TSQLTimeStamp and use the DateTimeToSQLTimeStamp function if you want to convert a TDateTime value to a TSQLTimeStamp. You will need to add: SqlTimSt to your uses clause. Here is a code snippet that demonstrates using SQLTimeStamp: procedure TForm1.UseTimeStamp(myDate: TDateTime); var mySTS: TSQLTimeStamp; begin mySTS := DateTimeToSQLTimeStamp(myDate); with SQLQuery1 do begin Params.CreateParam(ftTimeStamp, 'DATE', ptInput); ParamByName('DATE').AsSQLTimeStamp := mySTS; SQL.Text := 'INSERT INTO PARAMTABLE ' + '(DATEFIELD) ' + 'VALUES (:DATE)'; ExecSQL(false); end; end; Latest Comments View AllAdd NewRSSATOM Move mouse over comment to see the full text Reply Posted by Craven Weasel on Dec 10 2004dbExpress Error: Invalid Field Type when using a ftDateTime param type with OracleThe error message disapears, but the query returns nothing Rating Average ratin
Page 1 of 1 dbexpress error: [0x0003] invalid field type by Gilberto » Wed 05 Jul 2006 05:18 Hi, When I have parameters with data type INTEGER occurs the following error for any sql instruction: dbexpress error: [0x0003] invalid field type I using: Delphi 7 test with Oracle 8 and 9. Tks. Gilberto Top by Challenger » Wed 05 Jul 2006 09:04 We couldn't reproduce this error. Please send to DbxOda support address complete sample that demonstrates this problem and include script to create server objects. Challenger Devart Team Posts: 925Joined: Thu 17 Nov 2005 10:53 Top by http://edn.embarcadero.com/article/30078 Gilberto » Wed 05 Jul 2006 16:30 Example: select * from xxxx where id = :id where, id is integer. I use Delphi 7. How I updating to dbexpress 3.0 ???? I think that is problem it´s because version of my dbexpress. Tks. Gilberto Top by Challenger » Thu 06 Jul 2006 13:13 Please specify the version of DbxOda you use. Challenger Devart Team http://forums.devart.com/viewtopic.php?t=5706 Posts: 925Joined: Thu 17 Nov 2005 10:53 Top by Gilberto Muller » Fri 07 Jul 2006 01:06 Drivername: Oracle GetDriverFunc: getSQLDriverORACLE Libraryname: dbexpora.dll Gilberto Muller Top by Challenger » Fri 07 Jul 2006 14:07 This is the forum dedicated to CoreLab dbExpress driver for Oracle. For information on standard dbExpress Oracle driver please refer to corresponding resources. Challenger Devart Team Posts: 925Joined: Thu 17 Nov 2005 10:53 Top by Gilberto Müller » Fri 07 Jul 2006 14:48 Wich resources? Where is forum Dbexpress Standard ??? Gilberto Müller Top by Challenger » Mon 10 Jul 2006 12:22 You can try to find any informtation on Borland web site. Challenger Devart Team Posts: 925Joined: Thu 17 Nov 2005 10:53 Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Post a reply 8 posts • Page 1 of 1 Return to dbExpress driver for Oracle Jump to: Select a forum ------------------ General Forums Announcements Database Tools dbForge for MySQL dbForge for Oracle dbForge for PostgreSQL dbForge for SQL Server ADO.NET Data Providers Entity Framework support LinqConnect (LINQ to SQL support)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies http://stackoverflow.com/questions/4662656/bcb-from-bde-to-dbexpress-bcd-exception of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges http://www.nldelphi.com/showthread.php?26230-dbExpress-Error-Invalid-Field-Type-for-MS-SQL-server-query-with-date-time-parameter Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: dbexpress error Sign up BCB: from BDE to dbexpress, BCD exception up vote 2 down vote favorite I'm having some problem about TSQLStoredProcedure. Here is the code: storedproc->ParamByName("A")->AsInteger = adataset->FieldByName("AA")->AsInteger; storedproc->ExecProc(); param "A" is declared integer in the form (and it's 29 in the program). Also the stored procedure has no errors. I'm sure of it. Database is Oracle 11g. By the way, as dbexpress error invalid storedproc is executed an exception occurred: ... EBcdException with message '<0000001:000000010000000:00000063612>' is not a valid BCD value ... All was working fine with BDE but now, using dbexpress, there is this problem. I searched over the internet for some days and I did not find an answer. I thank you in advance and beg a pardon for my English. Francesco Update I searched over the web. I found something interesting at: https://forums.codegear.com/thread.jspa?messageID=43223&tstart=0 http://www.delphigroups.info/2/8/750511.html I decide to make some test: SQLQuery->ParamByName("f1")->AsString = Edit1->Text; SQLQuery->ExecSQL(); It works. Not the same for SQLQuery->ParamByName("f1")->AsInteger = StrToInt(Edit1->Text); //ERROR DBX Error: Invalid Field Type. SQLQuery->ParamByName("f1")->AsFloat = StrToFloat(Edit1->Text); //ERROR DBX Error: Invalid Field Type. SQLQuery->ParamByName("f1")->AsBCD = StrToInt(Edit1->Text); //ERROR ORA-06502: PL/SQL: error: ... ORA-06512: at line 1. SQLQuery->ParamByName("f1")->AsFMTBCD = StrToBcd(Edit2->Text); //ERROR ORA-06502: PL/SQL: error: ... ORA-06512: at line 1. or by using TSQLStoredProc. So now I call my pl/sql stored proc by TSQLQuery. I use "AsString" to pass values to parameters. Weird. How does dbexpress map types? Thanks in advance. oracle porting dbexpress bde share|improve this question edited Mar 31 '11 at 17:20 Tim Post♦ 25k1281146 asked Jan 11 '11 at 21:06 F
Type, for MS SQL-server query with date-time parameter If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: dbExpress Error: Invalid Field Type, for MS SQL-server query with date-time parameter Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 22-Nov-06,12:46 #1 MaartenVR View Profile View Forum Posts View Blog Entries View Articles Registered User Join Date Nov 2006 Posts 2 dbExpress Error: Invalid Field Type, for MS SQL-server query with date-time parameter Ik gebruik Delphi6 en MS SQLserver en ben tegen de volgende bug van dbExpress aangelopen (ik herhaal hier de melding die ik op de borland site heb gezet). Heeft iemand een alternatief voor de door Borland genoemde work-around? We have a MS SQL Server database and we use dbExpress to connect to it (with driver dbexpmss.dll, vendorLib OleDb). When we want to use a query and it has a date-time parameter, we get the error: 'EdatabaseError: dbExpress Error: Invalid Field Type.' I found a work-around, which in brief says: use TSQLTimeStamp in stead of TdateTime (see http://bdn1.borland.com/article/0,1410,30078,00.html), and indeed this works. The only problem is that we already have a large application which contains a lot of these kind of parameterized queries, so it would take a lot of time to re-program. Our application works fine with Interbase and Firebird as database, but now we have a new customer who wants to use MS SQL-server. When we started building our application, we chose for dbExpress because it claimed to be database-independent, but apparently itÔÇÖs not. In another similar bug-report (see report 11090) I read that Borland gave this bug the status ÔÇÿclosedÔÇÖ, but to really forfill the claim about database-independence, this bug should be fixed. Reply With Quote 08-Dec-06,23:51 #2 PeterVercruysse View Profile View Forum Posts View Blog Entries View Articles senior member Join Date Nov 2006 Location Rijsel Posts 1,608 Geb