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>
