Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wlhbill

    Record not found after insert, VFP8

    Hi, I have an app. that inserts and updates records in a vfp8 database. The database has 2 tables, a header and a detail. Since adding a record involves inserting a single header and multiple details I start with a BEGIN TRANSACTION, insert the header record, loop through the details and insert...
  2. wlhbill

    Dropdownlist doesn't display selected value

    Yeaaa! That was it!! The onInit method of the StateCode control was populating the list and did a databind. This was good and where it was supposed to happen. I also had a databind in the onload event. Suspenders and a belt, right. Unfortunatlly the onload event of the control was fired after...
  3. wlhbill

    Dropdownlist doesn't display selected value

    Stepping through in debug mode the first thing that happens is InitializeComponent(); (this assigns event handlers to the various controls) base.OnInit(e); (does default stuff I think) private void FormInit() { if (Session["CurrentUser"]!=null) { sID=Session["CurrentUser"].ToString()...
  4. wlhbill

    Dropdownlist doesn't display selected value

    The statecode object is declared with: protected HssWebControls.StateCode cboStateCode; The StateCode class is defined in a separate dll HssWebControls with connection and binding to the database. The cboStateCode control works fine with the exception of initially displaying the right entry...
  5. wlhbill

    Dropdownlist doesn't display selected value

    The cboStateCode object is a separately defined web object. The databind occurs when the object is created. The list contains all the items, it just displays the first item instead of the selected one. I can include the code defining the cboStateCode object if you would like. Thanks, Bill
  6. wlhbill

    Dropdownlist doesn't display selected value

    Thanks for the reply Veep, That certainly seems to be a much easier way to do it but unfortunatlly the results are the same. I just tried it and it still displays the first item in the list (Alabama) instead of 'st' (Florida). ???
  7. wlhbill

    Dropdownlist doesn't display selected value

    I have a page with user information, name, address, city, state, zip, etc. The state field is a dropdownlist populated with statecode and statename. When the page is initially linked to it accesses a database to retrieve a previously determined record and populates the fields on the page. It...
  8. wlhbill

    how to get data from another frame

    I have a frameset page with 2 frames. The first frame has a textbox and 2 buttons. The user enters a string in the textbox and clicks the first button. This calls a code behind C# function to generate a javascript to connect the second frame to a website. This work fine. What I want to do is...
  9. wlhbill

    Updateable cursor from SQL Passthrough

    Mike, You get the gold star. Adding this made the cursor updateable without a local database: CURSORSETPROP("UpdateNameList","cat types.cat, type types.type, descr types.descr, data types.data",'t1') KUDOS and thanks, Bill
  10. wlhbill

    Updateable cursor from SQL Passthrough

    Mike, Thanks for the quick reply. I was afraid that's what the answer was. Unfortunatly I have other reasons for not wanting to create even a temporary database in this application so it looks like I will have to do it the hard way with logic and explicit updates. Thanks again for the timely...
  11. wlhbill

    Updateable cursor from SQL Passthrough

    I am trying to create an updateable local cursor to SQL Server using this: ol=SQLCONNECT('RDB') && RDB is an ODBC datasource SQLEXEC(ol,"select cat,type,descr,data from types",'t1') CURSORSETPROP("Tables",'types','T1') CURSORSETPROP("UpdatableFieldList",'cat,type,descr,data','T1')...
  12. wlhbill

    Printer Queue report Information

    There may be simpler methods but one that comes to mind that I have used is build a table with all the fields required for all three reports plus a reportid field. Then build the report format with overlapping fields using the 'print when reportid=1' or 2 or 3. Reportid can also be a major page...
  13. wlhbill

    Editbox and set focus

    Thanks Darrell, That's the 'deceptively easy way' I was overlooking! Bill
  14. wlhbill

    Editbox and set focus

    I am using an editbox to display customer service notes from a memo field. I want to be able to set the focus to the end of the existing text so the CSA can type in more notes without having to first position the cursor to the end of existing notes. I hope i'm overlooking a deceptively easy way...
  15. wlhbill

    Losing connection to sql server thru VPN tunnel

    The connection is RoadRunner cable to RoadRunner cable with static ip on both ends.
  16. wlhbill

    Losing connection to sql server thru VPN tunnel

    I have an application that is randomly losing an ODBC connection to a SQL Server database when accessing the database through a VPN tunnel. The tunnel is established with two Linksys BEFVP41 routers. The tunnel does not seem to lose connection. If I establish a terminal sevices session to the...
  17. wlhbill

    VPN routing across subnets

    I have a WIN2000 subnet of 192.168.1.0 with a number of workstations and a couple of servers. A BEFSR41 router serving as a gateway to the internet with a static IP. It also is the DHCP server for the 1.0 network. One of the servers has a second nic connecting to a BEFVP41 VPN router with a...
  18. wlhbill

    Enter data in web browser

    John, Thank you for the help. Your second post was the key I needed. The application now works with a single button click which was my goal. I modified the DocumentComplete event as follows: *** ActiveX Control Event *** LPARAMETERS pdisp, url LOCAL oShell IF thisform.lPass...
  19. wlhbill

    Enter data in web browser

    At this point I'm willing to try anything that will make it work. Thanks for your reply. I will post the results. Bill
  20. wlhbill

    Enter data in web browser

    I have created a form using the _webform object from the _webview.vcx library. I can navigate to the web site (http://www.usps.com/shipping/trackandconfirm.htm/)without problem. My problem is how to get my usps tracking number onto the form programatically. I've tried the keyboard() function to...

Part and Inventory Search

Back
Top