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!
|
|
How Can we get Records in grid From database What we select from picklist?
Posted: 17 Oct 08 1:15 AM
|
Hi,
I am trying to get records in grid what am i select from pick list to get those related records from database to display in grid. For that I wrote code like
Dim SQL
SQL="SELECT ZIPSTART,ZIPEND from sysdba.C_TERRITORYZIPMGMT a inner join sysdba.C_TERRITORYMGMT b on a.C_TERRITORYMGMTID= b.C_TERRITORYMGMTID where state='"&pklStates.Text&"'"
dgZipcodes.SQL =SQL
msgbox SQL
dgZipcodes.Refresh
But it won't Display records Please helpme How can i Get it?
Regards,
Venkat |
|
|
| |
| |
| |
|
Re: How Can we get Records in grid From database What we select from picklist?
Posted: 19 Oct 08 1:02 PM
|
Good point Stephen. There's NO substitute for SalesLogix (Engineer/Dev) training. Sage now has "Anytime" and "blended" learning available thru SageU.com and now one does not have to travel to AZ for good classroom training.
There's "blended" LAN/Web/Mobile training available for BOTH customers and Partners. Once you have taken the course(s) you can then take an Assessment test and receive your certification. Certification opens up access to Sage SalesLogix Tech support, etc.
BTW.. the ONLY way you can receive official certified Dev training is via a SalesLogix trainer. There are no non-Sage individuals certified to deliver certified training in development. Only for Poser User and Admin (I know.. we hold Certified Trainer status  |
|
|
|
Re: How Can we get Records in grid From database What we select from picklist?
Posted: 19 Oct 08 6:07 PM
|
Your MsgBox SQL statement should be showing you that your SQL syntax is incorrect, unless you really have a state equal to "'"&pklStates.Text&"'"
Also, as SLX always logs in as user SYSDBA, there is no need for the SYSDBA schema prefix in your SQL.
Try logging in to SQL Server as user SYSDBA and executing the SQL that is returned by your statement - you will find that
InputBox ,,SQL
is a better statement to use than MsgBox, as it allows you to copy the SQL statement to the clipboard.
Something like this will be closer to what you want:
SQL="SELECT ZIPSTART,ZIPEND from C_TERRITORYZIPMGMT a inner join C_TERRITORYMGMT b on a.C_TERRITORYMGMTID= b.C_TERRITORYMGMTID where state= "'" & pklStates.Text & "'"
Phil
PS the comments above regarding training are spot on, btw. |
|
|
|