Re: re; adding data to a real sql database

[Harrie Westphal]

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 Mac addict in Tennessee ===

_______________________________________________
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>