slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Controls | New Thread

View: Search:

Author

Thread: Datagrid will not display any rows if using a column with numeric values....

Michael Kirkpatrick
Posts: 3

Datagrid will not display any rows if using a column with numeric values.... Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Aug 08 2:33 PM

v7.1...using a standard TDataGrid and all works great until i pull in a column that has a numeric value. then the grid displays NO rows..... Pulling from a SQL View...tried casting the numeric data as varchar...still won't work. If i eliminate the numeric value colum...all rows reappear just fine..??

[Reply][Quote]

Harendra Sinha
Posts: 66

Re: Datagrid will not display any rows if using a column with numeric values.... Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Aug 08 3:09 PM

it happens if the datatype is SQL_VARIANT (not NUMERIC) .. pls again check and change the datatype ...
OR ,
you can use dynamic sql statement for grid e.g

With "DATAGRID_NAME"

.SQL.Text = "SQL_STATEMENT"
With .Columns
'remove any existing columns
If (.Count > 0) Then
For iFieldCtr = 0 To .Count - 1
.Item(0).Delete
Next
End If

'add column
Set col = .Add(0)
col.FieldName =
col.Caption =
col.ReadOnly =
col.Visible =
col.Width =

'add column
Set col = .Add(0)
col.FieldName =
col.Caption =
col.ReadOnly =
col.Width =

.............................
End With

'now refresh the grid to see the new columns
.Refresh
End With

-Harendra

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/29/2024 11:32:07 PM