Hello, Like is only defined for char fields. So dbforms generates like only for char fields. You can use the shortcuts with mm/dd/yyyy- but no like
Regards, Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Srinadhan Samudrala > Gesendet: Dienstag, 5. Juli 2005 18:43 > An: jdbforms-interest@lists.sourceforge.net > Betreff: [dbforms] Requesting guidance Date searches in DB forms > > I am an newbie to DBforms and has trouble > understanding/implementing the Date searches... > I got a DBform where in I need to search by the dates and my > backend DBMS is oracle. and value is stored in as 'mm/dd/yyyy > hh:mi:ss am' > > that date is stored in as 6/9/2005 5:15:15 PM > > When I tried to search this with anykind ALOGIRTHM modes ie > Weakend, Weak start.. etc.. my search condition is always > resulting = but never LIKE.. > I see LIKE happening only 'CHAR' datatypes but not DATE data types...? > > Is there something I need to do., Does Preselect Interceptor > is going to help me.. Any help or pointers is really appreciated > > My end user would like to search only > > mm/dd/yyyy format ie 05/12/2005 > > > I got the ApplicationResources.properties configured.. > > Please help > > /SS > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration > Strategies from IBM. Find simple to follow Roadmaps, > straightforward articles, informative Webcasts and more! Get > everything you need to get up to speed, fast. > http://ads.osdn.com/?ad_idt77&alloc_id492&op=ick > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms