New topic: 

How to Save a Text field inscription to SqlIte

<http://forums.realsoftware.com/viewtopic.php?t=38308>

         Page 1 of 1
   [ 5 posts ]                 Previous topic | Next topic          Author  
Message        jetpr          Post subject: How to Save a Text field 
inscription to SqlItePosted: Thu Mar 24, 2011 8:08 pm                         
Joined: Wed Sep 20, 2006 5:12 pm
Posts: 236
Location: Puerto Rico                Hello 

I need to save one Field to the DB but with inscription is a way to do this in 
RB.

     
_________________
Thanks for any contribution  and  God blesses all 
 Mac Mini with Snow Leopard v10.6.6 and Real Studio 2010r5.1 Pro Register user 
   my Hobbies R/C Turbines Jets Models  
                             Top                 eddy2099          Post 
subject: Re: How to Save a Text field inscription to SqlItePosted: Thu Mar 24, 
2011 8:49 pm                         
Joined: Sun Jan 23, 2011 11:59 am
Posts: 122                Something like this 

Code:  rec.Column("FromTextField") = Textfield1.text
  db.InsertRecord("TableName",rec)
  db.commit
      
_________________
RealStudio 2011R1 ♡ Macbook Pro Mac OS X 10.6.6
http://www.batchimage.com
http://www.completemagic.com  
                             Top                 jetpr          Post subject: 
Re: How to Save a Text field inscription to SqlItePosted: Thu Mar 24, 2011 8:56 
pm                         
Joined: Wed Sep 20, 2006 5:12 pm
Posts: 236
Location: Puerto Rico                I mean by protection of inscription for 
one field 
(inscrit data)

     
_________________
Thanks for any contribution  and  God blesses all 
 Mac Mini with Snow Leopard v10.6.6 and Real Studio 2010r5.1 Pro Register user 
   my Hobbies R/C Turbines Jets Models  
                             Top                 timhare          Post subject: 
Re: How to Save a Text field inscription to SqlItePosted: Thu Mar 24, 2011 
10:11 pm                         
Joined: Fri Jan 06, 2006 3:21 pm
Posts: 9547
Location: Portland, OR  USA                I don't think the translation is 
coming across.  Can you describe what you want in other terms?   
                             Top                eddy2099          Post subject: 
Re: How to Save a Text field inscription to SqlItePosted: Fri Mar 25, 2011 
12:06 am                         
Joined: Sun Jan 23, 2011 11:59 am
Posts: 122                Ah, I think I get it. I think he means how to Encrypt 
the Text Field so that he can store it securely in SQLite

If that is the case, you could use the MD5 encryption built into Realbasic

Code:rec.Column("FromTextField") = MD5(TextField1.text)
db.InsertRecord("TableName",rec)
db.commit

But I am not sure how to convert it back to pure text after that  :oops:      
_________________
RealStudio 2011R1 ♡ Macbook Pro Mac OS X 10.6.6
http://www.batchimage.com
http://www.completemagic.com  
                             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]

Reply via email to