Xojo Conferences
XDCMay2019MiamiUSA

DataControl Insert doesn't work (Real Studio getting started Mailinglist archive)

Back to the thread list
Previous thread: Click-thru window Win32
Next thread: A new year


RB Database   -   tom.russell transport.alstom.com
  DataControl Insert doesn't work   -   Barry Bickmore
   Re: DataControl Insert doesn't work   -   mrebar darkwing

DataControl Insert doesn't work
Date: 01.01.07 11:11 (Mon, 1 Jan 2007 03:11:03 -0700)
From: Barry Bickmore
Hi everyone,

I am trying to do a simple little database editor within an app (Mac
OSX), and the User's Manual for RB 2006 has an example that is just
what I need. It says you can use a DataControl to navigate around the
database, and you can bind the DataControl to editfields that pull up
the values in the db columns. You can also bind the DataControl to
buttons that will clear the editfields so you can make a new record,
insert the contents of the editfields into a new record, update an
existing record, and delete an existing record. Everything works fine,
except that the Insert button doesn't actually insert anything. It
does clear the editfields like it is supposed to, but there is no new
record in the database. I do have the "Commit" checkbox checked in the
DataControl properties.

Any ideas on what to do? I only program out of necessity, so I don't
relish the idea of programming the whole thing.

Barry Bickmore
Assistant Professor of Geological Sciences
Brigham Young University
Provo, UT 84602-4606
(801) 422-4680

"You're turning me into a criminal, when all I want to be is a petty
thug."
-Bart Simpson

"I'm no hero--I just like to hit people on the head."
-Nelson Munce

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: DataControl Insert doesn't work
Date: 01.01.07 21:27 (Mon, 01 Jan 2007 12:27:32 -0800)
From: mrebar darkwing


On 1/1/07 2:11 AM, "Barry Bickmore" <<email address removed>> wrote:

> Hi everyone,
>
> I am trying to do a simple little database editor within an app (Mac
> OSX), and the User's Manual for RB 2006 has an example that is just
> what I need.
<snick>
> Everything works fine,
> except that the Insert button doesn't actually insert anything. It
> does clear the editfields like it is supposed to, but there is no new
> record in the database. I do have the "Commit" checkbox checked in the
> DataControl properties.
>
> Any ideas on what to do? I only program out of necessity, so I don't
> relish the idea of programming the whole thing.
>
> Barry Bickmore

I believe you need to run your query again. The insertion likely succeeded,
but the new record wasn't part of the original selection.

Michael

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>