I found a sample of what I hoped to be a way to deal with data-aware
controls, called IBdemo-20050328. However, it was incomplete. I was
able to get it to compile, and display stuff in the data grid, but the
update, modify, and delete functions were not implemented -- which is
basically what I was looking for.
For anybody who hasn't even gotten that far, here is what I did to get
it to build and run on my system:
1) In IBConnection1, the database name is the complete pathname of the
database file, and the hostname is 127.0.0.1
2) The UserName is SYSDBA, and the password is whatever you assigned
(the default out of the box is "masterkey", and should be changed
first thing after you install Firebird)
3) In SQLTransaction1, make sure the Database property is set to IBConnection1.
4) In SQLQuery1, make sure the Database property is set to IBConnection1.
5) In Datasource1, make sure the Dataset property is set to SQLQuery1
6) In Edit1, use the same string you used for the database name in the
IBConnection1.
At that point, you can set everything to Connected or Active, and see
the table in the grid at design time. You want to set Active to false
in SQLQuery1 before you run the demo. Otherwise, it behaves strangely.
Is there ANYBODY who has a COMPLETE example of a database application
with a datagrid that can display, modify, add, and delete rows in a
simple table? Specifically, is there some format for the sql that will
allow me to use data-aware components with minimal coding, or do I
have to dynamically update an sql statement and put it into the
deletesql, insertsql, or updatesql property of the SQLQuery1 component
(if the latter, I'm kinda wondering what advantage there is to using a
data-aware component)?
--
The Celtic Fiddler
www.celtic-fiddler.com
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
