Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Tue May 22, 2018 10:29 pm
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: REALSQL log table with timestamp
PostPosted: Wed Apr 10, 2013 4:46 pm 
Offline
User avatar

Joined: Fri Oct 10, 2008 7:14 pm
Posts: 94
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
 Profile  
Reply with quote  
 Post subject: Re: REALSQL log table with timestamp
PostPosted: Wed Apr 10, 2013 5:16 pm 
Offline
User avatar

Joined: Sun Aug 12, 2007 10:10 am
Posts: 1086
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 Xojo 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 Xojo Compatible~


Top
 Profile  
Reply with quote  
 Post subject: Re: REALSQL log table with timestamp
PostPosted: Wed Apr 10, 2013 6:13 pm 
Offline
User avatar

Joined: Fri Oct 10, 2008 7:14 pm
Posts: 94
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
 Profile  
Reply with quote  
 Post subject: Re: REALSQL log table with timestamp
PostPosted: Wed Apr 10, 2013 6:26 pm 
Offline
User avatar

Joined: Sun Aug 12, 2007 10:10 am
Posts: 1086
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 Xojo 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 Xojo Compatible~


Top
 Profile  
Reply with quote  
 Post subject: Re: REALSQL log table with timestamp
PostPosted: Wed Apr 10, 2013 6:35 pm 
Offline
User avatar

Joined: Fri Oct 10, 2008 7:14 pm
Posts: 94
That's what I was looking for,

thanks,


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


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

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group