A different resource than a printed book, but one I find indispensable, is an R:Docs subscription. A bit more than a book, but it’s right there when you need it and you can cut and paste the code running it side by side with R:Base. The on line resources listed at the bottom of the post here, in particular Razzak/s FTE series is invaluable as well.
Albert > On May 27, 2018, at 3:18 AM, Cathy Grimes <[email protected]> wrote: > > Please add me to where I can buy an R:Base book newer than my R:Base 4.0 and > 4.5 manuals. I have R:Base Extreme 9.5 (32) and the changes are too much to > make those manuals helpful anymore. I haven’t had much luck at all using the > software’s Help function, so this Forum has made my R:Base use so much easier > and better. And having a “How-To” manual that works for my R:Base would be > wonderful! > > Cathy > > From: [email protected] <mailto:[email protected]> > [mailto:[email protected] <mailto:[email protected]>] On Behalf > Of Hannaway, Lance > Sent: Saturday, May 26, 2018 11:45 AM > To: [email protected] <mailto:[email protected]> > Subject: Re: [RBASE-L] - Blank date value > > Hi guys, what book is this, I am looking for a good SQL reference book since > all of my coding goes back to the Rbase for Dos days! > > > Sent from my Verizon, Samsung Galaxy smartphone > > > -------- Original message -------- > From: Claudine Robbins <[email protected] <mailto:[email protected]>> > Date: 5/25/18 4:06 PM (GMT-05:00) > To: [email protected] <mailto:[email protected]> > Subject: RE: [RBASE-L] - Blank date value > > CAUTION: This Email is sent from outside our organization. Please DO NOT > Click on any links or open any attachments unless you recognize the sender. > Please forward any Suspicious Email "as an attachment" to [email protected] > <mailto:[email protected]> > > > No problem Bill. I still refer to your and David’s SQL book almost monthly. > > Claudine > > From: [email protected] <mailto:[email protected]> > [mailto:[email protected] <mailto:[email protected]>] On Behalf > Of Bill Downall > Sent: Friday, May 25, 2018 1:31 PM > To: [email protected] <mailto:[email protected]> > Subject: Re: [RBASE-L] - Blank date value > > So sorry. I jumped in to the middle of the conversation, and missed the main > details. > > > (sent from Moto Z) > > On Fri, May 25, 2018, 8:34 AM karentellef via RBASE-L > <[email protected] <mailto:[email protected]>> wrote: >> Bill: She's saying that NULL date values are displaying like that in a >> form. >> >> Claudine: does the database see them as null? If you did a select where >> datecol is null, do they show up? >> >> Karen >> >> >> >> -----Original Message----- >> From: Bill Downall <[email protected] <mailto:[email protected]>> >> To: rbase-l <[email protected] <mailto:[email protected]>> >> Sent: Fri, May 25, 2018 7:19 am >> Subject: Re: [RBASE-L] - Blank date value >> >> Claudine, >> >> If you can write a WHERE clause that finds all the bad dates, you should be >> able to write an UPDATE that fixes them. >> >> Are all the wrong dates off by exactly a century? If not, you will have to >> make your WHERE clause more complicated, and do this more than once. >> >> SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900' >> >> UPDATE tablename SET datecolumn = + >> (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) + >> WHERE datecolumn <= '01/01/1900' >> >> Bill >> >> On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins <[email protected] >> <mailto:[email protected]>> wrote: >> Hello all, >> >> I’m on latest release. Some null values in a date field on a form are >> coming up 12/30/99, fully extended to 12/30/1899! There are no values in >> that field in the table and the field correctly takes whatever date is >> inserted and saves it to the table. >> >> I switched from 2-digit year to 4-digit year a few months ago and wonder if >> that’s when this started. I reloaded the database, ran it through R:Scope >> and all is sound. >> >> Any ideas on how to fix this? >> >> TIA, >> >> Claudine >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <http://www.rbase.com/support/usersgroup_guidelines.php> >> --- >> You received this message because you are subscribed to the Google Groups >> "RBASE-L" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. >> >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <http://www.rbase.com/support/usersgroup_guidelines.php> >> --- >> You received this message because you are subscribed to the Google Groups >> "RBASE-L" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <http://www.rbase.com/support/usersgroup_guidelines.php> >> --- >> You received this message because you are subscribed to the Google Groups >> "RBASE-L" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > Confidentiality Note: This e-mail is intended only for the person or entity > to which it is addressed and may contain information that is privileged, > confidential or otherwise protected from disclosure. Dissemination, > distribution or copying of this e-mail or the information herein by anyone > other than the intended recipient, or an employee or agent responsible for > delivering the message to the intended recipient, is prohibited. If you have > received this e-mail in error, please contact the originator of this e-mail > and destroy the original message and all copies. > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
