Hi. the table is created when the window opens. I do it in the standard manner.
The select is a part of the previous line. From what -very- little I know of sql, the select statement is supposed to deal with variables. However, it doesn't seem to <smile> The data enters the table. I can view it with the browser, but when I do it with variables, nothing happens. Regards. > > From: "Tommy Single" <[EMAIL PROTECTED]> > Date: 2006/08/06 Sun PM 04:47:48 EST > To: "REALbasic NUG" <[email protected]> > Subject: Re: adding a record to a realsql database > > OK, first I think you need to create the table. Also what's with the select > statement? > > Tommy Single > > On 8/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Hi All. > > > > SQL question from the sql greenie here. > > > > I'm trying to add a row of data to a table I've created. The following > > code will do it if i make > > everything static. However, I want to take information from two > > editfields and a dropdown box. > > > > I don't get any error, however, I don't get any table entry. > > > > Any ideas? > > > > Regards > > > > ======================= > > > > dim f as folderitem > > > > f=Volume(1).child("new version trouble ticket").child("security_list") > > > > db= new REALSQLDatabase > > db.DatabaseFile=f > > > > if db.Connect() then > > db.SQLExecute("insert into users (username, password, securitygrp) > > select "_ > > +"(edituser.text, editpassword.text, popupsecuritygrp.text)") > > db.Commit > > else > > MsgBox "User, password, group not added" > > end if > > > > _______________________________________________ > > 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> > > > _______________________________________________ > 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> > _______________________________________________ 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>
