Okay, fine

I will see how i can help (very less time, my project is a little bit behind schedule). 

Hi Boki,

sorry for the delay, i had a little accident (now i am okay again).

Here the list, but all is defined in DB.pas ...

  TFieldType = (ftUnknown, ftString, ftSmallint, ftInteger, ftWord, // 0..4
    ftBoolean, ftFloat, ftCurrency, ftBCD, ftDate, ftTime, ftDateTime, // 5..11
    ftBytes, ftVarBytes, ftAutoInc, ftBlob, ftMemo, ftGraphic, ftFmtMemo, // 12..18
    ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftFixedChar, ftWideString, // 19..24
    ftLargeint, ftADT, ftArray, ftReference, ftDataSet, ftOraBlob, ftOraClob, // 25..31
    ftVariant, ftInterface, ftIDispatch, ftGuid, ftTimeStamp, ftFMTBcd, // 32..37
    ftFixedWideChar, ftWideMemo, ftOraTimeStamp, ftOraInterval, // 38..41
    ftLongWord, ftShortint, ftByte, ftExtended, ftConnection, ftParams, ftStream, //42..48
    ftTimeStampOffset, ftObject, ftSingle); //49..51​

I think you should check for types like ftByte, ftWord, ftSmallint, ftInteger, ftAutoinc, ftLargeInt,

ftLongWord and ftShortInt and for this fields set decimal places = 0 and right aligned.

Why NULL is not working is another part, TField has an isnull-property, do you use it?

best regards 

Hi,

just playing around with the new v6:

- two dbgrids v5 with the same datasource: you can scroll around in first or second grid, no problems

- one dbgrid v5 the other dbgrid v6, both with the same datasource: you can scroll only in dbgrid v6, trying to scroll in v5 immediately throws an exception

- two dbgrid v6 with the same datasource: trying to scroll, no matter in which grid, immediately throws an exception

by the way (i am using SQL-Server 2014):

if i connect to a table and do not define the columns, the displayed values are different formated:

- in v6 integers has always two digits behind comma, why?

- in v5 float has not digits behind comma when 0, in v6 it has always Digits behind comma (this is better i find)

​- in v5 tinyint with value 0 is shown as 0 leftaligned, in v6 it is shown as 0 but rightaligned (is better)

- in v5 and v6 tinyint with value NULL is shown as empty, smallint and int with value NULL are shown as empty in v5 but as 0.00 in v6

i think

- numeric values should always be right aligned by default

- integer values (from tinyint till up to bigint) should always be shown as xxx, not as xxx.yy

- values which are NULL should always be empty (because this is not the same like 0!)

... but as long as this can be overwritten it's no major problem :-)

Hi,

i tried to make a demo for you, but Demos are mostly working. So i have to study my Project a little deeper. The funny thing is, that every time i change a little bit, the behavior is different. In the moment i see only the first row, all other rows where always empty.

Other situations are often, that grid is completly empty and i get one error message after another and i have to kill the application.

But what i found out: when i have a dbgrid6 connected with a datasorce where the query is active when i press <f9> (= start in Debugging mode), i get immediately "Exception EClassNotFound in Project  test in 00044B46. Class TnxDBNumberColumn6 not found".

Starting the same app and opening the query during runtime works okay.

i'll come back when i have found out a little bit more...

Kind regards!

Yes, you where right - after adding a reportgridview i see headers and have data in the grid when i run the app.

But the Access violation is still here.

And when i open the window with the grid, only the topmost row has data (but my query returns 38 rows), all other rows are empty (filled with Standard value). I have to go down and when i scroll up all values become visible. When i now again scroll down, the new rows scrolling in sight are empty again.

Hi,

i was able to install NextSuite 6.

Then tried to create a new NextDbGrid6, but none of my defined columns are visible during designtime in the grid (no headers) ??

And when i run the application it throws an error in NxDbColumns6.pas in proc TNxDataBinding.SetField() (row 396) where i get an Access Violation. I have done a Debugging and saw, that this proc is called for every column i have defined. Then immediately once again, but now with Value = Nil. Because FField <> Value it tries to set FFieldName := FField.Fieldname - and this causes the Problem...

Maybe you have an idea what's wrong, but now it is not so urgent.

Kind regards

Hello Boki,

this works!  

thank you very much

have found the reason:

in OnCellFormating i do a

...

value := nextGrid.Cells[0, aRow];​

if value < 0 then TextColor := clRed;

...

If i use a random value instead "nextGrid.Cells[0, aRow]" everything works okay.

Now i need only a solution...

Hello,

i try this since yesterday with Delphi 2010.groupproj

Have added "var Themed: boolean = false" where it was necessary....

Now when i do a "compile all" it hangs on NxLayout6Run_d2010.bpl, where it says "NxLayout6Run_d2010.dpk(38): F1026 File not found: 'NxStylePaint6.dcu'

... but the file is there,i have checked this...

And when i do a "generate all" it stops in file NxLayout6.pas, saying "NxLayout6.pas(23): F1026 File not found: 'NxConsts6.dcu'

... but this file is also here ...

Can't make it going and i need a solution for my problem with this "OnCellFormating"-Bug (see my message in NextSuite v5 / NextDbGrid - Forum)

very urgently - please help!

thanks a lot

Hi Boki,

when OnCellFormating is used, working with the grid becomes impossible because cell coloring goes completely wrong (see example.png)

Attached is a little example with source (using VirtualTable component from Devart). Done with Delphi XE and NextDbGrid 5.9.60

Tried to use NextSuite v6 but there is no version for Delphi XE ...

best regards

Hi Boki,

will there be a version for XE?

thanks