Search results for query: *

I have a customer and inventory table. I have a need to create a result set that includes 1 row for each item in inventory. If there are 3 items in inventory for a item, it should generate 3 rows. CustomersTable Structure custid name CustomersTable Rows cust01 cust01name cust02...

I have a data entry form which has a batch header and a sub form with the batch detail records. This form has been used for years and has a bunch of code behind each textbox in the textbox_afterupdate methods to calculate values on the forms, get default values from the database... The company...

I have a large XML file containing one table and many records/fields in the following format: <?xml version="1.0" standalone="yes"?> <NewDataSet> <Table> <BD_U_FL>L</BD_U_FL> <BD_PK>7117</BD_PK> <BD_B_DOCU>B2005061000003122 </BD_B_DOCU> <BD_SEQ>01</BD_SEQ>...

I have a page that contains an IFrame which I use to display PDF reports that are stored in a database. The process is to obtain the PDF from the database, write it to a file and then set the IFrame source property to display it. The problem is that it works on the initial image but will not...

I have a database with a number of global functions. I need to change one of them but want to make sure that I can test it in all the places using it. How do I search the entire database (other functions, forms...) for all usages of "UpdateHistoryDetail()". TIA Mark

I am looking for a bit of help creating a SQL update statement. The task is to update a first and last activity date in a company table based on bills that are going through a billing cycle. The following code would update the entire company table and is what I used when I created the new...

I am trying to process an SQL 2005 table which has a field defined as varbinary(max). When I just do a "select *" on the source table the field is defined as a type "G" in the temporary cursor. I process this record and try to update this field to an updatable remote view. The remote view I...

I have a user control that acts as a lookup button in that when clicked it presents the user with a list of choices from a database query. The user then selects the row they desire. The easy part is I can set a hidden control or public variable to the key of the record they selected. What I...

I have a situation where I am converting a production MS SQL database from version 1 to version 2. The program I wrote dynamically creates an updateable remote view to the new table. I use SQL pass through to create a cursor of the version_1 table and perform the following (pseudo code)...

I have a need to change the connection information stored in a database containing a bunch of remote views (VFP 7). For example, if doing training I would change the connection to open the "Training" database, if testing I would open the "Testing" database... All databases would be SQL...

This is a question more about the test environment using VS 2008 than ASP.NET but this seemed the best place to ask the question. I know this is something everyone has done in one way or another, but what I am looking for is a better solution than I currently use. Currently I keep the...

I have some shopping cart code which updates a MS Access database using OLEDB as such. I can read the database using the following method, but cannot update anything. Dim strSQL As String = "INSERT INTO BH (BH_BID) VALUES ('xxx')" Dim strDSN As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA...

I have installed SBS Server 2003 Premium which has MS SQL 2005. Using the BCM toolkit for Outlook 2007 I created a new database. The client Outlook 2007 can access the empty database fine. If I add a contact it appears fine. I then used the same utility to backup the database on the old...

I have a need to set up "support @ xyz.com" and have that be delivered to multiple real email addresses. I don't have a test environment but is it as easy as adding an SMTP entry "support @ xyz.com" to each users "E-mail Addresses" tab in AD? Or do I set it up as a distribution group with an...

I keep getting a timeout when adding a field to an existing table which contains less than 1M records. After adding the field and selecting [Save] I get a warning to be expected as follows: 'BILLHDR' table - Saving Definition Changes to tables with large amounts of data could take...

I have a check print program that because it has to switch printer trays is not done using a standard FoxPro FRX report. Instead I use a "Set Device to Print" and issue "@row, column SAY 'ssssssss'" type commands. In VFP 7 I used to be able to send the check signature image using...

I have various controls that I disable when in inquiry mode by setting their associated readonly property or the enabled property. As we know when a control is disabled the font colors dim to a silver. 1 - Is there a way to control the disabled colors. 2 - I remember looking into this long...

I have a button on a Usercontrol placed on many pages. When I am in inquiry mode I want this button visable and not visable when in add or edit mode. Before making the common code a usercontrol I would address the button directly in the code behind as such: btnCompanyDetail.Visable = True |...

I am trying to set default values on the parameters defined in a procedure. Following is the parameters portion of the 'create procedure' I am trying to set up. CREATE PROCEDURE xxx_Insert ( @U_UID char = NEWID, @U_LoginName varchar = '', @U_PassWord varchar = ''...

I need to create a function which will prepare text entered into a textbox to be used in a SQL statement. What I mean is the function will replace a single quote and replace it with two single quotes. I had done this in the past in ASP code and placed it in each form. In ASP.NET I assume...