On Oct 06, 2006, at 4:33 AM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
Hi Guys.
Ok, I am beginning to think I am REALLY dense.
I can't get the data to enter... even if I copy and paste what you
have entered here. So the question still remains, what in the name
of the Incarnations am I doing wrong?
I know the command I am using is fine... I string 3 or 4 insert
commands together, and when I query the database, there it is.
When I read the LanguageReference, I appear to be doing everything
correctly.
I have:
editfield1, editfield2, a popup menu (known in code as popgroup).
My database is known as dbsecurity. (had to change the name from my
last posting due to ... other... issues that I thought might be my
problem...) I'm using Realbasic 2006 release 4.
When I add Mr. Pieterciel's version, with a copy and paste, the
compiler gives me a syntax error, but I appear to have all of the
single and double quotes where they are supposed to be. I didn't
miss anything as far as I can tell.
The syntax error is becuase uyou have to take a value from the popup
(popup.text or something) and not popupgroup
aQuery = "Insert into users(username,password,priority)Values('" +
editfield1.text +"','"+editfield2.text + "','"+popgroup.text"')
_______________________________________________
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>
