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...
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...
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()...
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...
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
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).
???
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...
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...
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
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...
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')...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.