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. hammertounge

    XML Post from/to interdev project

    Thanks for the replies. It is fairly obvious that my question was nowhere detailed enough to receive an adequate response. I have solved the problem though. Pete - my problem was passing a bunch of data in hidden text boxes to an asp page and then loading that data into an XDS schema to...
  2. hammertounge

    XML Post from/to interdev project

    I am having a problem with visual interdev and xml. I create a page that does an XML post and receives a response that I display in an IFrame. Here is the problem. When I ask for the page that posts in the project I get the Page Cannot be Displayed message in the IFrame. If I open instance...
  3. hammertounge

    XML Post for XML schema

    Does anyone know of the location of any good examples of and xml post using an xml schema? Thanks in advance:)
  4. hammertounge

    Transaction Log File Location

    Is it possible to store the transaction log files on another server other than the server that SQL 2000 is on? In the database wizard I cannot see the entire network, just the SQL server.
  5. hammertounge

    SQL Server Conversion Date Criteria Help needed.

    You could use the left function like Left(date, 11) to cut the time off and only be left with the date part. You may have to do the same with the database field. select ... where left(databasecolumnname,11) = listbox value
  6. hammertounge

    Run Query From Button Click Event

    How do I ru a query from a buttons click event. I have a database with a primary key I must increment manually. I select max(key) from table to get the highest or latest key and then I want ot add one to it and put it in the form tstbox.value but I am lost as to how to run the query from the...
  7. hammertounge

    Fax services

    I am trying to install a fax service on the server that I can access through ASP. I found some code on MSDN but it does not seem to work. Does anyone know of any source code for developing a dll in VB6 and installing it as a com object on the server? Thanks in advance.
  8. hammertounge

    subqueries do not work for muliple updates

    I have tried the following code and it seems to only sork for one record. update table_1 set table_1.value1 = table_2.value2 where table_1.ID_1 = table_2.ID_2 update table_1 set table_1.value1 = table_2.value2 where table_1.ID_1 in (select ID_2 from table_2) The queries above do not seem to...
  9. hammertounge

    update with subqueries

    I have tried the following code and it seems to only sork for one record. update table_1 set table_1.value1 = table_2.value2 where table_1.ID_1 = table_2.ID_2 update table_1 set table_1.value1 = table_2.value2 where table_1.ID_1 in (select ID_2 from table_2) The queries above do not seem to...
  10. hammertounge

    update with subqueries

    Hi: I am new to foxpro. I inserted a bunch of data into a table but I forgot to include one field. I am trying to use sql to insert the field, something like this: update ttable_1 from table_2 set table_1.MissedField = table_2.MissedField where table1.unique_ID...
  11. hammertounge

    Data binding and multiple sql 2000 tables

    I am working with a human resource database. There are three tables involved: employees, emergency contacts, and ratehistory. The primary key empid in the employee table is also a foreign key in the emergencycontacts and ratehistory tables. My form has a list box bound to the employee table...
  12. hammertounge

    Getting started MSDE, SQL 7, VB 6

    I am looking for sample code for developing a SQL 7 database and destributing it with MSDE. I am building a VB front end. I have read conflicting reports regarding SQL 7. One report stated that MSDE and SQL 7 cannot be installed on one machine at the same time. The MS website recommends that...

Part and Inventory Search

Back
Top