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!
|
|
QueryJumpToTypeAhead
Posted: 14 Dec 06 10:33 AM
|
fiogf49gjkf0d Hi,
In legacy basic I asm used to using 'QueryJumpToTypeAhead' on a TextBox Change Event to dynamically jump to a record in a DataGrid.
Can anybody please tell me how this is done in 6.2.4 VB please ?
Cheers, Mark |
|
|
|
Re: QueryJumpToTypeAhead
Posted: 22 Dec 06 4:12 AM
|
fiogf49gjkf0d Any offers yet ??? I'll send a smiley face and everything....
 |
|
|
|
Re: QueryJumpToTypeAhead
Posted: 18 Jul 07 2:48 PM
|
| Has anyone ever figured this one out? I am also in need of this functionality and can't find a way to mimick it... Thanks! |
|
|
|
Re: QueryJumpToTypeAhead
Posted: 18 Jul 07 4:30 PM
|
Originally posted by Mark Richardson
Any offers yet ??? I'll send a smiley face and everything....
|
|
I already have a large collection of those .....
The ONLY way (even in the unreleased v7.2) AFAIK to do this is to employ "dynamic recordset filtering". You will have to build it from scratch.
OR
Purchase the "Quantum Grid" and install your own custom control... but I'd tend to avoid that approach.
This has been an issue that was discussed back in early 2004 in the partner's NG and occasionally pops up as folks (FINALLY) get rid of legacy junk...
--
rjl |
|
|
|
Re: QueryJumpToTypeAhead
Posted: 19 Jul 07 9:41 AM
|
This might help. I figured out a way to dynamically rebuild the datagrid SQL based on the currently sorted column. Instead of jumping ahead to the row that matches the query, it filters the datagrid. The example below would work on a simple Manage Products form.
option explicit
dim strSQL, strSort
strSQL = "SELECT * FROM PRODUCTS"
strSort = "ORDER BY ACTUALID ASC"
Sub AXFormOpen(Sender)
' Set Default Sort Column
Application.BasicFunctions.GlobalInfoSet "gFilter", "ACTUALID"
QueryChange Sender
End Sub
Sub QueryChange(Sender)
grdMain.SQL = strSQL & " WHERE " & Application.BasicFunctions.GlobalInfoFor("gFilter") & " like '" & edtQuery.Text & "%' " & strSort
grdMain.Refresh
End Sub
Function grdMainColumnSorting(Sender, ByRef Column)
Application.BasicFunctions.GlobalInfoSet "gFilter", Column.FieldName
End Function
|
|
|
|
Re: QueryJumpToTypeAhead
Posted: 19 Jul 07 11:30 AM
|
Firstly, thanks to Bob for his input - haven't had time to reply to his thread yet.
Brett - thanks to you too.
Indeed, I have 'sort of' considered and played with this type of option (which does do a job), but with large datasets it negates the dynamic (as one types into an editbox) side of this whole thing.
Again though, thanks for both your inputs.
Ps if anybody is reading this i have a nice couple or 3 plugins I can share - will probably post on here when I pull my finger out but if anyone interested they are:
SLX Export to MapPoint - Maps pushpins onto map with account name from a Group. Also maps meetings onto MapPoint map - choose day etc etc. (requires MapPoint installed)
'Add Contact to Outlook' Button/script on Contact View - does what it says on the tin
Crystal Report -> PDF -> Outlook with one click of a button - This pumps Record selection criteria to a crystal, creates a pdf & attaches it to email and Outlook Mail Message (with aformentioned attachment) pops to user (v.Quick too!)
Regards,
Mark
|
|
|
|
Re: QueryJumpToTypeAhead
Posted: 20 Jul 07 9:48 AM
|
| Would the datagrid property TypeAhead do what you need? Another thought would be to loop through the records until you find what you are looking for with the GetFieldValue. |
|
|
|
Re: QueryJumpToTypeAhead
Posted: 20 Jul 07 9:55 AM
|
Hi Lawrence,
Thanks for the reply - Are you talking version 6.2 DataGrid (SLX Datagrid) ?
I can't see any references in the DataGrid object for 'TypeAhead' ?? Could you please show / provide an example so I know where abouts to look.
Thanks in advance,
Mark |
|
|
|
Re: QueryJumpToTypeAhead
Posted: 20 Jul 07 10:03 AM
|
| I am currently looking 7.1. There is a boolean TypeAhead property for datagrids in the properties window in the architect. By default it is unchecked. The hint dispayed states "Determines whether typeahead is enabled on the currently sorted column." |
|
|
|
Re: QueryJumpToTypeAhead
Posted: 20 Jul 07 10:15 AM
|
Ahh.. That may explain it - This Q was specifically relating to v6.2.4 (see original post at top!).
Oh well - i'll 'play' with my v7 although the business don't plan to run with it 'til next year but, as they say, forewarned is forearmed !
Thanks Lawrence
Have a good weekend |
|
|
| |
|