Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filling in Combobox Value
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01509298
Message ID:
01509393
Vues:
80
>Ok, so the properties of my combobox are as follows:
>
>Control Source: m.customer (I'm not buffering directly to a table, but APPENDING BLANK etc from the save button of my form)
>
>
Name: CmbCCustomer
>
>Row Source: select * from customers into cursor tmpcustomers order by customer readwrite
>
>Row Source Type: 3 SQL Statement
>
>Style: 2 Dropdown List
>
>
>
>in my CUSTOMERADD form I'm doing the following: (some of which is probably not needed):
>
>
>IF !SEEK(ALLTRIM(thisform.txtCCode.Value),"customers","customer")
> INSERT INTO customers (customer,companyname) VALUES (thisform.txtCCode.Value,thisform.txtCCompanyName.Value)
> INSERT INTO tmpcustomers (customer,companyname) VALUES (thisform.txtCCode.Value,thisform.txtCCompanyName.Value)
>ENDIF
>thisform.Release
>
>
>Maybe just adding into the CUSTOMERS file & then requerying the combo would be better than adding into my cursor for the combo ?
>
>Rob
>
>
Yes, you don't need to add it in the tmpCustomers. I always just use RowSourceType - alias, not the SQL.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform