NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: osquiabro on January 23, 2013, 07:43:06 AM

Title: Autocomplete??
Post by: osquiabro on January 23, 2013, 07:43:06 AM

i have a problem with autocomplete, the id dont pass to the field that i define to receive a value.

see the atachment, the value of Tip:TipoAplicacionId don't pass to Reg:TipoAplicacionId



[attachment deleted by admin]

Title: Re: Autocomplete??
Post by: Bruce on January 23, 2013, 10:03:57 AM

does the tipo table have a unique key on just the id field
AND
a unique key on just the description field?

Title: Re: Autocomplete??
Post by: osquiabro on January 23, 2013, 01:14:36 PM

all my tables have a primary key, but not key in description.

do you have example with autocomplete??

Title: Re: Autocomplete??
Post by: osquiabro on January 25, 2013, 02:07:47 PM

i try to use this but don't work..

Title: Re: Autocomplete??
Post by: Bruce on January 26, 2013, 01:06:55 AM

for auto-complete to work you need a key on just the description field as well.

From memory I think the Validation example has some examples of auto-complete in it.

cheers
Bruce

Title: Re: Autocomplete??
Post by: osquiabro on January 26, 2013, 05:26:20 AM

with description key work, but with autocomplete feature after insert a record and insert another record, all fields have a value of previous record inserted..

this occurs only if use autocomplete, with lookup setting only work perfect

Title: Re: Autocomplete??
Post by: Bruce on January 27, 2013, 10:15:19 AM

can you post an example please so I can duplicate here.

cheers
Bruce

Title: Re: Autocomplete??
Post by: osquiabro on January 27, 2013, 04:17:07 PM

the database is SQL Server

[attachment deleted by admin]

Title: Re: Autocomplete??
Post by: Bruce on January 28, 2013, 11:22:46 PM

unfortunately I'm not able to run the MsSql example - especially because you didn't include any data. However;

>> all fields have a value of previous record inserted..

by "all fields" do you mean other fields in the same record, or do all the records have that specific column set to that one value?

If multiple records are being set, then tell me more about where you are "seeing" that set. For example is there a browse where that value is duplicated? Or are you using the Enterprise Manager to inspect the contents of the database?

cheers
Bruce

Title: Re: Autocomplete??
Post by: osquiabro on January 30, 2013, 05:14:52 AM

hi bruce i create small app with tps, go to Avaluo change a record, insert new Registro Aplicacion and then insert another to see the problem..

[attachment deleted by admin]

Title: Re: Autocomplete??
Post by: Bruce on January 30, 2013, 09:46:50 PM

what you're seeing is all the "priming" you've set on the priming tab being applied.
For example you have;
Reg:SistemaOperativoId = p_web.GSV('Sis:SistemaOperativoId')

since Sis:SistemaOperativoId was updated by the previous auto-complete, it is now the basis for your next record.

So I guess this might be what you want to do, or maybe you want to consider what you are priming the fields to.

cheers
Bruce

Title: Re: Autocomplete??
Post by: osquiabro on January 31, 2013, 02:10:51 AM

i never imagine look there....

thanks..