9/13/2025 6:27:57 PM
|
| |
| 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!
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
|
|
|
|
Datagrid will not display any rows if using a column with numeric values....
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..?? |
|
|
|
Re: Datagrid will not display any rows if using a column with numeric values....
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 |
|
|
|
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!
|
|
|
|
|
|
|
|