BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Parameterised query          BorlandTalk.com Forum Index -> Delphi Databases (Desktop) View previous topic :: View next topic   Author Message Alan Guest Posted: Tue Jan 13, 2004 3:06 pm    Post subject: Parameterised query I use parameterised query as follows query1.ParamByName('StartVal').AsFloat := NewValue; The actual data type for StartVal in the database is Number(4,2). I declared NewValue as REAL type in the Delphi program. But it doesn't retrieve any record from the table eventhough matching data exist in the table. I am using Dbase. What am I doing wrong? Back to top Alan Guest Posted: Tue Jan 13, 2004 3:44 pm    Post subject: Re: Parameterised query Didn't work. "Ignacio Vazquez" <ivazquezATorioncommunications.com> wrote: Quote: Alan wrote: What am I doing wrong? Try using Currency and .AsCurrency instead of Real and .AsFloat. -- Cheers, Ignacio Help improve Delphi: http://qc.borland.com/ Back to top Ignacio Vazquez Guest Posted: Tue Jan 13, 2004 4:15 pm    Post subject: Re: Parameterised query Alan wrote: Quote: What am I doing wrong? Try using Currency and .AsCurrency instead of Real and .AsFloat. -- Cheers, Ignacio Help improve Delphi: http://qc.borland.com/ Back to top Bill Todd (TeamB) Guest Posted: Tue Jan 13, 2004 10:09 pm    Post subject: Re: Parameterised query Trying to locate a number using a floating point value is not likely to work because floating point notation cannot represent most decimal fractions exactly. Try using a range. For example, if you are looking for 1.23 try Quote: 1.299 and < 1.301 -- Bill (TeamB) (TeamB cannot respond to questions received via email) Back to top Alan Guest Posted: Wed Jan 14, 2004 8:41 am    Post subject: Re: Parameterised query I used range but didn't work. I converted string value to float (StrToFloat) and then pass to parameter field as Float (ParamByName('FldNm').AsFloat). I use number field with two decimal places to store time (Strat time and End time) since time field not available in Dbase iv. I need an hour and half an hour time slots only (for example, 7am store as 7.00, 3.30pm store as 15.50 in the table). I have a function to check whether the given start and End time slot is available to add a new record. To do that I use the following query. ((StartTime < :ApptEnd AND :ApptEnd < EndTime) OR (StartTime = :ApptStart AND :ApptEnd = EndTime) OR (StartTime < :ApptStart AND :ApptStar < Endtime) OR (:ApptStart < StartTime AND :ApptEnd > EndTime) OR (StartTime = :ApptStar AND EndTime < :ApptEnd) OR (:ApptStart < StartTime AND :ApptEnd = EndTime)) "Bill Todd (TeamB)" Quote: Trying to locate a number using a floating point value is not likely to work because floating point notation cannot represent most decimal fractions exactly. Try using a range. For example, if you are looking for 1.23 try 1.299 and < 1.301 -- Bill (TeamB) (TeamB cannot respond to questions received via email) Back to top Alan Guest Posted: Wed Jan 14, 2004 12:46 pm    Post subject: Re: Parameterised query Thanks any way Bill. Regards, Alan "Bill Todd (TeamB)" <no (AT) no (DOT) com> wrote: Quote: Other than floating point imprecision I have no idea. Perhaps someone with more dBase table experience will be able to help. -- Bill (TeamB) (TeamB cannot respond to questions received via email) Back to top Bill Todd (TeamB) Guest Posted: Wed Jan 14, 2004 12:57 pm    Post subject: Re: Parameterised query Other than floating point imprecision I have no idea. Perhaps someone with more dBase table experience will be able to help. -- Bill (TeamB) (TeamB cannot respond to questions received via email) Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (Desktop) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.