DBGRID not allowing me any access during runtime.
lazarus / 16-Databases

----------------------------------------------------------------------
tonykaralis · 2015-02-27 20:38

Hi All,
I am new to this forum and am in my second year of a bsc in computing.
I am using lazarus on windows 8 64 bit(i have installed the 32bit
lazarus though) i also have microsoft access 2013 that im using to
create my database. have used an ODBC connection, with a
sqltransaction,sqlquery, datasource and dbgrid.
I have managed to connect the database to my application by creating a
dsn file and saving it in the projects folder. During design time I am
able to see the data in the DBGrid(live data). before running my
application I make sure i set the connection property of the ODBC
connecter to false and the datasource as well. The program runs and I
can see the data in the dbgrid as expected. However, I cannot edit the
data in the grid(I cant delete a letter/s or change a number or
anything) the cursor allows me to run through the data but cant change
anything.
I cannot figure out why it wont allow me to do anything.
Even when adding a DBnavigator, none of the buttons where activated
after selecting a datasource.

Please can someone help. I have to submit an assignment and am running
out of time.

Thank you

----------------------------------------------------------------------
BitBangerUSA · 2015-02-27 21:38

since you didn't speak of it... is the Dbf ReadOnly property set to
True?
may be off the mark - i haven't used ODBC in a long time.
you might want to post some sample code.

what about the DBGrid ReadOnly property? False or True?