Recent content by WCL01

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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