Solved

DBGrid Editing

Posted on 2001-09-12
8
365 Views
Last Modified: 2010-04-06
I hope to enter a value for particular field in a DBGrid, the problem is i can't enter(or edit) it when i run the program
i have set the properties dgEditing = True (in Options)
, but i still failed. Anyidea ??
0
Comment
Question by:chongkeng_woon
  • 4
  • 3
8 Comments
 
LVL 9

Expert Comment

by:ITugay
ID: 6476299
Hi chongkeng_woon,

if DBGrid connected to TQuery then set query's property RequstLive = true. In case you using TTable be sure that table's property ReadOnly = False;

-----
Igor.
0
 
LVL 3

Expert Comment

by:VSF
ID: 6476339
Or u may try using a stringgrid!

VSF
www.victory.hpg.com.br
0
 

Author Comment

by:chongkeng_woon
ID: 6476371
Nope, it doesn't work. I set the
DBGrid connected to a DataSource1, while DataSource1 is connected(dataset) to a query, a query is connected to a database, i put RequestLive=True, but, no luck
0
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 
LVL 9

Accepted Solution

by:
ITugay earned 70 total points
ID: 6476378
Hi chongkeng_woon,

check TQuery.RequestLive in runtime. There may be readonly resultset returned by TQuery (e.g. multiply tables join).

----
Igor.
0
 

Author Comment

by:chongkeng_woon
ID: 6476610
in runtime, requestlive is true, but tquery.canmodify is false, i think that why i got it readonly, but how to make the data editable when tquery.canmodify is false ????

0
 
LVL 9

Expert Comment

by:ITugay
ID: 6478895
Hi,

can you show me your SQL statement?

----
Igor.
0
 

Author Comment

by:chongkeng_woon
ID: 6484187
Igor:
sql.add('select p.* from print p');
sql.add('join printtext pt');
sql.add('on p.number=pt.number');
sql.add('and p.prefix=pt.prefix');
sql.add('where pt.id = :id');
sql.add('and pt.personid = :personid');
thanks
0
 
LVL 9

Expert Comment

by:ITugay
ID: 6487012
Ok, I see. I was right, it's multiply table join and can't be edited directly.

Take a look at Delphi help:
<<
All multi-table queries return read-only result sets. Other conditions may cause a query to return a read-only result set. For local tables (such as dBASE and Paradox), see the local SQL help file for rules governing live result sets (updatable queries). For other table types (such as InterBase, Oracle, and Sybase), consult the documentation for the specific database system.
>>

Use TUpdateSQL to solve your problem.

Regards,
Igor.

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question