Re: RB Database (Real Studio getting started Mailinglist archive)

Back to the thread list
Previous thread: Displaying a image with alpha-channel properly
Next thread: Database List?


Windows???   -   tom.russell transport.alstom.com
  Re: RB Database   -   tom.russell transport.alstom.com
   Re: RB Database   -   tom.russell transport.alstom.com
    RB Database   -   tom.russell transport.alstom.com
     Feature request: Add "built demo" functionality to RealBasic built dialog   -   Markus Winter
    Re: RB Database   -   Will Leshner
    Re: RB Database   -   Terry Findlay
    Database List?   -   Terry Findlay
    Re: RB Database   -   Will Leshner
    Re: RB Database   -   Amy Barnes
    Re: RB Database   -   Will Leshner
    Re: RB Database   -   Amy Barnes

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.height=screen(0).Height
window1.width=screen(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=screen(0).Height
> window1.width=screen(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>