4/25/2024 5:29:43 PM
slxdeveloper.com
Now Live!
|
|
| |
|
User Profile -
Kirrubananthan
|
|
|
Kirrubananthan
Solutions- Middle East
fjrigjwwe9r1SiteUser:UserBio fiogf49gjkf0d I'm a Software Engineer in Solutions Middle East, Born in Sri Lanka, and just joined the company few weeks back and Now learning to configuring Web in Sales Logix....
I'm a .net developer from last year, and I'm so interested on the getting aware of development in the Programming languages, new features, and 3rd party tools available in the internet.
|
|
| Log in to send this member a
message! |
|
|
| Kirrubananthan's
Contributions |
|
Kirrubananthan
has contributed
comments and
0
articles.
|
| |
| Select to view:
|
Comment: Dynamically Creating DataGrid Columns
fiogf49gjkf0d Hi Ryan,
I'm using SLX 7.0 and I have created a custom table that stores all the customer transactions and depending on the client it will list down the transactions in a datagrid. I did it without coding in Architect in a simple way, which is working fine and get few minutes to load when there are 1000 records.. but need to know how to do paging if I need to restrict the datagrid to show only 20 rows at time and next button and previous button handle the rest to navigate the information.
SELECT A1.WS_TRANSACTIONID, A1.CRTRNPCD, A1.CRTRNSPC, A1.CRTRNRNO, A1.CRTRNBKD, A1.CRTRNDOT, A1.CRTRNTOT, A1.CRTRNPCAM, A1.CRTRNCCRG, A1.CRTRNRAM, A1.CRTRNTCAM, A1.CRTRNCERT, A1.CRTRNTRNS, A1.CRTRNBNM, A1.CRTRNTTYP FROM WS_TRANSACTION A1 WHERE A1.CONTACTID = :BindID
this is the SQL generated by the SLX, but can I add one more condition to the A1.WS_TRANSACTIONID and pass the value to the SQL query.. to make ease the coding work without altering the current context..
Hope you can help on this to me!!!!
Author: Kirrubananthan - 2/10/2008
|
|
|
|
|
|
|
|