On Oct 04, 2006, at 5:19 PM, Harrie Westphal wrote:
On Oct 4, 2006, at 5:43 PM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
dim db as REALSQLDatabase
dim f as FolderItem
db = new realsqldatabase
f=getfolderitem("security")
db.databasefile=f
if db.connect then
db.sqlexecute ("Insert into users (username,password,priority)
Values "_
+"(editfield1.text+','+editfield2.text+','+popgroup)")
db.commit
end if
Shouldn't the sqlexecute line look like the following to get the
single quotes in there properly along with the contents of the
editfields etc.
db.sqlexecute ("Insert into users (username,password,priority)
Values "_
+"('" + editfield1.text + "','" + editfield2.text + "','" +
popgroup + "')"
It is often easier to build the command in a string so that it can
be viewed in the debugger in those cases where it isn't working.
A VERY good suggestion along with checking DB.error after a
SQLExecute as I'm certain that an error is being ignored
_______________________________________________
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>
