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!
|
|
Why datagrid readonly...
Posted: 27 Feb 08 11:54 AM
|
I've looked everywhere....
I've created a simple datagrid from one of the examples on this site & can't figure out why it is read only.
What makes a grid updateable vs. readonly?
Thanks.
Sub TButton2Click(Sender)
Dim col
Dim i
With dgWireles
.SQL.Text = "SELECT ACCOUNT, TYPE, MAINPHONE, ACCOUNTID FROM ACCOUNT"
With .Columns
'remove any existing columns
If (.Count > 0) Then
For i = 0 To .Count - 1
.Item(0).Delete
Next
End If
'add column for ACCOUNT field
Set col = .Add(0)
col.FieldName = "account"
col.Caption = "Account"
col.ReadOnly = True
'add column for MAINPHONE field
Set col = .Add(0)
col.FieldName = "mainphone"
col.Caption = "Phone"
col.ReadOnly = True
'add column for ACCOUNTID field
Set col = .Add(0)
col.FieldName = "accountid"
col.Caption = "accountid"
col.Visible = False
End With
'now refresh the grid to see the new columns
.Refresh
End With
End Sub
 |
|
|
|
Re: Why datagrid readonly...
Posted: 27 Feb 08 5:09 PM
|
I'd say it has a lot to do with the .col.ReadOnly = true you have on each of the cols 
Are you really sure you need to go down this route anyway (dymanic grid) - can you not just include the grid with the columns data bound etc. ? |
|
|
|
Re: Why datagrid readonly...
Posted: 27 Feb 08 10:18 PM
|
You might also see if for some reason the use vssc property is enabled - if so datagrids become readonly.
I have to assume this is just a test and you're not really planning on using the aforementioned grid, correct? If you plan to use this, there are much better and easier ways to create this grid. |
|
|
| |
|
Re: Why datagrid readonly...
Posted: 29 Feb 08 12:03 AM
|
use vssc is a property of the datagrid that can be set in design time, just click on the grid, scroll through the properties, and uncheck use vssc - of course that's if it is checked, if it is not we'll have to look at something else going on.
vssc is "Virtual Server Side Cursors"
basically, it pulls the data client side so that the result set's performance is increased. |
|
|
| |
|
Re: Why datagrid readonly...
Posted: 02 Mar 08 1:06 PM
|
A - You have to be at least 6.2.4 (executables)
B - The controls ocx may not have installed/registered correctly...
--
RJLedger - rjlSystems. |
|
|
| |
|
Re: Why datagrid readonly...
Posted: 02 Mar 08 6:13 PM
|
Originally posted by Glenn Williams
Ok, so i've got 6.2.2. I guess I'm out of luck.... |
|
On top of that.. your SP level is not MS TimeZone "compatable"... and you just may have problems this spring when the clocks jump ahead and your SalesLogix does not.
You need to get to 6.2.6 or go to 7.2.x (SP2 is in RC... should be GA in a week or two)
--
RJLedger - rjlSystems |
|
|
|
Why datagrid readonly...
Posted: 03 Mar 08 1:38 AM
|
AS for my Knowledge,I would like to tell you Once u check it DataGrid properties In Architect In that U select Edit View Options In that Select ADD,Edit,Delete AND Edit Propetry U must Select U want Which Databse.
Supposer I create Datagrid And alsoi I create One saparate form That is Manage or Accountform Related to Datagrid Coloumn Names And Come back to the datagrid Properties Inthd Edit Property Select U create Account or manage Form Then after u have to select Edit Options
I hope It Solves u r problam
With regards
Babu |
|
|
|
Re: Why datagrid readonly...
Posted: 03 Mar 08 9:28 AM
|
Originally posted by Mike Spragg
I'd say it has a lot to do with the .col.ReadOnly = true you have on each of the cols
Are you really sure you need to go down this route anyway (dymanic grid) - can you not just include the grid with the columns data bound etc. ? |
|
I should reiterate this comment from Mike Spragg, though. You DO have col.readonly = true in your example code. Did you remove that or set it to false? |
|
|
|
Re: Why datagrid readonly...
Posted: 05 Mar 08 7:57 PM
|
Check the ReadOnly property of the datagrid itself......
RowSelect unchecked??
Do you have a Keyfield property filled in?
Sortable = True??
Select statement should be
.SQL.Text = "SELECT A1.ACCOUNTID, A1.ACCOUNT, A1.TYPE, A1.MAINPHONE FROM ACCOUNT A1"
I don't see a WHERE statement....are you certain you want 100,000 Account Records in a Grid???
|
|
|
|