--- Bill <[EMAIL PROTECTED]> wrote: > > Using the database query builder you can make a > query that you select in the > property of the field - you can say what column and > you can choose "update > after editing" etc. I would like to get those > properties like this: > > On mouseup > Get database properties of fld "foo" > End mouseup > > I would also like to be able to set them with a > transcript command > > On mouseup > Set query of fld "foo" to connect > Set database column selected of fld "foo" to > "first_name" > Set "update after editing" of fld "foo" to true > End mouseup >
Hi Bill, There are two types of information : in the query itself and in the controls linked to a query. For more information on query properties see this post: <http://lists.runrev.com/pipermail/use-revolution/2003-December/026932.html> Here's a quick (incomplete) list of the information stored inside the individual linked controls : - the cREVGeneral["database"] property is true if a control is linked to a database - the cREVDatabase["queryobject"] property contains the name of the query it is linked to - the cREVDatabase["linkcolumn"] property contains the column(s) of the query it is linked to - the cREVDatabase["updateafterediting"] property is true if the database needs updated after editing - the cREVDatabase["saveoptions"] property determines what data will be saved to the database and how the data coming from the database is interpreted ; but its contents vary with the control type so let me know if you need more info on these. Hope this helped, Jan Schenkel. ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
