PDA

View Full Version : Autocomplete question



Tod Brannen
25-Aug-2005, 11:52 AM
David,
Is it possible to display child record fields in the autocomlete
dropdown. I have tried but can't make it work.
I have two files, Name and Address. Address is the child of Name.
On Last Name look up, I want to display the last name, first name, address,
city, state. But the Address, City and State columns are always blank. I
have the same problem with the VDF selection list. Is there a workaround?

I usually have the name and address in the same record, but this client
already had data and the Address record contains multiple addresses besides
the main address of the Name record. I would like to make this work without
redesigning the data if possible..

Thanks,

Tod Brannen

David Martinko
25-Aug-2005, 12:09 PM
You can display info from any file... If you have your relate setup for 1 to
1 files and autofillstate set to true of the sister_DD.. it should work.
Other than that, you have the ability with the latest autocomplete to fill
the list with your own data.. which means you can fill it with any data you
want.

--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
www.redeemedsoftware.com

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:Owt1ZVZqFHA.3128@dacmail.dataaccess.com...
> David,
> Is it possible to display child record fields in the autocomlete
> dropdown. I have tried but can't make it work.
> I have two files, Name and Address. Address is the child of Name.
> On Last Name look up, I want to display the last name, first name,
> address,
> city, state. But the Address, City and State columns are always blank. I
> have the same problem with the VDF selection list. Is there a workaround?
>
> I usually have the name and address in the same record, but this client
> already had data and the Address record contains multiple addresses
> besides
> the main address of the Name record. I would like to make this work
> without
> redesigning the data if possible..
>
> Thanks,
>
> Tod Brannen
>
>

Tod Brannen
25-Aug-2005, 02:39 PM
David,
Clarify 'if you have your relate setup for 1 to 1 files'. I tried using
the auto_fill_state, but it didn't do anything. I had it in the dbList
object of the SL.
The Address file is related to the Name file by the ID#. Name.ID# is unique
and has a unique index. Address is the child and has Address.ID# which is
unique and has a unique index.. I also have the Address constrained by Name
and Name is set as the ddo server.

I my views with Name fields and Address Fields, if I do NextRecord on the
Name.ID#, it also goes to the next Address Record.
Obviously, whatever is stopping me here, is causing the same problem in
normal VDF selection lists.


Tod Brannen

Erik Zimmerman
25-Aug-2005, 02:46 PM
Tod,

PMJI, but auto_fill_state would most likely be set in the child DD not the
SL object

Erik


"Tod Brannen" <tbrannen@ate.net> wrote in message
news:wYVxvyaqFHA.3112@dacmail.dataaccess.com...
> David,
> Clarify 'if you have your relate setup for 1 to 1 files'. I tried
using
> the auto_fill_state, but it didn't do anything. I had it in the dbList
> object of the SL.
> The Address file is related to the Name file by the ID#. Name.ID# is
unique
> and has a unique index. Address is the child and has Address.ID# which is
> unique and has a unique index.. I also have the Address constrained by
Name
> and Name is set as the ddo server.
>
> I my views with Name fields and Address Fields, if I do NextRecord on the
> Name.ID#, it also goes to the next Address Record.
> Obviously, whatever is stopping me here, is causing the same problem in
> normal VDF selection lists.
>
>
> Tod Brannen
>
>

David Martinko
25-Aug-2005, 03:18 PM
Please see Erik's reply about the Auto_Fill_State in the Visual-Dataflex NG
for your question there.

--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
www.redeemedsoftware.com

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:wYVxvyaqFHA.3112@dacmail.dataaccess.com...
> David,
> Clarify 'if you have your relate setup for 1 to 1 files'. I tried using
> the auto_fill_state, but it didn't do anything. I had it in the dbList
> object of the SL.
> The Address file is related to the Name file by the ID#. Name.ID# is
> unique
> and has a unique index. Address is the child and has Address.ID# which is
> unique and has a unique index.. I also have the Address constrained by
> Name
> and Name is set as the ddo server.
>
> I my views with Name fields and Address Fields, if I do NextRecord on the
> Name.ID#, it also goes to the next Address Record.
> Obviously, whatever is stopping me here, is causing the same problem in
> normal VDF selection lists.
>
>
> Tod Brannen
>
>

Tod Brannen
25-Aug-2005, 04:45 PM
David,
I checked and I already have the Auto_Fill_Sate set to True. Still the
address info comes up blank in the AutoComplete. Take a look at this code
and see if I have an error that I can't see.

Set AutoComplete_Index to 2 // index Last Name
Set Timedelay to 100
Set AutoComplete_Title to "Last Name" "First Name" "Address" "City" "State"
"ID #"
Send Add_Display_Column (Name_DD(Self)) File_Field Name.Last_name_comp 75
Send Add_Display_Column (Name_DD(Self)) File_Field Name.First_name 50
Send Add_Display_Column (Name_DD(Self)) File_Field Address.Address2 50
Send Add_Display_Column (Name_DD(Self)) File_Field Address.City 50
Send Add_Display_Column (Name_DD(Self)) File_Field Address.State 50
Send Add_Display_Column (Name_DD(Self)) File_Field Name.Id# 30
Send Add_Display_Column (Name_DD(Self)) File_Field Name.Recnum 0

Procedure Accepted
string sVal
integer iRecnum
Get Integer_Value of oAux_Value item 6 to iRecnum
Send Find_By_Recnum of Name_DD Name.File_Number iRecnum
End_Procedure // Accepted

Thanks,

Tod Brannen

"David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
news:CY7SSIbqFHA.3952@dacmail.dataaccess.com...
> Please see Erik's reply about the Auto_Fill_State in the Visual-Dataflex
NG
> for your question there.
>
> --
> David Martinko
> Redeemed Software
> 248-535-7495
> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
> www.redeemedsoftware.com
>
> "Tod Brannen" <tbrannen@ate.net> wrote in message
> news:wYVxvyaqFHA.3112@dacmail.dataaccess.com...
> > David,
> > Clarify 'if you have your relate setup for 1 to 1 files'. I tried
using
> > the auto_fill_state, but it didn't do anything. I had it in the dbList
> > object of the SL.
> > The Address file is related to the Name file by the ID#. Name.ID# is
> > unique
> > and has a unique index. Address is the child and has Address.ID# which
is
> > unique and has a unique index.. I also have the Address constrained by
> > Name
> > and Name is set as the ddo server.
> >
> > I my views with Name fields and Address Fields, if I do NextRecord on
the
> > Name.ID#, it also goes to the next Address Record.
> > Obviously, whatever is stopping me here, is causing the same problem in
> > normal VDF selection lists.
> >
> >
> > Tod Brannen
> >
> >
>
>

David Martinko
25-Aug-2005, 04:51 PM
Send Add_Display_Column (Address_DD(Self)) File_Field Address.Address2 50
Send Add_Display_Column (Address_DD(Self)) File_Field Address.City 50
Send Add_Display_Column (Address_DD(Self)) File_Field Address.State 50


--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
www.redeemedsoftware.com

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:jj1uU5bqFHA.3128@dacmail.dataaccess.com...
> David,
> I checked and I already have the Auto_Fill_Sate set to True. Still the
> address info comes up blank in the AutoComplete. Take a look at this code
> and see if I have an error that I can't see.
>
> Set AutoComplete_Index to 2 // index Last Name
> Set Timedelay to 100
> Set AutoComplete_Title to "Last Name" "First Name" "Address" "City"
> "State"
> "ID #"
> Send Add_Display_Column (Name_DD(Self)) File_Field Name.Last_name_comp 75
> Send Add_Display_Column (Name_DD(Self)) File_Field Name.First_name 50
> Send Add_Display_Column (Name_DD(Self)) File_Field Address.Address2 50
> Send Add_Display_Column (Name_DD(Self)) File_Field Address.City 50
> Send Add_Display_Column (Name_DD(Self)) File_Field Address.State 50
> Send Add_Display_Column (Name_DD(Self)) File_Field Name.Id# 30
> Send Add_Display_Column (Name_DD(Self)) File_Field Name.Recnum 0
>
> Procedure Accepted
> string sVal
> integer iRecnum
> Get Integer_Value of oAux_Value item 6 to iRecnum
> Send Find_By_Recnum of Name_DD Name.File_Number iRecnum
> End_Procedure // Accepted
>
> Thanks,
>
> Tod Brannen
>
> "David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
> news:CY7SSIbqFHA.3952@dacmail.dataaccess.com...
>> Please see Erik's reply about the Auto_Fill_State in the Visual-Dataflex
> NG
>> for your question there.
>>
>> --
>> David Martinko
>> Redeemed Software
>> 248-535-7495
>> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
>> www.redeemedsoftware.com
>>
>> "Tod Brannen" <tbrannen@ate.net> wrote in message
>> news:wYVxvyaqFHA.3112@dacmail.dataaccess.com...
>> > David,
>> > Clarify 'if you have your relate setup for 1 to 1 files'. I tried
> using
>> > the auto_fill_state, but it didn't do anything. I had it in the dbList
>> > object of the SL.
>> > The Address file is related to the Name file by the ID#. Name.ID# is
>> > unique
>> > and has a unique index. Address is the child and has Address.ID# which
> is
>> > unique and has a unique index.. I also have the Address constrained by
>> > Name
>> > and Name is set as the ddo server.
>> >
>> > I my views with Name fields and Address Fields, if I do NextRecord on
> the
>> > Name.ID#, it also goes to the next Address Record.
>> > Obviously, whatever is stopping me here, is causing the same problem in
>> > normal VDF selection lists.
>> >
>> >
>> > Tod Brannen
>> >
>> >
>>
>>
>
>

Tod Brannen
25-Aug-2005, 05:04 PM
David,
Sorry, I tried that first. The one I sent was my last attempt and I
didn't change it back.

Tod Brannen

"David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
news:0JMD17bqFHA.1284@dacmail.dataaccess.com...
> Send Add_Display_Column (Address_DD(Self)) File_Field Address.Address2 50
> Send Add_Display_Column (Address_DD(Self)) File_Field Address.City 50
> Send Add_Display_Column (Address_DD(Self)) File_Field Address.State 50
>
>
> --
> David Martinko

David Martinko
25-Aug-2005, 05:20 PM
If you get it to work in your selectionlist... it'll be the same for you
view.

I don't have any files with one-one relates.. so I'm not sure what you're
supposed to do other than what I read others posting here. If you get a view
that can do it.. Then the Autocomplete will just work.



--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
www.redeemedsoftware.com

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:Vzc0$DcqFHA.1284@dacmail.dataaccess.com...
> David,
> Sorry, I tried that first. The one I sent was my last attempt and I
> didn't change it back.
>
> Tod Brannen
>
> "David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
> news:0JMD17bqFHA.1284@dacmail.dataaccess.com...
>> Send Add_Display_Column (Address_DD(Self)) File_Field Address.Address2 50
>> Send Add_Display_Column (Address_DD(Self)) File_Field Address.City 50
>> Send Add_Display_Column (Address_DD(Self)) File_Field Address.State 50
>>
>>
>> --
>> David Martinko
>
>

Tod Brannen
25-Aug-2005, 05:23 PM
David,
I have the latest version and I looked at the pkg file to try to figure
out how to manually fill the list. I was a bit confused (that's me, not
you). I think it is a choice, either manual or using DDs. No mixing, is that
right? If not what would be the syntax for it. (I did look for a doc file
that has the syntax in the zip file)
Like this?
Send Add_Display_Column (Name_DD(Self)) File_Field Name.Last_name 75
Send Add_Display_Column (Name_DD(Self)) File_Field Name.First_name 50
Send Add_Item Of hoList msg_None sCity
Send Add_Item Of hoList msg_None sAddress

Thanks,

Tod Brannen
"David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
news:vWtf$dZqFHA.1284@dacmail.dataaccess.com...
> You can display info from any file... If you have your relate setup for 1
to
> 1 files and autofillstate set to true of the sister_DD.. it should work.
> Other than that, you have the ability with the latest autocomplete to fill
> the list with your own data.. which means you can fill it with any data
you
> want.
>
> --
> David Martinko
> Redeemed Software
> 248-535-7495
> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
> www.redeemedsoftware.com
>
> "Tod Brannen" <tbrannen@ate.net> wrote in message
> news:Owt1ZVZqFHA.3128@dacmail.dataaccess.com...
> > David,
> > Is it possible to display child record fields in the autocomlete
> > dropdown. I have tried but can't make it work.
> > I have two files, Name and Address. Address is the child of Name.
> > On Last Name look up, I want to display the last name, first name,
> > address,
> > city, state. But the Address, City and State columns are always blank. I
> > have the same problem with the VDF selection list. Is there a
workaround?
> >
> > I usually have the name and address in the same record, but this client
> > already had data and the Address record contains multiple addresses
> > besides
> > the main address of the Name record. I would like to make this work
> > without
> > redesigning the data if possible..
> >
> > Thanks,
> >
> > Tod Brannen
> >
> >
>
>

David Martinko
25-Aug-2005, 05:31 PM
Look at the sample.vw provided. You will find an example there which is
probably more helpful.
The sample.vw can be compiled in the Order Entry workspace.

--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
www.redeemedsoftware.com

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:3wYOjOcqFHA.3128@dacmail.dataaccess.com...
> David,
> I have the latest version and I looked at the pkg file to try to figure
> out how to manually fill the list. I was a bit confused (that's me, not
> you). I think it is a choice, either manual or using DDs. No mixing, is
> that
> right? If not what would be the syntax for it. (I did look for a doc file
> that has the syntax in the zip file)
> Like this?
> Send Add_Display_Column (Name_DD(Self)) File_Field Name.Last_name 75
> Send Add_Display_Column (Name_DD(Self)) File_Field Name.First_name 50
> Send Add_Item Of hoList msg_None sCity
> Send Add_Item Of hoList msg_None sAddress
>
> Thanks,
>
> Tod Brannen
> "David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
> news:vWtf$dZqFHA.1284@dacmail.dataaccess.com...
>> You can display info from any file... If you have your relate setup for 1
> to
>> 1 files and autofillstate set to true of the sister_DD.. it should work.
>> Other than that, you have the ability with the latest autocomplete to
>> fill
>> the list with your own data.. which means you can fill it with any data
> you
>> want.
>>
>> --
>> David Martinko
>> Redeemed Software
>> 248-535-7495
>> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
>> www.redeemedsoftware.com
>>
>> "Tod Brannen" <tbrannen@ate.net> wrote in message
>> news:Owt1ZVZqFHA.3128@dacmail.dataaccess.com...
>> > David,
>> > Is it possible to display child record fields in the autocomlete
>> > dropdown. I have tried but can't make it work.
>> > I have two files, Name and Address. Address is the child of Name.
>> > On Last Name look up, I want to display the last name, first name,
>> > address,
>> > city, state. But the Address, City and State columns are always blank.
>> > I
>> > have the same problem with the VDF selection list. Is there a
> workaround?
>> >
>> > I usually have the name and address in the same record, but this client
>> > already had data and the Address record contains multiple addresses
>> > besides
>> > the main address of the Name record. I would like to make this work
>> > without
>> > redesigning the data if possible..
>> >
>> > Thanks,
>> >
>> > Tod Brannen
>> >
>> >
>>
>>
>
>

Tod Brannen
29-Aug-2005, 09:30 AM
David,
I have looked at the sample view. The sample with data from two tables
shows data from a parent table not a child table. It does not seem to work
the other way around. However I did not see any use of the
"manual_fill_list" syntax which you describe in the package file.

Thanks,

Tod Brannen


"David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
news:4cdAFScqFHA.1284@dacmail.dataaccess.com...
> Look at the sample.vw provided. You will find an example there which is
> probably more helpful.
> The sample.vw can be compiled in the Order Entry workspace.
>
> --
> David Martinko
> Redeemed Software
> 248-535-7495
> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
> www.redeemedsoftware.com
>
> "Tod Brannen" <tbrannen@ate.net> wrote in message
> news:3wYOjOcqFHA.3128@dacmail.dataaccess.com...
> > David,
> > I have the latest version and I looked at the pkg file to try to
figure
> > out how to manually fill the list. I was a bit confused (that's me, not
> > you). I think it is a choice, either manual or using DDs. No mixing, is
> > that
> > right? If not what would be the syntax for it. (I did look for a doc
file
> > that has the syntax in the zip file)
> > Like this?
> > Send Add_Display_Column (Name_DD(Self)) File_Field Name.Last_name 75
> > Send Add_Display_Column (Name_DD(Self)) File_Field Name.First_name 50
> > Send Add_Item Of hoList msg_None sCity
> > Send Add_Item Of hoList msg_None sAddress
> >
> > Thanks,
> >
> > Tod Brannen
> > "David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
> > news:vWtf$dZqFHA.1284@dacmail.dataaccess.com...
> >> You can display info from any file... If you have your relate setup for
1
> > to
> >> 1 files and autofillstate set to true of the sister_DD.. it should
work.
> >> Other than that, you have the ability with the latest autocomplete to
> >> fill
> >> the list with your own data.. which means you can fill it with any data
> > you
> >> want.
> >>
> >> --
> >> David Martinko
> >> Redeemed Software
> >> 248-535-7495
> >> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
> >> www.redeemedsoftware.com
> >>
> >> "Tod Brannen" <tbrannen@ate.net> wrote in message
> >> news:Owt1ZVZqFHA.3128@dacmail.dataaccess.com...
> >> > David,
> >> > Is it possible to display child record fields in the autocomlete
> >> > dropdown. I have tried but can't make it work.
> >> > I have two files, Name and Address. Address is the child of Name.
> >> > On Last Name look up, I want to display the last name, first name,
> >> > address,
> >> > city, state. But the Address, City and State columns are always
blank.
> >> > I
> >> > have the same problem with the VDF selection list. Is there a
> > workaround?
> >> >
> >> > I usually have the name and address in the same record, but this
client
> >> > already had data and the Address record contains multiple addresses
> >> > besides
> >> > the main address of the Name record. I would like to make this work
> >> > without
> >> > redesigning the data if possible..
> >> >
> >> > Thanks,
> >> >
> >> > Tod Brannen
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Tod Brannen
29-Aug-2005, 09:39 AM
David,
I found that I was looking at an older sample view. I did have the
latest downloaded, but apparently I have several copies of that view and
pulled the older copy.
I will look at it and if I have problems with it let you know.

Thanks,

Tod Brannen