Problem - how to avoid adding records to a DBGrid?

delphi

    Sponsored Links

    Next

  • 1. Interbase + graphic field + DataSetProvider + TClientDataset => graphic field appears as tsmallint ??
    Hello Is there an easy way to define interbase field as graphic field, so that a TClientDataset behind a datasetprovider will see it as a graphic field? Unless I create persistent fields for the blob field and define the blobtype as ftGraphic it appears as a ftSmallInt. I'm using Interbase 7.1, Delphi 7.1, IBX 7.08 and the datafield is defined as "BLOB SUB_TYPE -1 SEGMENT SIZE 80" Best Regards Janne
  • 2. TDataSetProvider BeforeUpdateRecord and preventing scrollingin agrid
    SimonW wrote: > > Understood, however if the user creates a new record in the DBGrid and > then clicks a different record in the grid, the Post event fires before > the BeforeScroll and hence my ApplyUpdates and BeforeRecordUpdate events > fire first. The validation works correctly, Applied:=False; but the > clientdataset scrolls to the selected record. The DBGrid is then out of > step with the database. I want focus to stay on the new record if my > validation in BeforeRecordUpdate fails. Oops make that BeforeUpdateRecord instead of BeforeRecordUpdate
  • 3. TDataSetProvider BeforeUpdateRecord and preventing scrolling in agrid
    SimonW wrote: > I have a DBGrid, linked through a TClientDataSet to a > TDataSetProvider. When the user creates a new record in the grid, I > use the BeforeUpdateRecord event on the DataSetProvider to call a > stored procedure to perform some validation on the new record. If > the validation fails I present a message to the user, set Applied := > False; and everything appears to behave as it should, however, the > user is able to scroll within the grid. How can I prevent this ? - I > want the user to be forced to correct the newly created record in the > grid before they are allowed to move off of it. Call SetRange and set the range to include only the primary key of the new record. Call SysUtils.Abort in the BeforeScroll event handler when you do not want the user to scroll. -- Bill Todd (TeamB)
  • 4. TDataSetProvider BeforeUpdateRecord and preventing scrolling in a grid
    I have a DBGrid, linked through a TClientDataSet to a TDataSetProvider. When the user creates a new record in the grid, I use the BeforeUpdateRecord event on the DataSetProvider to call a stored procedure to perform some validation on the new record. If the validation fails I present a message to the user, set Applied := False; and everything appears to behave as it should, however, the user is able to scroll within the grid. How can I prevent this ? - I want the user to be forced to correct the newly created record in the grid before they are allowed to move off of it.
  • 5. Problem using TIBEvents and remote database
    Hi, I use TIBEvents to synchronize my application in differents computers into a network when some table updates happens. When my applications and firebird runs in the same computer, everything works ok. But when my application and firebird runs in different computers, the system locks an take a long time to return back. What's happening? Eyder Rios

Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Mon, 07 Jul 2003 02:36:12 GMT


Hi all,


Small problemo... 

I have a DBGrid -> DataSource - IBQuery/IBUpdateSQL and I want users to 
be able to *_change_* a certain number of configuration parameters 
stored in a database.


This is fine and works a treat - *_BUT_* what I don't want them to be 
able to do is add new records to the DBGrid, but when I do DownArrow at 
the bottom, it gives an error message "Cannot insert into database (No 
Insert Query)" - and this is because I deleted the insert SQL generated 
by the IBUpdateSQL because I didn't want any inserts.

Also, when I do Cntrl-Del, it asks me if I want to cancel - I just want 
the app to do nothing if I try and delete also.


How do I allow people to edit the values already in the DBGrid but not 
let them add (or delete) any records.


TIA.

Paul...


-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Re: Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Mon, 07 Jul 2003 04:43:39 GMT


 XXXX@XXXXX.COM  says...

 


Thanks Bill.


Paul...


-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Re: Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Wed, 09 Jul 2003 21:19:16 GMT

 XXXX@XXXXX.COM  says...




Sorry - forgot to mention - using C++ 5 aser sig.

What is eqivalent command in C++?


Paul...



-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Re: Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Thu, 10 Jul 2003 02:43:12 GMT

 XXXX@XXXXX.COM  says...




I did actually look up the help before posting and couldn't c SysUtils - 
what do I need to include in the header?

I tried a basic app - 1 form, 1 button

void __fastcall TForm1::Button1Click(TObject *Sender)
{

  SysUtils::Abort();

}

get compiler message 

[C++ Error] Unit1.cpp(21): E2090 Qualifier 'SysUtils' is not a class or 
namespace name
[C++ Error] Unit1.cpp(21): E2379 Statement missing ;


tried saving and building app - same ting,


Paul...
 

-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

p.s. just lacerated a tendon in left hand, so pls 
excuse typos and tricky abbrevs - TIA.

Similar Threads:

1.How to display a dbgrid only for adding new records

I'm using firebird and interbase express and bcb6
I want to use a dbgrid only for adding new records
I don't want to display old ones when the form is displayed.
Any ideas;;


2.Unwanted Sorting in DbGrid - after record add

I am new here so pardon me if this issue arised before. 
Scenario: using dbgrid to amend the table content. over multi-tier environment. using clientdataset.

Problem: after adding a record in the dbGrid, data is automatically sorted (believe on sorted by the first field in the grid). 

Question: how do I stop the sorting and wish to control myself on the display after record add. 

Appreciate any input. Cheers


3.Record ordering [Was: Problems wilth filtering records and/or GotoNearest]

Using Delphi 2006, MySQL 5 and Corelab DBExpress drivers.

I have been experimenting with my sorting order problem this weekend. The
only way I can get a correct order is to use TSQLQuery together with a
TDataSetProvider, with option RetainServerOrder, and a ClientDataSet.

But as soon as Delphi tries to interfere with the data (one way or the
other), things get messed up.

For example: I need to use GotoNearest. This means I need to set an index on
my ClientDataSet.

As soon as I add an index, as a result Delphi orders on the clientside (is
this assumption correct ?) and this ordering messes up the sortorder.

Right sort order:

B-9999
B-99999
B89999
B99999

Sort order when specifying index:

B89999
B-9999
B99999
B-99999

It looks like the "-" is being ignored. Because that would lead to:

B89999
B9999
B99999
B99999

And that is once again correct.

So what could cause Delphi to ignore (?) the "-" sign ?


4.Problem: master records + repeating detail records using Rave?

I have a tricky problem, but perhaps somebody can point me to a simple
solution.

I have two tables. The first contains a variable number of records,
and the other contains just three. All are created at runtime.

I need to print the first record held in Table A, followed by the 3
records from Table B, then the second record from Table A, and again
the 3 records from Table B, then the third record in Table A, and
again the 3 records in Table B -- until all Table A records have been,
as below:

------------------------------------------
J Brown, Dingle & Partners  20500.00 28 30
------------------------------------------
C Dellow, Frenchay & Sons   21200.50 29 32
A Brown, Allman Brothers    23030.29 41 18
G Arthurs, Powell Company   48010.00 22 13

------------------------------------------
R Bull, Sanglier et fils    21500.20 26 10
------------------------------------------
C Dellow, Frenchay & Sons   21200.50 29 32
A Brown, Allman Brothers    23030.29 41 18
G Arthurs, Powell Company   48010.00 22 13

------------------------------------------
T Woods, Research Group     19250.90 02 09
------------------------------------------
C Dellow, Frenchay & Sons   21200.50 29 32
A Brown, Allman Brothers    23030.29 41 18
G Arthurs, Powell Company   48010.00 22 13

etc.

The above is a trivial programming problem. What makes it tricky is to
accomplish it using Rave Reports. This is part of a larger project for
users who are familiar with the Rave interface.

Thanks in advance.

Bob Yorke

5.dbGrid, with multi-record drag and drop

I am looking for a dbGrid which supports multiple row selection, and
then the ability to drag and drop all selected rows. 

6. Open second form to edit DBGrid record

7. Delphi 2: DBGrid showing records limited to its size

8. display the record number on dbgrid



Return to delphi

 

Who is online

Users browsing this forum: No registered users and 80 guest