Re: RB Database (REALbasic getting started Mailinglist archive)
Back to the thread list
Previous thread: Database List?
Next thread: Displaying a image with alpha-channel properly
| Re: RB Database |
| Date: 01.04.04 18:22 (Thu, 1 Apr 2004 12:22:56 -0500) |
| From: tom.russell transport.alstom.com |
|
Will Leshner <<email address removed>>@lists.realsoftware.com on 04/01/2004 10:52:41 AM >You can either use a DatabaseRecord to do it, or you can use SQL >directly to do an INSERT. Im not sure what a databaserecord is?? :.________________ CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| Re: RB Database |
| Date: 01.04.04 18:21 (Thu, 1 Apr 2004 12:21:12 -0500) |
| From: tom.russell transport.alstom.com |
|
Terry wrote: For fullscreen windows use the FullScreen property. You can set this in the Properties window or in code. Im aware of this, but in windows it looks terrible and does not give you the buttons at the top. I need to do something like window(0).move or something similar. Tom :.________________ CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| RB Database |
| Date: 01.04.04 15:00 (Thu, 1 Apr 2004 09:00:42 -0500) |
| From: tom.russell transport.alstom.com |
|
How does one add records to an rb database? Its easy to add the table and field items but where and how do I add the records? Also here's a kicker.... These 2 lines when put into a event for your window make the window the size of the screen but does'nt center it........its off by a little bit. How do you move it to make it centered? window1.heightmreen(0).Height window1.width.reen(0).width Thnaks. Tom :.________________ CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| Re: RB Database |
| Date: 01.04.04 16:52 (Thu, 1 Apr 2004 07:52:41 -0800) |
| From: Will Leshner |
|
On Apr 1, 2004, at 6:00 AM, <email address removed> wrote: > How does one add records to an rb database? Its easy to add the table > and > field items but where and how do I add the records? > You can either use a DatabaseRecord to do it, or you can use SQL directly to do an INSERT. - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| Re: RB Database |
| Date: 01.04.04 17:30 (Thu, 1 Apr 2004 08:30:23 -0800) |
| From: Terry Findlay |
|
For how to add records check out the database example at:
http://www.ttpsoftware.com/ReallyBasicRB/databases.html For fullscreen windows use the FullScreen property. You can set this in the Properties window or in code. Cheers, Terry ----------------------------------------------------------- www.ttpsoftware.com www.ttpsoftware.com/reallybasicrb/ On Apr 1, 2004, at 6:00 AM, <email address removed> wrote: > > How does one add records to an rb database? Its easy to add the table > and > field items but where and how do I add the records? > > Also here's a kicker.... > > These 2 lines when put into a event for your window make the window the > size of the screen but does'nt center it........its off by a little > bit. > How do you move it to make it centered? > > window1.height}reen(0).Height > window1.width<reen(0).width > > Thnaks. > > Tom > > :.________________ > CONFIDENTIALITY : This e-mail and any attachments are confidential > and > may be privileged. If you are not a named recipient, please notify the > sender immediately and do not disclose the contents to another person, > use > it for any purpose or store or copy the information in any medium. > > - - - > Unsubscribe or switch delivery mode: > <http://support.realsoftware.com/listmanager/> > Search the archives of this list here: > <http://support.realsoftware.com/listarchives/lists.html> - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| Re: RB Database |
| Date: 01.04.04 19:15 (Thu, 1 Apr 2004 10:15:40 -0800) |
| From: Will Leshner |
|
On Apr 1, 2004, at 9:22 AM, <email address removed> wrote: > Im not sure what a databaserecord is?? > A DatabaseRecord is the database access way of inserting new records in a database. The Database class has an Insert method that takes a DatabaseRecord and a table name and inserts the record into the table. So you just have to create a new DatabaseRecord, populate it's columns (it works kind of like a Dictionary, actually) and then pass it to Database.Insert. Check out the Language Reference entries for Database and DatabaseRecord for more information. - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| Re: RB Database |
| Date: 02.04.04 05:37 (Thu, 1 Apr 2004 23:37:58 -0500) |
| From: Amy Barnes |
|
> How does one add records to an rb database? Its easy to add the table and > field items but where and how do I add the records? To start, you have to use the following Dim As statement: Dim rs As Recordset //you can change "rs" to just about anything, but the references all use "rs." The trick with Dim statements is that, like in C++, these have to be listed before any other code, at the top. Another tricky thing is that you have to watch the data types that you are working with... As for actually *getting* the data into the database, there are many ways to do this. I'll just assume that you are going to be using EditField for input and a bevelbutton for Action. In a nutshell, you set up and label your text fields that the user will input data into. Then you put in a button that, when clicked, will mete the data out to the differant "containers," which make up your Recordset that is sent to, and eventually committed to, the database. If an end-user is selecting data from a pre-populated list, such as a list of the countries of the world, then you use a query and a pop-up list linked through data binding to show the data in the list. There is plenty of code available in the Examples folder in the RB program folder. If you want me to help you out with that, hthen email me off-list. Alot of this is determined by what you are doing with the database and the program. > These 2 lines when put into a event for your window make the window the > size of the screen but does'nt center it........its off by a little bit. > How do you move it to make it centered? The only way I know of is to set the Fullscreen property to True. You do this with the Property window. A bit differant - your command measures the window and applies a measurement, whereas the Fullscreen proprty maxes the window. Hope this makes your day :^) AmyE - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| Re: RB Database |
| Date: 02.04.04 05:48 (Thu, 1 Apr 2004 20:48:07 -0800) |
| From: Will Leshner |
|
On Apr 1, 2004, at 8:37 PM, Amy Barnes wrote: > To start, you have to use the following Dim As statement: > Dim rs As Recordset > //you can change "rs" to just about anything, but the references all > use > "rs." > Actually, RecordSets are for getting data *out* of a database. DatabaseRecords are for putting data into a database. > The trick with Dim statements is that, like in C++, these have to be > listed > before any other code, at the top. Another tricky thing is that you > have to > watch the data types that you are working with... > Actually, assuming we are talking about RB 5 and later (was there an earlier version?) you can put Dim statements anywhere in a method as long as it is at the top level. As for C++, you can put variable declarations anywhere in a function, top level or not. - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
| Re: RB Database |
| Date: 02.04.04 06:06 (Fri, 2 Apr 2004 00:06:46 -0500) |
| From: Amy Barnes |
|
Well, I guess that's just about the *last* time I try to do something
without double-checking in the reference books today... I'm having a "blonde day" today. Couldn't even do *anything* right today at work, either (2 years experience. I should know what I'm doing...). Pathetic. > Actually, RecordSets are for getting data *out* of a database. > DatabaseRecords are for putting data into a database. AmyE - - - Unsubscribe or switch delivery mode: <http://support.realsoftware.com/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> |
Links
MBS Filemaker Plugins - Nachhilfe Nickenich