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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by WCL01

  1. WCL01

    Creating an incremental field in a create table statement

    I'm looking to create a table that fills in with data from other tables however I have to fill the first field with an incrementing value. I have posted my current statement below that does not work. It seems to put in different numbers in each field instead of 1-30. INSERT into...
  2. WCL01

    Having trouble selecting records based on variables and updating table

    It does work with 'program' = curprog and thank you for the help Olaf.
  3. WCL01

    Having trouble selecting records based on variables and updating table

    Actually Danfreemen that worked out perfect. I understand that I need to get away from using the filter command and that is what I'm doing one section at a time thanks to your help. I was using the filter command in 4 spots and now I'm down to 1. My final and last set filter is below. What...
  4. WCL01

    Having trouble selecting records based on variables and updating table

    My kettle is the second kettle you talked about. What I'm attempting to do is filter out a bunch of records while every record will be different in one way shape or form there is still this one field called TC_ID that can duplicate. There may be 2000 records once filtered however there are only...
  5. WCL01

    Having trouble selecting records based on variables and updating table

    danfreeman thanks for that. Is there a way to count unique records based on a particular field within that record by chance?
  6. WCL01

    Having trouble selecting records based on variables and updating table

    Thanks for all the help everybody. I ended up going a different direction to get the same results. IF INLIST(curservcat, "00015", "00016", "00017", "00018", "00019", "00043", "00044", "00047", "00048") = .F. then USE ai_enc SET FILTER TO 'program' = curprog .and. serv_cat = curservcat .AND...
  7. WCL01

    Having trouble selecting records based on variables and updating table

    This is the sql I'm trying to replicate Olaf. I'm trying to start off small with the one If statement and then once I have that working replicate to the others that I have. declare @curid int, @maxid int, @curprog varchar(5), @curservcat varchar(5), @curconno varchar(10), @cur1yrstartdt...
  8. WCL01

    Having trouble selecting records based on variables and updating table

    I'm very new to foxpro so please be kind. What I'm attempting to do is select a group of records and count on a particular field within those records. Then update a particular field on a particular record within a table. All of this sits inside of a do while loop with a counter to go through...
  9. WCL01

    Setting values for parameters in a select statement

    It does help a little Mike, but I'm still a bit unclear on a few things. the table I'm using does exist and is called era_proj_actuals within my foxpro database. You say to put in curid = 123 (put in an actual id here) Select era_proj_actuals locate for curid curprog = prog_id curservcat =...
  10. WCL01

    Setting values for parameters in a select statement

    I'm trying to duplicate some code I currently run in sql into foxpro. I currently declare some variables in sql and within a select statement set those variables to a value. example: select @curprog = prog_id,@curservcat = serv_cat, @curconno = [5yr_conno], @cur1yrstartdt = [1yr_startdt]...
  11. WCL01

    Issue with Crosstab grouping in .net viewer

    I currently have a crosstab report in crystal 11 that has a grouping along the top by month. Within crystal it works great without any issues and it groups perfectly. However when I try and view the same report in the viewer for my vb.net application it can not perform the grouping at all...
  12. WCL01

    VB login script help

    I'm looking at being able to write a vbs login script that will first check to see if certain drives have been mapped if they have not then map them. Once that has been done check to see if certain shortcuts are currently on the desktop for the user that is logged in. If they are not I want it...
  13. WCL01

    Accessing the record navigation buttons

    PHV, The AbsolutePosition seems to work however the recordcount is something I have already tried and it doesn't work (I did try it again per your advice). Because I'm in form view it just gives a value of 1 because that is all that is being displayed at the time. It does work in datasheet...
  14. WCL01

    Accessing the record navigation buttons

    PHV, I'm not sure what the AbolutePosition is. Is it supposed to be listed under me.forms. ? If so I don't have that particular reference libray installed. If you wouldn't mind putting in the actual code to set lets say variable X = the total records in the form and how to set Y = the...
  15. WCL01

    Accessing the record navigation buttons

    I'm attempting to access the record navigation buttons that normally sit at the bottom of a form. Specificly the current record and the total number of records that a give form has open. I'm not sure if there is a reference library that I need to install or some other command that I'm just...
See more

Part and Inventory Search

Back
Top