Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box to scroll thru a database
Message
From
24/03/2010 08:56:13
 
 
To
23/03/2010 08:28:10
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01456119
Message ID:
01456897
Views:
36
>(Assuming your table's name is myTable, primary key field name is pkField and index tag name is myPkTag)
>
>
select fieldA,fieldB, ..., pkField from myTable where intemtype="x" into cursor test
>
>InteractiveChange or Valid:
>
>
=seek(test.pkField, 'myTable', 'myPkTag')
>thisform.refresh()
Is there another way to do this?because i made a new form added 1 combo box and 1 field
i populate my combo with my SQL and on valid /inint change i hav
=seek(test.private,'test','prvate')
thisform.refresh()
the text box has a control source of the field from the table also i set bound to to true.
even if i change the combo value..the text box doesnt change :(


the SQL 2 populate my combo should be in the form init as well?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform