You cannot reference the lineeditfields directly. You must first write code
to get the value within the field and then create the SQL statement with
those values. The values can be assigned to a variable or incorporate the
code within the SQL statement. I prefer the first approach.
Something like below will assign the value of a combobox to the variable
filtervalue:
#cbograde is a combo box outside on the grid object
filtervalue=hk_thisform.get_pyvisible("cbograde").value()
On Sunday 06 January 2008 19:53:41 Robert Wood wrote:
> Hi all,
>
> I am having my first go at databases, have been playing with Knoda for a
> few days now and not got very far, although am learning a lot about how
> databases work in general.
>
> I want to have a form and write data from a form to table; I have set up
> a very basic test table called People which has three fields: ID, which
> is auto increment, Name which is text and Telephone which is text. (All
> very Mickey Mouse for the moment.) I have then made a little form with
> two lineeditfields and one button. The lineeditfields are called
> NameInputField and TelephoneInputField.
>
> I clicked on the button I placed on the form, and clicked on "On Click"
> which opened up the little edit box and - with some help from my brother
> who's done lots of SQL - I put the following:
>
> INSERT INTO People (Name,Telephone) VALUES (NameInputField,
> TelephoneInputField)
>
> Now, I have seen a reference to SQL in the help files saying you have to
> use double quotation marks, so I tried this:
>
> INSERT INTO "People" ("Name","Telephone") VALUES ("NameInputField",
> "TelephoneInputField")
>
> I also tried single quotation marks, and only put the quotation marks as
> so: ("Name,Telephone").
>
> In all instances I get this error:
>
> Line 1: Invalid Syntax (<string>, line 1) and it opens up the edit box
> with the SQL in it...
>
> It's flummoxed my brother as well (who is in a different country and
> trying to debug via Yahoo), so we must be missing some fundamental point
> here. I'd be very grateful for a point in the right direction/
>
> Cheers,
>
> Rob.
>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Hk-classes-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
