#VFP AutoComplete Sample

Select ;
CAST(‘MyCountries’ As c(20)) As ‘Source’,;
CAST(country As c(254)) As ‘Data’,;
CAST(1 As Int) As ‘Count’,;
CAST(0 As Int) As ‘Weight’,;
DATETIME()-60 As ‘Created’,;
DATETIME() As ‘Updated’,;
CAST(” As m) As ‘User’ ;
FROM (_samples+’data\country’) ;
INTO Table myAutoCompTable
USE IN ‘myAutoCompTable’

Public oForm
oForm = Createobject(‘AutoCompleteSample’)
oForm.Show

Define Class AutoCompleteSample As Form
Add Object txtCountry As TextBox With ;
top=10, Left=10,;
AutoComplete = 1,;
AutoCompTable = ‘myAutoCompTable’,;
AutoCompSOurce = ‘MyCountries’
Enddefine

DELETE FILE “myAutoCompTable.dbf”

Advertisements

2 thoughts on “#VFP AutoComplete Sample

  1. CAST(” As m) As ‘User’ ;

    What about this code line??

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s