I.T. Discussion Community!
-Collapse +Expand
Search Delphi Group:

-Collapse +Expand Delphi To/From
-Collapse +Expand Delphi Store

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyPascal and Delphi Coding BoardDelphi Single User Apps Topic   Print This     

SQL with SQL CE Ver 4

SQL with SQL CE Ver 4 in Delphi Single User Apps topic (part of our Pascal and Delphi Coding group).

Quick Search: SQL SQL   SQL SQL CE   Ver 4  
Ashburton, -- NZ

Hi all

I am having a problem with a program i have been working on and I have been filtering a database by date and client to produce records for a DBChar and it all works fine and as it should . As the record number grows thought I should perhaps use an sql query insted of filter and do you think I can get it to work

I have a SDF Database called CounterData.

I have a field in the database counterDate which is a datetime field  and I have two datetimepickers one startdate and one enddate.

I not strong on sql and can usually make it do what I want but not with dates.

have tried many variants of this

select  * from counterdata where countertranstype ='+quotedstr('D')+'and CounterDate >='+datetostr(startdate.date) +'and counterDate <='+datetostr(enddate.date).

I am using the Devart Sdac components to connect to the SDF Database

Thanks for any help

Owen Moore

 Posted 45 months ago (Thread Starter)
Comment Quote
About owen.moore -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #15427, 1 reply
Thread Started 10/3/2016 4:22:43 PM
View Counter=1240
Last Reply Posted 11/10/2018 4:53:44 AM)
Location=Ashburton, -- NZ 
Joined=17 years ago   MB Posts=7  
Most Recent Post
-- USA

Oh, it's an old issue. I am still facing this problem but one of my friends asked me to visit different edubirdie com sites to get some relevant blog on it. Let's see.

 Posted 20 months ago
Comment Quote
About PS_1860 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17318 (Level 2) and Parent is 15427
Reply Posted 11/10/2018 4:52:27 AM
Location=-- USA 
Joined=20 months ago   MB Posts=1  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1121A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15427 Counter
Since 10/3/2016

Follow PrestwoodBoards on: 

©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech