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!

Register Log in
  • Congratulations MikeeOK 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. Criminologist

    INSERT w/SUBSELECT to copy and move data

    I need help and Can't find my answer anywhere. I want to generate an insert w/subselect statement that pulls a recordset of data and inserts it into a temporary database table where I can modify a couple of columns and then use a similar Insert w/Subselect statement to move the fresh data from...
  2. Criminologist

    SQL INSERT problem with FoxPro Boolean

    Does anyone have anything to offer to help me?
  3. Criminologist

    SQL INSERT problem with FoxPro Boolean

    Sure I can. I am writing my SQL statement in VBScript in my asp page and linking to my FxPro table through ODBC. Here is a reduced chunk of my SQL statement as it is long: SQLInsert = "INSERT INTO rccnhd10 (CONTNO, ENDFIRM, INVCOMM) VALUES ('" & NextRecord & "', " &...
  4. Criminologist

    SQL INSERT problem with FoxPro Boolean

    Okay, after some testing, I have determined that whatever the result is going to be, it will require NOT having single quotes. When I tried sending through the SQL statement WITH quotes, I got a data type mismatch, but when I sent it through WITHOUT quotes, the statement sent, but my DB table...
  5. Criminologist

    SQL INSERT problem with FoxPro Boolean

    I am attempting to write an SQL statement that would allow me to create a new record in a FoxPro table and add my fields to it from the web. All has gone well until I attempted to feed my table a boolean and all hell broke loose. I want to have a user answer True/False to a question, have that...
  6. Criminologist

    Changing Recordsource for ADODC at runtime & update Datagrid

    I figured out the problem by myself... The form frmOrder isnt initialized before my data was sent to it, so all I had to do was put the adodc.refresh command in the button on frmEvent and then place the new RecordSource in the form_load event of frmOrder with a refresh. The Adodc will already...
  7. Criminologist

    Changing Recordsource for ADODC at runtime & update Datagrid

    Some background about my project: I am accessing a Visual FoxPro Database Table through ODBC. I am using ADODC data controls and DataGrid controls to display the information. I have 2 forms I am currently working with. The first form (frmEvent) results from a doubleclick on a previous form...

Part and Inventory Search

Back
Top