I have a varchar field coming from SQL Server that once it is clicked on in the grid, the data is replaced with the word memo.
This field is defined as nvarchar(2000)
From a data modeling perspective, what legnth or condition of a field will make it appear as “memo” in a grid?
I am not sure if this was already discussed.
It seems that any hex value in my grid is coming up as the word object.
Is there a way I see the actual values in the grid?
I also need to see the values that are showing up as Memo, since I am not using a memo field
Anything above 255 I believe.
Any varbinary column with be “object” as it is unknown what it contains.
Any varchar column will be “memo”. Any character fields above the 255 limit will be treated as memos.
using the where clause on the grid seems to work very well for me.
This way, it really is irrelevant the size of the table.
Lianja.get("PageName.sectionName").where = "value = 5"; Lianja.get("PageName.sectionName").refresh();
how I can get a record object of the current grid active record?
What I need to do is to allow me to programmatically change the field values of the active record using code
You can update the active record and then refresh that specific record in the grid using oGrid.refreshRecord( recno() )
If the underlying cursor has been dynamically created from a virtual table query you need to specify a primary key and issue the replace statement which will generate the SQL dynamically and execute it.
You can add whatever control you want in the grid.
In this example I create a container with a textbox and a button.
First, create the procedure to create the container and the objects you want.
I did this in the custom library of the page.
proc mycontainer mycontainer = createobject("container") mycontainer.layout = "horizontal" mycontainer.height = 50 mycontainer.addobject("text1","textbox") mycontainer.addobject("btn1","commandbutton") btn1.caption ="Custom Button" return mycontainer
Then I added a new column in the grid by right clicking the header of an existing column and selecting “Insert Column After”
The in the attributes of the new column, I entered mycontainer in the custom control option.
Then you can see the custom container in my grid.
So – if you need to have a tooltip, You just add it.
proc mycontainer mycontainer = createobject("container") mycontainer.layout = "horizontal" mycontainer.height = 50 mycontainer.addobject("text1","textbox") mycontainer.addobject("btn1","commandbutton") btn1.caption ="Custom Button" text1.tooltip ="this is tooltip" return mycontainer
you have some larger field that you want to edit. For those field, use the hyperlink to bring up a dialog box for the edit. This way you have a clean edit, not in a small field, you are using a best practice and properly creating a modern application and you do not lose any functionality.
Have a look at this example.
I concatenated firstname, lastname and address into one field.
If I want to edit that field, I just click on the link and bring up a dialog window.
I accomplish everything I a looking to do in a very intuitive way without trying to re-invent the wheel.
In the linkclick section of my page, I call the dialog window.
//////////////////////////////////////////////////////////////// // Event delegate for 'linkclick' event proc page1_section1_linkclick() Lianja.showdialog("Employee Edit","pgEmployeeEdit",500,500) // This refreshes the grid to show the new values Lianja.get("section1").refresh endproc
If I was building this for web, I would call the showdialog with a parameter and an action.
In the desktop, it is already on the record pointer.
Try to add some custom delegate to your “text1” (methods like valid() or so…).
You create your own textbox class with a valid.
define class mytextbox as textbox proc valid() wait window "valid" endproc enddefine
Then instead of adding textbox, you add mytextbox.
not found the property that return the number of column..
This should work
oGrid = Lianja.GetElementByID("page.section").grid ? oGrid.ColumnCount
If i have filtered grid like this
Lianja.get("section1").grid.filter = "startsWith(customerid, 'A')"
and I use the code below to move from record to record then it does not work.
sec = Lianja.get("section1") grd = sec.grid grd.goto(grd.activerow + 1)
It appears that the row is being moved on the filtered gird but I suspect it is moving between rows that are not visible.When the grid is not filtered it works just fine:
Lianja.get("section1").grid.filter = "" sec = Lianja.get("section1") grd = sec.grid grd.goto(grd.activerow + 1)
oGrid = Lianja.get("page1.section1").grid lnActiveRow = oGrid.activerow + 1 oGrid.activatecell(lnActiveRow, 1)
In the second example you can specify the column.
In the first one the first column is activated.