Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to 'rerun' SQL statement Record Source?
Message
From
05/08/1998 11:34:35
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
05/08/1998 11:31:06
Mandy Mccord
Public Interest Breakthroughs, Inc.
Albany, New York, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00124108
Message ID:
00124112
Views:
30
>Hi all,
>
>I've got a dropdown list whose recordsource is a SQL statement (type 3). It creates a cursor (contact names) which is used for the list. I'm allowing the users to enter another form to add a new contact.
>
>What I need to do is once they've added a new record in my table being used in the SQL statement and return to the main form, is 'rerun' the SQL statement in the recordsource to update the list.
>
>Where/how can I do this??
>
>mtia!
>
>Mandy
Mandy,
After new entry call ...mylist.requery
cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform