New topic: REALSQL log table with timestamp
<http://forums.realsoftware.com/viewtopic.php?t=47559> Page 1 of 1 [ 5 posts ] Previous topic | Next topic Author Message plunkettphoto Post subject: REALSQL log table with timestampPosted: Wed Apr 10, 2013 4:46 pm Joined: Fri Oct 10, 2008 7:14 pm Posts: 78 This seems so easy I can't believe I couldn't just pull up and example in the docs. I'm sure it's there, I just don't seem to be searching correctly. I want my REALSQL database to have a log table that records actions as the users make changes. Just 2 fields in the table: timestamp and description. I have seen where timestamp is a valid REALSQL datatype but how does one set the value from a REALBasic value? thanks for all the help you kind folks have been offering, bill Top simulanics Post subject: Re: REALSQL log table with timestampPosted: Wed Apr 10, 2013 5:16 pm Joined: Sun Aug 12, 2007 10:10 am Posts: 1041 Location: Boiling Springs, SC The best way to learn is to be shown... Goto my website here http://www.realstudiodevspot.com/applic ... hp?view.10 and click "watch the video" it'll show you how to use a realsql database and I also have a code library available on the frontpage at realdevspot.com that you can download with over 400+ snippets and code demos/examples of how to do all sorts of stuff... the entire library was created using realsqldatabase and many pieces of code from within the library more is added all the time... _________________ Matthew A. Combatti Real Studio 2012 r1.2 Visit Real Studio Developer's Spot! Systems I Use: Windows XP/Windows Vista/Windows Server 2008 r2/Windows 7/Windows 8 Mac OSX 10.5/Mac OSX 10.6/Mac OSX Server/Ubuntu/Debian/Suse/Red Hat/ Windows Server 2011/CentOS 5.4 /ReactOS/SimOS ~All REAL Compatible~ Top plunkettphoto Post subject: Re: REALSQL log table with timestampPosted: Wed Apr 10, 2013 6:13 pm Joined: Fri Oct 10, 2008 7:14 pm Posts: 78 Thanks for the reply Matthew and for the link to the nicely done video. Except I didn't see anything about the TimeStamp which is my inquiry. thanks, again, bill Top simulanics Post subject: Re: REALSQL log table with timestampPosted: Wed Apr 10, 2013 6:26 pm Joined: Sun Aug 12, 2007 10:10 am Posts: 1041 Location: Boiling Springs, SC plunkettphoto wrote:Thanks for the reply Matthew and for the link to the nicely done video. Except I didn't see anything about the TimeStamp which is my inquiry. thanks, again, bill Setup two Columns in your table and review the RS docs for the Date class Dim timestamp as new Date Write timestamp.sqltimestamp (or any of the time functions) to the first Column with your description in the second column:-) Apologies, I misread your post. _________________ Matthew A. Combatti Real Studio 2012 r1.2 Visit Real Studio Developer's Spot! Systems I Use: Windows XP/Windows Vista/Windows Server 2008 r2/Windows 7/Windows 8 Mac OSX 10.5/Mac OSX 10.6/Mac OSX Server/Ubuntu/Debian/Suse/Red Hat/ Windows Server 2011/CentOS 5.4 /ReactOS/SimOS ~All REAL Compatible~ Top plunkettphoto Post subject: Re: REALSQL log table with timestampPosted: Wed Apr 10, 2013 6:35 pm Joined: Fri Oct 10, 2008 7:14 pm Posts: 78 That's what I was looking for, thanks, Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 5 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
